Supported data sources for data integration
Data integration supports batch integration and full database migration. This topic describes the types of data sources supported by batch integration, and full database migration.
Use cases for different integration types
Integration type | Use cases |
Batch integration | Ideal for scenarios such as migrating data to the cloud or from the cloud to on-premises systems. For example, you can migrate data from an on-premises MySQL database to an RDS instance. |
Full database migration | Ideal for synchronizing data from a self-managed database in an on-premises data center or on an ECS instance to an offline data warehouse, such as Hive or MaxCompute. For example, you can migrate data from a self-managed MySQL database on an ECS instance to MaxCompute. |
Data sources supported for batch integration
Data source | Read | Write |
Big data storage data sources | ||
MaxCompute | Supported | Supported |
Hive | Supported | Supported |
Hologres | Supported | Supported |
Impala | Supported | Supported |
TDH Inceptor | Supported | Supported |
StarRocks | Supported | Not supported |
Hudi | Supported | Supported |
Doris | Supported | Not supported |
Greenplum | Supported | Supported |
TDengine | Supported | Not supported |
ArgoDB | Supported | Supported |
SelectDB | Supported | Supported |
Databricks | Supported | Supported |
Amazon Redshift | Supported | Supported |
DolphinDB | Supported | Supported |
Snowflake | Supported | Supported |
Data Lake Formation | Supported | Supported |
File data sources | ||
FTP | Supported | Supported |
OSS | Supported | Supported |
Amazon S3 | Supported | Supported |
Message queue data sources | ||
Log Service | Supported | Not supported |
Kafka | Supported | Supported |
RocketMQ | Not supported | Not supported |
DataHub | Supported | Supported |
Relational data sources | ||
PolarDB | Supported | Supported |
PolarDB-X | Supported | Supported |
MySQL | Supported | Supported |
SAP HANA | Supported | Supported |
Microsoft SQL Server | Supported | Supported |
PostgreSQL | Supported | Supported |
AnalyticDB for MySQL 2.0 | Supported | Not supported |
AnalyticDB for MySQL 3.0 | Supported | Supported |
AnalyticDB for PostgreSQL | Supported | Supported |
OceanBase | Supported | Supported |
Oracle | Supported | Supported |
Vertica | Supported | Supported |
IBM DB2 | Supported | Supported |
Teradata | Supported | Supported |
ClickHouse | Supported | Supported |
DM | Supported | Supported |
GBase 8a | Supported | Supported |
KingbaseES | Supported | Supported |
TiDB | Supported | Supported |
GoldenDB | Supported | Supported |
openGauss | Supported | Supported |
GaussDB(DWS) | Supported | Supported |
Amazon RDS for PostgreSQL | Supported | Supported |
Amazon RDS for MySQL | Supported | Supported |
Amazon RDS for SQL Server | Supported | Supported |
Amazon RDS for Oracle | Supported | Supported |
Amazon RDS for DB2 | Supported | Supported |
TDSQL for MySQL | Supported | Supported |
PolarDB-X 2.0 | Supported | Supported |
GBase 8c | Supported | Supported |
TDSQL for PostgreSQL | Supported | Supported |
NoSQL data sources | ||
Elasticsearch | Supported | Supported |
MongoDB | Supported | Supported |
Table Store | Supported | Supported |
Alibaba Cloud HBase | Not supported | Not supported |
Redis | Supported | Not supported |
Easysearch | Supported | Supported |
OpenSearch | Supported | Supported |
InfluxDB | Supported | Supported |
Lindorm | Supported | Supported |
Semi-structured storage data sources | ||
API | Supported | Supported |
SAP Table | Supported | Not supported |
Salesforce | Supported | Not supported |
Lark Base | Supported | Supported |
Supported data sources for full database migration
Data source type | Data source | Related documentation |
Source data source | MySQL, Oracle, Microsoft SQL Server, OceanBase, IBM DB2, MaxCompute, FTP, TDengine, Hive, PostgreSQL, DM, Amazon Redshift, Amazon RDS for PostgreSQL, Amazon RDS for MySQL, Amazon RDS for SQL Server, Amazon RDS for Oracle, Amazon RDS for DB2, TDSQL for MySQL, DolphinDB, PolarDB-X 2.0, GBase 8c | |
Target data source | Hive, MaxCompute, AnalyticDB for PostgreSQL, StarRocks, SelectDB, Doris, GaussDB(DWS), Lindorm, Databricks, and Data Lake Formation. |