Database | ApsaraDB RDS for MySQL | External table | |
Data Transmission Service (DTS) | Migrate data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for MySQL V3.0 cluster |
DataWorks | Use DataWorks to import data |
ApsaraDB RDS for SQL Server | DTS | Migrate data from an ApsaraDB RDS for SQL Server instance to an AnalyticDB for MySQL V3.0 cluster |
DataWorks | Use DataWorks to import data |
PolarDB-X | DTS | Migrate data from a PolarDB-X 2.0 instance to an AnalyticDB for MySQL V3.0 cluster |
DataWorks | Use DataWorks to import data |
PolarDB MySQL | DTS | Migrate data from a PolarDB for MySQL cluster to an AnalyticDB for MySQL V3.0 cluster |
ApsaraDB for MongoDB | External table | Import data from ApsaraDB for MongoDB to AnalyticDB for MySQL |
Oracle | DataWorks | Add an Oracle data source |
Self-managed MySQL database | External table | Import data from a self-managed MySQL database to AnalyticDB for MySQL |
Self-managed HBase database | DTS | Migrate data from a self-managed HBase database to an AnalyticDB for MySQL V3.0 cluster |
Storage | Object Storage Service (OSS) | Metadata discovery | Perform metadata discovery |
External table | |
DataWorks | Add an OSS data source |
Tablestore | External table | Use external tables to import data from Tablestore to AnalyticDB for MySQL Data Lakehouse Edition |
Apsara File Storage for HDFS | External table | Use external tables to import data from Apsara File Storage for HDFS to AnalyticDB for MySQL |
DataWorks | Use DataWorks to import data |
Big data | MaxCompute | External table | |
DataWorks | Use DataWorks to import data |
Flink | Flink | Use Apache Flink to write data to AnalyticDB for MySQL |
Message Queue | Kafka | Real-time data ingestion | Ingest data from Message Queue for Apache Kafka to an AnalyticDB for MySQL lakehouse in real time for analysis |
Logstash | Use Logstash to write Apache Kafka data to AnalyticDB for MySQL |
DataWorks | Use DataWorks to import data |
Log data | Log Service | Real-time data ingestion | Ingest data from Log Service to an AnalyticDB for MySQL lakehouse in real time for analysis |
Log data | Logstash | Use Logstash to collect log data in real time |
Local data | LOAD DATA | Use the LOAD DATA statement to import local data |
Import tool | Use the AnalyticDB for MySQL import tool to import data to Data Warehouse Edition |
Kettle | Use Kettle to synchronize local data to AnalyticDB for MySQL |