Added the Field-to-Column Splitting, Field-to-Row Splitting, and Group Summary operators.
4.1.3
When Data Source in the DB Table Input operator was set to DB Table Input:
With Configuration Method set to Table Selection, you could select a source table for data synchronization and enable Parallel Read.
You could call stored procedures if the data source was a MySQL, Oracle, or SQL Server database.
4.1.6.4
Added the MongoDB Output operator, allowing you to output data to a MongoDB database.
4.1.11.3
Added the Elasticsearch Output operator, allowing you to output data to an Elasticsearch database.
4.2.0.2
Added the Elasticsearch Input operator, allowing you to fetch data from a specified Elasticsearch database.
The Data Synchronization node supports cross-database data synchronization. However, if you want to synchronize data to a database after complex processing (such as JSON parsing and multi-table association), you need to use the Data Transformation function, as shown in the following figure.
Data Transformation provides various types of operators such as input, output, and transformation operators, which allow you to achieve complex data processing.
Enter the Data Synchronization node. The following figure shows the Data Synchronization page.
The following table describes the operators in the Data Synchronization node.
Data Input
Allows you to fetch data from tables in relational databases.
For details, see Data Sources Supported by FineDataLink.
In V4.1.3 and later versions, when DB Table Input is selected as the data source type:
With Configuration Method set to Table Selection, you can select a source table for data synchronization and enable Parallel Read.
You can call stored procedures if the data source is a MySQL, Oracle, or SQL Server database.
API Input
File Input
Jodoo Input
MongoDB Input
SAP RFC Input
Elasticsearch Input
Dataset Input
Allows you to fetch data from file datasets (Excel, TXT, XML, and CSV), tree datasets, stored procedures, programs, built-in datasets, and associated datasets. Among them, stored procedures, programs, built-in datasets, and associated datasets can only be defined in FineReport Designer.
Data Output
DB Table Output
Allows you to output data into tables in relational databases.
Parameter Output
API Output
Jodoo Output
File Output
MongoDB Output
Elasticsearch Output
Connection
Data Association
Allows you to associate two tables from different source databases to generate a new table. The join methods are as follows:
Left Join: Returns all records from the left table and the records where the join condition is met in the right table.
Right Join: Returns all records from the right table and the records where the join condition is met in the left table.
Inner Join: Returns only the records where the join condition is met in the two tables.
Full Outer Join: Returns all records from both tables based on the join condition.
Data Comparison
Union All
Transformation
Column to Row
Allows you to convert the columns in a data table to rows.
Row to Column
JSON Parsing
XML Parsing
Field Setting
New Calculation Column
Data Filtering
JSON Generation
Field-to-Column Splitting
Field-to-Row Splitting
Group Summary
Laboratory
Spark SQL
Allows you to query and process data using the built-in Spark calculation engine where parameters and functions are supported.
Python
Others
Remark
Allows you to add remarks to tasks and nodes.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy