DTS supports data transmission between different data sources, such as RDBMS, NoSQL, and OLAP databases. Multiple data transmission features are available in DTS, including data migration, real-time change tracking, and real-time data synchronization. Compared with third-party data streaming tools, DTS provides multiple types of transmission channels with high performance, security, and reliability. DTS also makes it easy to create and manage transmission channels.
DTS supports data migration between multiple types of homogeneous and heterogeneous data sources, such as from Oracle to MySQL, or from Oracle to Postgres Plus Advanced Server (PPAS). For migration between heterogeneous data sources, DTS supports schema conversion. For example, you can convert a synonym in Oracle to a synonym in PPAS.
DTS supports multiple data transmission features, including data migration, real-time change tracking, and real-time data synchronization. In real-time change tracking and real-time data synchronization, data is transmitted in real time.
Real-time data synchronization supports one-way and two-way synchronization between two data sources. This feature applies to the following scenarios: geo-disaster recovery, active geo-redundancy, nearby application access, query load balancing, and real-time data warehousing.
DTS supports data migration with minimized downtime to ensure availability. The application downtime during data migration is reduced to minutes.
DTS uses servers with high specifications to ensure the performance of each synchronization or migration channel.
The infrastructure of DTS has been optimized to ensure high-speed and reliable data migration. The peak rate of full data migration can reach 70 MB per second or 200,000 transactions per second (TPS).
DTS provides better synchronization performance compared to traditional data synchronization tools. With the real-time synchronization feature, you can simultaneously synchronize the incremental data for one table. During peak hours, the data synchronization performance can reach 30,000 records per second (RPS).
Security and reliability
DTS is implemented based on clusters. If a node in a cluster is down or faulty, the control center moves all tasks from this node to another healthy node in the cluster within seconds.
DTS provides a 24 x 7 mechanism for validating data accuracy in some transmission channels to discover and rectify inaccurate data. This helps ensure reliable data transmission.
Secure transmission protocols and tokens are used for authentication across DTS modules to ensure reliable data transmission. DTS also supports resumable transmission.
Ease of use
The DTS console is a visual management interface that provides a wizard-like process to assist you in creating data transmission channels.
The DTS console also visualizes information about transmission channels to facilitate channel management, such as transmission status, progress, and performance.
DTS supports resumable transmission and regularly monitors channel status. If DTS detects an error such as network failure or system exception, it automatically fixes the error and restarts the channel. If the error persists, you need to manually repair and restart the channel in the DTS console.