Supported Data Sources

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.

Data Source Types

TapData supports various data sources that can serve different roles in data synchronization:

• Source: The origin database or system from which data is read and synchronized
• Target: The destination database or system where data is written and stored

TapData supports both full synchronization and incremental synchronization between these data sources. For detailed support information, refer to the data source support table below.

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
Db2 for i	✅	✅	➖	✅	➖	IBM AS400 v7r4
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
Paimon	➖	➖	➖	✅	➖	0.6 and above
SelectDB	➖	➖	➖	✅	➖	2.0.13 and above
StarRocks	➖	➖	➖	✅	➖	3.0 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 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
TDSQL (MySQL Edition)	✅	✅	✅	✅	✅	5.7, 8.0
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	✅	✅	➖	✅	➖	3.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	✅	✅	✅	✅	✅	All
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 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