Configure AnalyticDB for MySQL Writer - DataWorks - Alibaba Cloud Documentation Center

AnalyticDB for MySQL Writer allows you to build a real-time data warehouse by using the real-time write capability of AnalyticDB for MySQL.

Prerequisites

A reader or conversion node is configured. For more information, see Data source types that support real-time synchronization.

Go to the DataStudio page.
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and O&M > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.
In the Scheduled Workflow pane of the DataStudio page, move the pointer over the icon and choose Create Node > Data Integration > Real-time Synchronization.
Alternatively, you can click the required workflow, right-click Data Integration, and then choose Create > Real-time synchronization.
In the Create Node dialog box, set the Sync Method parameter to End-to-end ETL and configure the Name and Path parameters.
Important
The node name cannot exceed 128 characters in length and can contain only letters, digits, underscores (_), and periods (.).
Click Confirm.
On the configuration tab of the real-time synchronization node, drag AnalyticDB for MySQL 3.0 in the Output section to the canvas on the right. Connect the AnalyticDB for MySQL node and the configured reader or conversion node.

Click the AnalyticDB for MySQL node. In the panel that appears, configure the parameters.

Parameter	Description
Data source	The AnalyticDB for MySQL data source that you have configured. You can select only an AnalyticDB for MySQL data source. If no data source is available, you can click New data source to go to the Data Sources page in Management Center to add a data source. For more information, see Add a Hologres data source.
Table	The name of the AnalyticDB for MySQL table to which you want to write data. You can click One-Click table creation on the right to create a table, or click Data preview to preview the selected table.
Write Mode	The write mode. The only value Replay is displayed. This value indicates that data is updated by row.
Field Mapping	The field mappings between the source and destination. Click Mappings to configure field mappings. The real-time synchronization node synchronizes data based on the field mappings.