Scope of Data Source Support
Before using the data synchronization service, to ensure that your synchronization needs are met, please first confirm whether the data synchronization service covers the data sources you need and choose the appropriate task type. Currently, the data synchronization service supports the following three types of synchronization tasks:
- Single Table Offline Synchronization: Suitable for supported data sources, providing offline synchronization functions for single table reading and writing.
- Single Table Real-time Synchronization: For supported data sources, achieving real-time synchronization functions for single table reading and writing.
- Multi-table Real-time Synchronization: For supported data sources, providing one-time full synchronization and real-time incremental synchronization for multiple tables.
The types and versions of data sources currently supported by various task types are as follows (including but not limited to the following types, please refer to the product for the most accurate information):
Offline Synchronization
| Data Source | Release Level | Offline Single Table Read | Offline Single Table Write | Supported Versions |
|---|---|---|---|---|
| Singdata Lakehouse | GA | √ | √ | - |
| ADB MySQL | Public Preview | √ | √ | 3.x |
| ADB PostgreSQL | Public Preview | √ | √ | 6.x |
| AutoMQ | Public Preview | √ | √ | - |
| ClickHouse | GA | √ | √ | 19.x and above |
| COS | GA | √ | √ | - |
| Databricks | Private Preview | √ | √ | - |
| DB2 | Public Preview | √ | √ | 11.x |
| DM | Public Preview | √ | √ | 8.x |
| Doris | Public Preview | √ | √ | 1.x |
| Elasticsearch | GA | √ | √ | 7.x |
| Greenplum | Public Preview | √ | √ | 5 and above |
| HBase | GA | X | √ | 1.4 + |
| Hive | GA | √ | √ | 2.x |
| Hologres | Public Preview | √ | √ | - |
| Kafka | GA | √ | √ | 0.8.x, 0.9.x, 0.10.x, 2.x |
| MaxCompute | GA | √ | X | |
| MariaDB | Public Preview | √ | √ | - |
| MongoDB | GA | √ | X | 3.4 and above |
| MySQL | GA | √ | √ | 5.x, 8.x |
| Oracle | Public Preview | √ | √ | - |
| OSS | GA | √ | √ | - |
| PolarDB | Public Preview | √ | √ | - |
| PostgreSQL | GA | √ | √ | 9.4 and above |
| Redshift | Public Preview | √ | √ | - |
| SQL Server | GA | √ | √ | 2012 and above |
| SLS | GA | √ | X | - |
| StarRocks | Public Preview | √ | √ | 2.5 |
| TiDB | Public Preview | √ | √ | - |
Real-time Synchronization
| Data Source | Release Level | Real-time Single Table Read | Real-time Multi-table Read | Real-time Write | Supported Versions |
|---|---|---|---|---|---|
| Singdata Lakehouse | GA | X | X | √ | - |
| AutoMQ | Public Preview | √ | X | X | - |
| Kafka | GA | √ | X | X | 0.8.x, 0.9.x, 0.10.x, 2.x |
| MySQL | GA | √ | √ | X | 5.x, 8.x |
| PostgreSQL | GA | √ | √ | X | Version 14 and above |
| SQL Server | GA | √ | √ | X | SQL Server 2016 Service Pack 1 (SP1) and above |