Add a relational database as the source node in a Data Transmission Service (DTS) Streaming extract, transform, and load (ETL) task. The source node reads data from the database and feeds it into your data flow on the DAG canvas.
Prerequisites
Before you begin, make sure you have:
An ETL task in one of the following regions: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Shenzhen), China (Guangzhou), or China (Hong Kong)
A source database of one of the following types: MySQL, PolarDB for MySQL, Oracle, PostgreSQL, iSeries DB2 (AS/400), Db2 for LUW, PolarDB-X 1.0, PolarDB for PostgreSQL, MariaDB, PolarDB for Oracle, SQL Server, or PolarDB-X 2.0
A database instance registered in Data Management (DMS)
Add and configure the source node
The following steps use a self-managed MySQL database as an example.
Log on to the Data Management (DMS) console.
In the top navigation bar, move your pointer over DTS, then choose Data integration > Streaming ETL.
In the upper-left corner of the Streaming ETL page, click
. In the Create Data Flow dialog box, enter a name in the Data Flow Name field and set Development Method to DAG.Click OK.
On the left side of the canvas, drag an Input/Dimension Table MySQL node to the canvas.
Click the Input/Dimension Table MySQL-1 node to open its settings.
On the Node Settings tab, configure the following parameters.
On the Output Fields tab, select the columns to include in the output.
If Node Type is Stream Table, click the Time Attribute tab and configure the following parameters.
Verify the configuration
Check the node on the canvas. The source database is configured successfully when no 
icon appears on the right side of the node.