Supported data sources - AnalyticDB for MySQL - Alibaba Cloud Documentation Center

AnalyticDB for MySQL provides multiple data import methods to meet data import requirements in different scenarios.


Data source		Import method	References
Database	ApsaraDB RDS for MySQL	External table	Use external tables to import data to Data Warehouse Edition Use external tables to import data to Data Lakehouse Edition
		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
	ApsaraDB RDS for SQL Server	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
	PolarDB-X	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	Use external tables to import data from OSS to AnalyticDB for MySQL Data Warehouse Edition Use external tables to import data to Data Lakehouse Edition
		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
	Apsara File Storage for HDFS	DataWorks	Use DataWorks to import data
Big data	MaxCompute	External table	Use external tables to import data from MaxCompute to AnalyticDB for MySQL Use external tables to import data from MaxCompute to AnalyticDB for MySQL Data Lakehouse Edition
	MaxCompute	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	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

In addition, AnalyticDB for MySQL allows you to asynchronously submit data import tasks. For more information, see Asynchronously submit an import or export task.