Data Synchronization - Database Table

Relevant functions of the Data Synchronization node have been introduced in Overview of Data Synchronization.

This document introduces how to extract all data from the SProduct2 table of a MySQL database to another MySQL database through a specific example.

Creating a Task

1. Create a scheduled task and drag the Data Synchronization node onto the page, as shown in the following figure.

Configuring the Data Source

Select MySQL in Data Source and fdl_demotest in Data Connection, and enter the following SQL statement: SELECT * FROM `demo1`.`SProduct2`.

The drop-down lists of Data Source and Data Connection only contain the data sources configured in Data Connection on which you have Use permission.

Notes:

If you have Use permission on multiple databases connected via the selected data connection, specify the table in the format of Database.Table name in the SQL statement.

Click Data Preview to view the fetched data, as shown in the following figure.

Configuring the Data Destination and Mapping

Select MySQL in Data Source and fdl_demotest in Data Connection. If no table has been created in advance, select Auto Created Table in Target Table. If a table has been created in advance in the target database, select the created table.

Field mapping enables you to view or modify the field relationship between the source table and the target table. The default setting is used here, as shown in the following figure.

Configuring the Write Method

Select Append in Write Method. If a scheduled task is set and executed regularly, the synchronized data will be mapped according to the configured logical primary key (ensuring data uniqueness) and appended to the target data table, as shown in the following figure.

Running the Node

Right-click the node and select Run Node. If the message indicating the successful execution appears in the log below, the node is executed successfully.

After the node is run successfully, the data has been synchronized to the product data table in the target MySQL database, as shown in the following figure.