Supported Data Sources

TapData Cloud offers you cloud services that are suitable for scenarios requiring rapid deployment and low initial investment, helping you focus more on business development rather than infrastructure management. Free trial with TapData Cloud.TapData Enterprise can be deployed in your local data center, making it suitable for scenarios with strict requirements on data sensitivity or network isolation. It can serve to build real-time data warehouses, enable real-time data exchange, data migration, and more.TapData Community is an open-source data integration platform that provides basic data synchronization and transformation capabilities. This helps you quickly explore and implement data integration projects. As your project or business grows, you can seamlessly upgrade to TapData Cloud or TapData Enterprise to access more advanced features and service support.

TapData supports rich data sources as follows:

tip

If you need to synchronize DDL operations, you need to enable DDL collection and DDL apply. For more information, see Handle DDL Changes During Data Sync.

Synchronization Types

TapData supports two types of synchronization: full synchronization and incremental synchronization, covering both one-way and two-way synchronization scenarios. It is compatible with a variety of data sources, as described below:

• One-Way Synchronization: Data is synchronized from the source to the target data source. For detailed support information on incremental synchronization, refer to the data source support table in this document.
• Two-Way Synchronization: Enables real-time bidirectional data flow between source and target data sources, ensuring data consistency on both ends. For detailed configuration steps, see Bidirectional Synchronization Case. Currently, the following data sources support Two-Way Synchronization, applicable to both full and incremental synchronization scenarios:
  • MySQL ↔ MySQL
  • PostgreSQL ↔ PostgreSQL
  • MongoDB ↔ MongoDB
  • PostgreSQL ↔ MySQL
  • SQL Server ↔ SQL Server

GA Data Sources

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
AWS ClickHouse	✅	✅	➖	✅	✅	23 and above
ClickHouse	✅	✅	➖	✅	✅	20.x, 21.x, 22.x, 23.x, 24.x
Dameng	✅	✅	✅	✅	✅	7.x, 8.x
Db2	✅	✅	✅	✅	✅	9.7~11.x（support Linux, UNIX, Windows, AIX and AS400 platform）
Doris	✅	✅	➖	✅	✅	1.2 ~ 3.0
GaussDB（DWS）	✅	✅	➖	✅	✅	8.1.3
Kafka-Enhanced	✅	✅	➖	✅	➖	Kafka 2.0 ~ 2.5 or Scala 2.12
Kafka	✅	✅	✅	✅	✅	2.3.x
KingBaseES-R6	✅	✅	➖	✅	✅	R6 V8 ~ V9
MongoDB	✅	✅	➖	✅	➖	4.0 and above
MongoDB Below 3.4	✅	✅	➖	✅	➖	3.2 or 3.4
MySQL	✅	✅	✅	✅	✅	5.0 ~ 9
OceanBase(MySQL Mode)	✅	✅	✅	✅	✅	4.x
OceanBase(Oracle Mode)	✅	✅	✅	✅	✅	4.x
Oracle	✅	✅	✅	✅	✅	9i, 10g, 11g, 12c, 18c, 19c+
PostgreSQL	✅	✅	➖	✅	✅	9.4～16
SQL Server	✅	✅	✅	✅	✅	2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, 2022
Sybase	✅	✅	➖	✅	➖	16
TiDB	✅	✅	✅	✅	✅	6.0.0 ～ 8.1.9

Beta Data Sources

tip

The beta version of the data sources is in public preview and has passed the basic test cases and integration test cases, but has not yet passed the TapData certification test process. If you have any questions during use, please contact us.

On-Premises Databases

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
Custom Connection	✅	✅	➖	✅	➖	N/A
DummyDB	✅	✅	➖	✅	➖	N/A
Informix	✅	✅	➖	✅	➖	10 and above
Mock Source	✅	✅	➖	➖	➖	N/A
Mock Target	➖	➖	➖	✅	➖	N/A
MariaDB	✅	✅	✅	✅	✅	10.x
Redis	➖	➖	➖	✅	➖	2.8 ~ 6.0
TDengine	✅	✅	➖	✅	✅	3.x
Vastbase	✅	✅	➖	✅	✅	G100 2.2

Data Warehouse and Data Lake

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
BigQuery	➖	➖	➖	✅	➖	N/A
Databend	➖	➖	➖	✅	➖	0.9 and above
Hudi	➖	➖	➖	✅	➖	0.11.0
SelectDB	➖	➖	➖	✅	➖	2.0.13 and above
YashanDB	➖	➖	➖	✅	➖	1.0

Cloud Databases/Files/SaaS

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
Azure CosmosDB	✅	➖	➖	➖	➖	N/A
Coding	✅	✅	➖	➖	➖	N/A
CSV	✅	✅	➖	➖	➖	N/A, file locations supported include local, FTP, SFTP, SMB, S3FS, OSS
Excel	✅	✅	➖	➖	➖	XLS/XLSX, file locations supported include local, FTP, SFTP, SMB, S3FS, OSS
Huawei's Cloud GaussDB	✅	✅	➖	✅	✅	Enterprise version 2.8 (primary-standby), supports Standby version 8.1 for on-prem deployment
HubSpot	✅	➖	➖	➖	➖	N/A
Lark-IM	➖	➖	➖	✅	➖	N/A
LarkTask	➖	➖	➖	✅	➖	N/A
Metabase	✅	➖	➖	➖	➖	N/A
Salesforce	✅	✅	➖	➖	➖	N/A
Zoho-CRM	✅	➖	➖	➖	➖	N/A
Zoho-Desk	✅	✅	➖	➖	➖	N/A

Alpha Data Sources

tip

The Alpha version of the data sources is in public preview and has passed the basic test cases, but has not yet passed the integration test cases and the TapData certification test process. If you have any questions during use, please contact us.

On-Premises Databases

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
Elasticsearch	➖	➖	➖	✅	➖	5.x, 6.x, 7.x
Gbase 8a	➖	➖	➖	✅	➖	8x
Gbase 8s	➖	➖	➖	✅	➖	8x
KingBaseES-R3	✅	➖	➖	✅	✅	V8R3
OpenGauss	✅	➖	➖	✅	✅	3.0.0 and above
MySQL PXC	✅	✅	➖	✅	➖	5.0, 5.1, 5.5, 5.6, 5.7, 8.x
QuickAPI	✅	➖	➖	➖	➖	N/A

Data Warehouse and Data Lake

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
GreenPlum	✅	✅	➖	✅	➖	N/A
Hive1	➖	➖	➖	✅	➖	1
Hive 3	➖	➖	➖	✅	➖	3.1.2 and above

Cloud Databases

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
AWS RDS MySQL	✅	✅	➖	✅	➖	MySQL 5.0, 5.1, 5.5, 5.6, 5.7, 8.x
Aliyun Tablestore	➖	➖	➖	✅	➖	5.13.9
Aliyun AnalyticDB MySQL	✅	✅	➖	➖	➖	5.0, 5.1, 5.5, 5.6, 5.7, 8.x
Aliyun AnalyticDB PostgreSQL	✅	✅	➖	✅	➖	9.4, 9.5, 9.6, 10.x, 11.x, 12
Aliyun RDS MySQL	✅	✅	➖	✅	➖	5.0, 5.1, 5.5, 5.6, 5.7, 8.x
Aliyun RDS MariaDB	✅	✅	➖	✅	➖	10.3
Aliyun RDS MongoDB	✅	✅	➖	✅	➖	3.2, 3.4, 3.6, 4.0, 4.2
Aliyun RDS PostgreSQL	✅	✅	➖	✅	➖	9.4, 9.5, 9.6, 10.x, 11.x, 12
Aliyun RDS SQL Server	✅	✅	➖	✅	➖	2008 R2, 2012, 2014, 2016, 2017, 2019
PolarDB MySQL	✅	✅	➖	✅	➖	5.6, 5.7, 8.0
PolarDB PostgreSQL	✅	✅	➖	✅	➖	11
TencentDB MariaDB	✅	✅	➖	✅	➖	MariaDB 10.1.9, Percona 5.7.17, MySQL 8.0.18
TencentDB MongoDB	✅	✅	➖	✅	➖	3.2, 3.4, 3.6, 4.0, 4.2
TencentDB MySQL	✅	✅	➖	✅	➖	5.5, 5.6, 5.7, 8.x
TencentDB PostgreSQL	✅	✅	➖	✅	➖	9.4, 9.5, 9.6, 10.x, 11.x, 12
TencentDB SQL Server	✅	✅	➖	✅	➖	2008 R2, 2012, 2016, 2017, 2019

Message Queue and Middleware

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
ActiveMQ	✅	✅	➖	✅	➖	5.14.x
AI Chat	➖	➖	➖	✅	➖	N/A
Hazelcast	➖	➖	➖	✅	➖	5.20, 5.21
RabbitMQ	✅	✅	➖	✅	➖	3.8.x
RocketMQ	✅	✅	➖	✅	➖	4.9.x

File/SaaS

Type	As a source			As a target		Versions
	Full data synchronization	Incremental data synchronization	DDL event collection	Data write	DDL event apply
Alibaba 1688	✅	✅	➖	➖	➖	N/A
BesChannels	➖	➖	➖	✅	➖	N/A
Feishu-Bitable	✅	✅	➖	✅	➖	N/A
JSON	✅	✅	➖	➖	➖	N/A, file locations supported include local, FTP, SFTP, SMB, S3FS, OSS
Lark Approval	✅	➖	➖	➖	➖	N/A
Lark Doc	✅	➖	➖	➖	➖	N/A
Shein	✅	✅	➖	➖	➖	N/A
Vika	➖	➖	➖	✅	➖	V1
XML	✅	✅	➖	➖	➖	N/A, file locations supported include local, FTP, SFTP, SMB, S3FS, OSS