Data Integration provides the batch synchronization feature, real-time synchronization feature, and solution-based synchronization feature. You can determine the feature that you need to use to configure a data synchronization solution or node based on the number of databases or tables from which you want to read data and the number of tables to which you want to write data. This topic describes how to determine the feature that you need to use based the number of databases or tables.

Background information

  • Before you determine the feature that you need to use, you must have a command of the support of the features for data synchronization. For more information, see Capabilities of the data synchronization features.
  • Before you configure a data synchronization solution or node, you can select the required feature to be used to configure a data synchronization solution or node based on the types of your data sources. For more information, see Supported data source types and read and write operations.
  • In real-time data synchronization scenarios, you must also be familiar with the support of different types of destinations for DDL and DML operations on sources. For more information, see Supported DML and DDL operations.

Select a data synchronization feature

Data Integration can be used to synchronize data in the scenarios described in the following table. You can determine the feature that you need to use to configure a data synchronization solution or node based on the number of databases or tables from which you want to read data and the number of tables to which you want to write data.
Note For more information about how to configure a data synchronization solution or node by using the related feature, see Overview of the batch synchronization feature, Overview of the real-time synchronization feature, and Overview of the solution-based synchronization feature.
Data synchronization scenario Description of the supported features
Data synchronization from a single source table to a single destination table
The following features can be used:
  • Batch synchronization: supports full synchronization and incremental synchronization from a single source table to a single destination table.
  • Real-time synchronization: supports incremental synchronization from a single source table to a single destination table.
  • Solution-based synchronization: supports one-time full synchronization and real-time incremental synchronization from a single source table to a single destination table.
Data synchronization from multiple source tables in multiple databases to multiple destination tables
The following features can be used:
  • Real-time synchronization: supports incremental synchronization from multiple source tables to multiple destination tables.
  • Solution-based synchronization: supports batch synchronization from multiple source tables to multiple destination tables and supports one-time full synchronization and real-time incremental synchronization from multiple source tables to multiple destination tables.
Data synchronization from multiple source tables in multiple databases to a single destination table
The following features can be used:
  • Batch synchronization: supports full synchronization or incremental synchronization from multiple source tables to a single destination table.
  • Real-time synchronization: supports incremental synchronization from multiple source tables to a single destination table.
  • Solution-based synchronization: supports one-time full synchronization and real-time incremental synchronization from multiple source tables to a single destination table.