All Products
Search
Document Center

DataWorks:Configure PolarDB Reader

Last Updated:Nov 19, 2024

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.

    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 Governance > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

  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.

    Parameter

    Description

    Data source

    The 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 go to the Data Sources page of Management Center and add a data source.

    Table

    The name of the table from which you want to read data. You can click Preview Data to preview data in the selected table.

    Output Fields

    The fields from which you want to read data.

  7. Click the Save icon in the top toolbar to save the configurations.