All Products
Search
Document Center

DataWorks:Configure PolarDB Reader

Last Updated:Aug 01, 2023

PolarDB Reader can read data only from PolarDB for MySQL databases. It cannot read data from 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. In the top navigation bar, select the region in which the workspace that you want to manage resides. On the Workspaces page, find the workspace and click Shortcuts > Data Development in the Actions column.

  2. In the Scheduled Workflow pane, move the pointer over the Create a table icon and choose Create Node > Data Integration > Real-time synchronization.

    Alternatively, right-click the required workflow, and then choose Create Node > Data Integration > Real-time synchronizationReal-time synchronization.

  3. 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 letters, digits, underscores (_), and periods (.).

  4. Click Confirm.

  5. On the configuration tab of the real-time synchronization node, drag PolarDB in the Input section to the canvas on the right.
  6. Click the PolarDB node. In the panel that appears, configure the parameters.
    ParameterDescription
    Data sourceThe PolarDB data source that you have added. Only a PolarDB data source is supported.

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

    TableThe name of the table from which you want to read data. You can click Preview Data to preview data in the selected table.
    Output FieldsThe fields from which you want to read data.
  7. Click the Save icon in the top toolbar to save the configurations.