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 left-side navigation pane, click Workspaces.
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 in the Actions column.
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 add one on the Data Source page.
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.