All Products
Search

This Product

    AnalyticDB:Use DataWorks to import data

    Document Center

    AnalyticDB:Use DataWorks to import data

    Last Updated:Mar 12, 2024

    DataWorks provides a visual data import method. Compared with external tables, DataWorks is more suitable when only a small amount of data needs to be imported. This topic describes how to use DataWorks to import data from PolarDB-X to AnalyticDB for MySQL Data Lakehouse Edition (V3.0) or Data Warehouse Edition (V3.0).

    Prerequisites

    • The required data sources are configured. Before you configure a data synchronization task, you must configure the data source from which you want to read data and the data source to which you want to write data. This way, when you configure a batch synchronization task, you can select the data sources. For information about the data source types that are supported by batch synchronization, see Supported data source types, Readers, and Writers.

      Note

      For information about the items that you need to understand before you configure a data source, see Overview.

    • An exclusive resource group for Data Integration that meets your business requirements is purchased. For more information, see Create and use an exclusive resource group for Data Integration.

    • Network connections between the exclusive resource group for Data Integration and data sources are established. For more information, see Establish a network connection between a resource group and a data source.

    Procedure

    1. Configure the source database reader. For more information, see DRDS Reader.

    2. Configure the destination database writer. For more information, see AnalyticDB for MySQL 3.0 Writer.

    3. Configure a data synchronization job. For more information, see Configure a batch synchronization task by using the codeless UI.