PolarDB Reader can read data only from PolarDB for MySQL databases. It cannot read data from PolarDB for PostgreSQL databases.
Procedure
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 . On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.
In the Scheduled Workflow pane, move the pointer over the icon and choose .
Alternatively, right-click the required workflow, and then choose
.In the Create Node dialog box, set the Sync Method parameter to End-to-end ETL and configure the Name and Path parameters.
ImportantThe node name cannot exceed 128 characters in length and can contain letters, digits, underscores (_), and periods (.).
Click Confirm.
On the configuration tab of the real-time synchronization node, drag PolarDB in the Input section to the canvas on the right.
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.
Click the icon in the top toolbar to save the configurations.