Supported Data Sources

ClickPipes 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.

GA Data Sources

Type	Logo	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
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
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
BigQuery	✅	➖	➖	✅	➖	Cloud Version
Elasticsearch	✅	➖	➖	✅	➖	5.x, 6.x, 7.x, 8.x
IRIS	✅	✅	➖	✅	➖	2020.x and above

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 ClickPipes 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
Sybase	✅	✅	➖	➖	➖	ASE 16.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
Databend	➖	➖	➖	✅	➖	0.9 and above
Hudi	➖	➖	➖	✅	➖	0.11.0
GaussDB（DWS）	➖	➖	➖	✅	➖	8.1.3
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 ClickPipes 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
Gbase 8a	➖	➖	➖	✅	➖	8x
Gbase 8s	➖	➖	➖	✅	➖	8x
KingBaseES-R3	✅	➖	➖	✅	✅	V8R3
OceanBase（MySQL Mode）	✅	✅	✅	✅	✅	3.x, 4.x
OceanBase（Oracle Mode）	✅	✅	✅	✅	✅	4.x
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