All Products
Search

This Product

    AnalyticDB for MySQL:Supported data sources

    Document Center

    AnalyticDB for MySQL:Supported data sources

    Last Updated:Apr 07, 2024

    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

    Database

    ApsaraDB RDS for MySQL

    External table

    Data Warehouse Edition (V3.0)

    Use external tables to import data to Data Warehouse Edition

    Data Lakehouse Edition (V3.0)

    Use external tables to import data to Data Lakehouse Edition

    Data Transmission Service (DTS)

    Data Warehouse Edition (V3.0)

    Use DTS to import data

    Data Lakehouse Edition (V3.0)

    Use DTS to import data

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    ApsaraDB RDS for SQL Server

    DTS

    Data Warehouse Edition (V3.0)

    Use DTS to import data

    Data Lakehouse Edition (V3.0)

    Use DTS to import data

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    PolarDB-X

    DTS

    Data Warehouse Edition (V3.0)

    Use DTS to import data

    Data Lakehouse Edition (V3.0)

    Use DTS to import data

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    PolarDB for MySQL

    Federated analytics

    Data Lakehouse Edition (V3.0)

    Use federated analytics to synchronize data to Data Lakehouse Edition

    DTS

    Data Warehouse Edition (V3.0)

    Use DTS to import data

    Data Lakehouse Edition (V3.0)

    Use DTS to import data

    ApsaraDB for MongoDB

    External table

    Data Lakehouse Edition (V3.0)

    Import data from ApsaraDB for MongoDB to AnalyticDB for MySQL

    Oracle

    DataWorks

    Data Warehouse Edition (V3.0)

    Import data from Oracle

    Data Lakehouse Edition (V3.0)

    Import data from Oracle

    Self-managed MySQL database

    External table

    Data Warehouse Edition (V3.0)

    Import data from a self-managed MySQL database to AnalyticDB for MySQL

    Self-managed HBase database

    DTS

    Data Warehouse Edition (V3.0)

    Import data from a self-managed HBase database

    Storage

    OSS

    External table

    Data Warehouse Edition (V3.0)

    Use external tables to import data to Data Warehouse Edition

    Data Lakehouse Edition (V3.0)

    Use external tables to import data to Data Lakehouse Edition

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    Tablestore

    External table

    Data Lakehouse Edition (V3.0)

    Import data from Tablestore

    Apsara File Storage for HDFS

    External table

    Data Warehouse Edition (V3.0)

    Use external tables to import data to Data Warehouse Edition

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    Big data

    MaxCompute

    External table

    Data Warehouse Edition (V3.0)

    Use external tables to import data to Data Warehouse Edition

    Data Lakehouse Edition (V3.0)

    Use external tables to import data to Data Lakehouse Edition

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    Flink

    Flink

    Data Warehouse Edition (V3.0)

    Import data from Apache Flink

    ApsaraMQ

    Kafka

    Logstash

    Data Warehouse Edition (V3.0)

    Use Logstash to import data to Data Warehouse Edition

    DataWorks

    Data Warehouse Edition (V3.0)

    Use DataWorks to import data

    Data Lakehouse Edition (V3.0)

    Use DataWorks to import data

    Log data

    Log data

    Logstash

    Data Warehouse Edition (V3.0)

    Use Logstash to import data to Data Warehouse Edition

    Simple Log Service

    Data Warehouse Edition (V3.0)

    Use Log Service to transfer log data to AnalyticDB for MySQL

    Local data

    LOAD DATA

    Data Warehouse Edition (V3.0)

    Use LOAD DATA to import data to Data Warehouse Edition

    Import tool

    Data Warehouse Edition (V3.0)

    Use the AnalyticDB for MySQL import tool to import data to Data Warehouse Edition

    Kettle

    Data Warehouse Edition (V3.0)

    Use Kettle to import data to Data Warehouse Edition

    Import data to data lakes

    Important

    • Importing data to data lakes is only suitable for AnalyticDB for MySQL Data Lakehouse Edition (V3.0) clusters.

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

    Category

    Data source

    Import method

    References

    ApsaraMQ

    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

    References

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