Supported data sources - AnalyticDB - Alibaba Cloud Documentation Center

AnalyticDB for MySQL allows you to import various data sources, such as ApsaraDB RDS for MySQL, ApsaraDB for MongoDB, Object Storage Service (OSS), MaxCompute, and Kafka, to data warehouses or data lakes. You can select import methods based on different data sources.

Import data to data warehouses

Category	Data source	Import method	Edition	References

Category	Data source	Import method	Edition	References
Database	ApsaraDB RDS for MySQL	External table	Data Warehouse Edition	Use external tables to import data to Data Warehouse Edition
		External table	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use external tables to import data to Data Lakehouse Edition
		Data Transmission Service (DTS)	Data Warehouse Edition	Use DTS to import data
		Data Transmission Service (DTS)	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DTS to import data
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
		Zero-ETL	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use zero-ETL to synchronize data
	ApsaraDB RDS for SQL Server	DTS	Data Warehouse Edition	Use DTS to import data
		DTS	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DTS to import data
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
	PolarDB-X	DTS	Data Warehouse Edition	Use DTS to import data
		DTS	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DTS to import data
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
		One-stop synchronization	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Automatically synchronize the metadata of a PolarDB-X instance to a Data Lakehouse Edition cluster
	PolarDB for MySQL	Federated analytics	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use federated analytics to synchronize data to Data Lakehouse Edition
		DTS	Data Warehouse Edition	Use DTS to import data
		DTS	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DTS to import data
		Zero-ETL	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use zero-ETL to synchronize data
	ApsaraDB for MongoDB	External table	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Import data from ApsaraDB for MongoDB
	Lindorm	Zero-ETL	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Import data from Lindorm
	Oracle	DataWorks	Data Warehouse Edition	Import data from Oracle
	Oracle	DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Import data from Oracle
	Self-managed MySQL database	External table	Data Warehouse Edition	Import data from a self-managed MySQL database
	Self-managed HBase database	DTS	Data Warehouse Edition	Import data from a self-managed HBase database
Storage	OSS	External table	Data Warehouse Edition	Use external tables to import data to Data Warehouse Edition
		External table	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use external tables to import data to Data Lakehouse Edition
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
	Tablestore	External table	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Import data from Tablestore
	HDFS	External table	Data Warehouse Edition	Use external tables to import data to Data Warehouse Edition
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
Big data	MaxCompute	External table	Data Warehouse Edition	Use external tables to import data to Data Warehouse Edition
		External table	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use external tables to import data to Data Lakehouse Edition
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
	Flink	Flink	Data Warehouse Edition	Import data from Apache Flink
Message queue	Kafka	Logstash	Data Warehouse Edition	Use Logstash to import data to Data Warehouse Edition
		DataWorks	Data Warehouse Edition	Use DataWorks to import data
		DataWorks	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use DataWorks to import data
Log data	Log data	Logstash	Data Warehouse Edition	Use Logstash to import data to Data Warehouse Edition
		Simple Log Service	Data Warehouse Edition	Use Simple Log Service to import data to Data Warehouse Edition
		Data synchronization	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use data synchronization to synchronize data from Simple Log Service to Data Warehouse Edition
		Data synchronization	Enterprise Edition, Basic Edition, or Data Lakehouse Edition	Use data synchronization to synchronize data from Simple Log Service to Data Lakehouse Edition
On-premises data		LOAD DATA	Data Warehouse Edition	Use LOAD DATA to import data to Data Warehouse Edition
		Import tool	Data Warehouse Edition	Use the AnalyticDB for MySQL import tool to import data to Data Warehouse Edition
		Kettle	Data Warehouse Edition	Use Kettle to import data to Data Warehouse Edition

Import data to data lakes

When you import data to data lakes, data is written to the specified OSS bucket in the Hudi format.

Important

You can import data to data lakes only in AnalyticDB for MySQL Enterprise Edition, Basic Edition, or Data Lakehouse Edition clusters.

Category	Data source	Import method	References

Category	Data source	Import method	References
Message queue	Kafka	Data synchronization	Use data synchronization to synchronize data from ApsaraMQ for Kafka to Data Lakehouse Edition (recommended)
Log data	Simple Log Service	Data synchronization	Use data synchronization to synchronize data from Simple Log Service to Data Lakehouse Edition (recommended)
Big data	Hive	Data migration	Import data from a Hive data source
Storage	OSS	Metadata discovery	Use metadata discovery to import data to Data Lakehouse Edition

References

AnalyticDB for MySQL allows you to asynchronously submit data import jobs. For more information, see Asynchronously submit an import job.