Currently, an ApsaraDB for PolarDB reader can only read data from ApsaraDB PolarDB for MySQL databases instead of ApsaraDB PolarDB for PostgreSQL databases.

Procedure

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. On the Workspaces page that appears, select the region where the target workspace resides, find the target workspace, and then click Data Analytics in the Actions column. The DataStudio page appears.
  2. On the Data Analytics tab, move the pointer over the Create icon and choose Data Integration > Real-Time Sync.
    You can also find the target workflow, right-click Data Integration, and then choose Create > Real-Time Sync.
  3. In the Create Node dialog box that appears, set Node Name and Location.
    Notice A node name must be 1 to 128 characters in length and can contain letters, digits, underscores (_), and periods (.). It is case-insensitive.
  4. Click Commit.
  5. On the configuration tab of the real-time sync node, drag PolarDB under Reader to the editing panel.
  6. Click PolarDB1. In the pane that appears on the right, set the required parameters in the Node Settings section.
    Parameter Description
    Connection The connection to the ApsaraDB PolarDB for MySQL data store. In this example, you can only select an ApsaraDB PolarDB for MySQL connection.

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

    Table The name of the table from which data is read in the ApsaraDB PolarDB for MySQL data store. You can click Preview on the right to preview the selected table.
    Output Fields The fields from which data is read.
  7. Click the Save icon in the toolbar.