Data Transmission Service (DTS) provides a simple and easy-to-use change tracking feature. You only need to perform simple operations in the DTS console to configure the entire change tracking task. The change tracking feature allows you to subscribe to data changes in real time. It helps you achieve lightweight cache updates, business decoupling, asynchronous data processing, and real-time data synchronization through ETL operations.

Precautions

This topic only provides a general procedure for configuring a change tracking channel. However, the procedure will vary according to the data source. For more information about how to configure change tracking channels for specific data sources, see Overview of change tracking scenarios.

Procedure

  1. Create a change tracking task by specifying the region of the source database that is used for data subscription. For more information, see Purchase a change tracking instance.
  2. Log on to the DTS console.
  3. In the left-side navigation pane, click Change Tracking.
  4. At the top of the Change Tracking Tasks page, select the region to which your change tracking task belongs.
  5. Find the created change tracking task and click Configure Channel.
  6. Specify the connection details of the source database that is used for data subscription. Configure the change tracking channel
  7. Click Set Whitelist and Next.
    Note If the source database is in an Alibaba Cloud instance, the IP address of the DTS server is automatically added to the whitelist for the instance. This ensures that the DTS server can connect to the instance.
  8. Specify the data type and objects to which you want to subscribe.Specify the data type and objects to which you want to subscribe
  9. Click Save and Precheck in the lower-right corner.
    Note
    • A precheck is performed before the change tracking task starts. The change tracking task only starts after the precheck succeeds.
    • If the precheck fails, click the Note icon next to each failed check item to view the related details. Fix the issues as instructed and run the precheck again.
  10. If the Precheck dialog box displays The precheck is passed, close the Precheck dialog box.

After the configuration is complete, the initial change tracking starts. This process requires about 1 minute to complete.

References