Supported data sources

Updated at: 2025-03-18 09:07

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

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

Enterprise Edition, Basic Edition, or Data Lakehouse Edition

Use DTS to import data

DataWorks

Data Warehouse Edition

Use DataWorks to import data

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

Enterprise Edition, Basic Edition, or Data Lakehouse Edition

Use DTS to import data

DataWorks

Data Warehouse Edition

Use DataWorks to import data

Enterprise Edition, Basic Edition, or Data Lakehouse Edition

Use DataWorks to import data

PolarDB-X

DTS

Data Warehouse Edition

Use DTS to import data

Enterprise Edition, Basic Edition, or Data Lakehouse Edition

Use DTS to import data

DataWorks

Data Warehouse Edition

Use DataWorks to import data

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

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

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

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

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

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

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

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

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.

  • On this page (1, T)
  • Import data to data warehouses
  • Import data to data lakes
  • References
Feedback
phone Contact Us