Overview
Version
FineDataLink Version | FineBI 6.1 Version | Functional Change |
|---|---|---|
BI 6.1 | / | |
BI 6.1.1 | Updated the subtables of the output BI dataset in FineDataLink V4.1.10.4. | |
 Note:For details about subsequent version compatibility and updates, see Version Compatibility Description. | ||
Application Scenario
The data in the data warehouse is not fully in a final form, and needs further processing to form basic data for analysis. You may want to use FineDataLink to process some data, and write the data directly into Public Data of FineBI.
Function Description
You can use the Dataset Output operator of the Data Transformation node or the Data Synchronization node to write data directly to the specified directory of Remote Public Data.
Prerequisite
Modify the configurations of FineDB before using this function. For details, contact FanRuan technical support. You can send an email to international@fanruan.com or click
at https://help.fanruan.com/finedatalink-en/.Ensure the Data Transfer - Basic Operator Package function point is registered.
If FineBI or FineDataLink has been configured with a firewall, port 50051 needs to be opened.
The version of FineDataLink needs to match that of FineBI. For details, see Version Compatibility Description.
Use Public Data as the data connection to create connection between FineDataLink and FineBI, as shown in the following figure.
Function Description
Configuration Content | Configuration Item | Description | |
|---|---|---|---|
Data Destination and Mapping | Target Table | Existing Table Auto Created Table | If Auto Created Table is selected, you need to select the table storage path. |
Field Mapping | Mapping Method:
| ||
Mapping Operation:
| |||
Mapping Configuration:
| |||
Mapping Configuration:
| |||
Write Method | Write Method |
Configuring logical primary keys is not supported.
| The following operations are not supported:
|
Notes
Note:Outputting data table scheduling and updating progress can only be controlled by scheduled tasks and manual task execution in FineDataLink.
If FineDataLink is updated to V4.1.10.4, the subtables of the output BI dataset will also be updated.
General configurations of table names and capitalization/decapitalization of field names are not supported yet.
Configuring Dirty Data Tolerance is not supported. If a row of data fails, the entire writing operation will fail and be rolled back.
Writing data into Public Data is not supported in FineBI 6.1 with the multi-node compute-storage separation architecture.
Procedure
For example, the data in your own data warehouse is not finalized, and you may want to further process it into public data for FineBI analysis.
Processing Data
Create a scheduled task in Data Development, as shown in the following figure.
Process the data fetched with the Data Transformation node. In this example, data tables are associated and fields are set, as shown in the following figure.
For details, see Data Association and Field Setting.
Outputting Data to Public Data of FineBI
Use the Dataset Output operator to output the processed data to FineBI. Select Remote Public Data and the corresponding data connection as the data source, and configure the target table. If you select Auto Created Table, you need to select the table path under Public Data for the data to be output to, as shown in the following figure.
Configure Write Method. You can select Write Data into Target Table After Emptying It or Write Data into Target Table Directly, as shown in the following figure.
Effect Display
After running the task, you can view the output data table in the specified location of Public Data in FineBI. You can use the ETL result table in Public Data for analysis.
Previous：DB Output (Transaction)
