Data Integration supports offline integration, real-time integration, and whole database migration integration methods. This topic describes the data source types supported by offline integration, real-time integration, and whole database migration.
Scenarios for different integration types
Integration type | Scenarios |
Offline integration | Applicable to scenarios such as data migration to the cloud and cloud data migration to on-premises business systems. For example, you can migrate data from an on-premises MySQL database to ApsaraDB RDS. |
Whole database migration | Applicable to scenarios such as synchronizing data from databases in data centers or self-built databases on ECS to offline data warehouses (Hive) and big data compute services. For example, you can migrate data from a self-built MySQL database on ECS to MaxCompute. |
Real-time integration | Applicable to scenarios where data changes in the entire database or all tables of the source data source are integrated into the destination data source in real time, achieving real-time data synchronization between the source and destination data sources. |
Data sources supported by offline 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 |
Kudu | supported | supported |
StarRocks | supported | supported |
Hudi | supported | supported |
Doris | supported | supported |
GreenPlum | supported | Support |
TDengine | Support | Not supported |
ArgoDB | Support | supported |
Paimon | Not supported | Not supported |
SelectDB | supported | supported |
Databricks | supported | supported |
Amazon Redshift | Support | supported |
DolphinDB | Supported | Not supported |
File data sources | ||
HDFS | supported | supported |
FTP | supported | supported |
OSS | supported | supported |
Amazon S3 | supported | supported |
Message queue data sources | ||
Log Service | supported | Not supported |
Kafka | supported | supported |
DataHub | supported | supported |
Relational data sources | ||
PolarDB | supported | supported |
PolarDB-X (formerly DRDS) | Support | supported |
MySQL | supported | supported |
SAP HANA | supported | supported |
Microsoft SQL Server | Supported | supported |
PostgreSQL | Support | 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 | Support | Support |
Vertica | supported | Support |
IBM DB2 | supported | supported |
Teradata | supported | supported |
ClickHouse | supported | supported |
Dameng (DM) | supported | supported |
GBase 8a | supported | supported |
KingbaseES | supported | supported |
TiDB | supported | supported |
GoldenDB | Support | 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 | Support |
NoSQL data sources | ||
HBase0.9.4 | Not supported | Not supported |
HBase1.1x | supported | supported |
HBase2.0 | supported | supported |
Elasticsearch | supported | supported |
MongoDB | supported | supported |
Tablestore | supported | Support |
Aliyun HBase | Not supported | Not supported |
Redis | supported | Not supported |
Lindorm (compute engine) | supported | supported |
Easysearch | Supported | Supported |
OpenSearch | Not supported | Supported |
Semi-structured storage data sources | ||
API | supported | supported |
SAP Table | supported | Not supported |
Salesforce | supported | Not supported |
Data sources supported by whole database migration
Data source type | Data source | References |
Source data source | MySQL, Oracle, Microsoft SQL Server, OceanBase, IBM DB2, MaxCompute, FTP, TDengine, Hive, PostgreSQL, DM (Dameng), 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, and PolarDB-X 2.0 . | |
Destination data source | ArgoDB, Hive, TDH Inceptor, MaxCompute, AnalyticDB for PostgreSQL, StarRocks, SelectDB, Doris, GaussDB (DWS), Lindorm (compute engine), Databricks. |
Data sources supported by real-time integration
Real-time computing engine | Data source | References |
Flink on YARN |
| |
Flink on K8s |
| |
Realtime Compute for Apache Flink (VVP) |
|