PolarDB Reader can read data only from PolarDB for MySQL databases. It cannot read data from PolarDB for PostgreSQL databases.

Prerequisites

The real-time synchronization feature is in the phased release stage. To activate this feature, submit a ticket.

Procedure

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. Select the region where the required workspace resides, find the workspace, and then click Data Analytics.
  2. Move the pointer over the Create icon and choose Data Integration > Real-time synchronization.
    Alternatively, you can click the required workflow, right-click Data Integration, and then choose Create > Real-time synchronization.
  3. In the Create Node dialog box, set the Node Name and Location parameters.
    Notice The node name must be 1 to 128 characters in length. It can contain letters, digits, underscores (_), and periods (.).
  4. Click Commit.
  5. On the configuration tab of the real-time sync node, drag PolarDB under Input to the canvas on the right.
  6. Click the new PolarDB node. In the configuration pane that appears, set the required parameters in the Node configuration section.
    Parameter Description
    Data source The connection to the PolarDB for MySQL data store. In this example, you can select only a PolarDB for MySQL connection.

    If no connection is available, click New data source on the right to add one on the Data Source page.

    Table The name of the table from which data is read in PolarDB. You can click Data preview on the right to preview the selected table.
    Output field The fields from which data is read.
  7. Click the Save icon in the toolbar.