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

Prerequisites

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

Procedure

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where the required workspace resides, find the workspace, and then click Data Analytics.
  2. On the DataStudio page, move the pointer over the Create icon and choose Data Integration > Real-time synchronization.
    Alternatively, right-click the required workflow and choose Create > Data Integration > Real-time synchronization.
  3. In the Create Node dialog box, set Node Name and Location.
    Notice The name of the node. The name must be 1 to 128 characters in length and can contain letters, digits, underscores (_), and periods (.).
  4. Click Commit.
  5. On the configuration tab of the real-time synchronization node, drag AnalyticDB MySQL 3.0 in the Output section to the canvas on the right. Connect the AnalyticDB for MySQL node to the configured reader or conversion node.
  6. 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, click New data source on the right to add a data source on the Data Source page. For more information, see Configure an AnalyticDB for MySQL 3.0 connection.

    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. Data is updated by row.
    Field Mapping The field mappings between the source and destination. Click Field Mapping and configure field mappings between the source and destination. The synchronization node synchronizes data based on the field mappings.
  7. Click Save in the top toolbar to save the node.