All Products
Search
Document Center

AnalyticDB for MySQL:Use DataWorks to import data

Last Updated:Mar 14, 2024

This topic describes how to use DataWorks to import data from Object Storage Service (OSS) 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 synchronization task, you must configure the data sources from which you want to read data and to which you want to write data. This way, you can select the data sources when you configure a synchronization task. For information about the supported data source types and the configuration of a data source, see Supported data source types and synchronization operations.

    Note

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

  • The data source environments are prepared. Before you configure a synchronization task, you must create an account that can be used to access a database and grant the account the permissions required to perform specific operations on the database based on your configurations for data synchronization. For more information, see Overview.

Procedure

  1. Add an OSS data source. For more information, see Add an OSS data source.

  2. Add an AnalyticDB for MySQL data source. For more information, see Add an AnalyticDB for MySQL 3.0 data source.

  3. Configure a data synchronization job. For more information, see Configure a synchronization task in Data Integration.