All Products
Search
Document Center

AnalyticDB for MySQL:Use DataWorks to import data

Last Updated:Mar 15, 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 ApsaraDB RDS for SQL Server to AnalyticDB for MySQL Data Lakehouse Edition (V3.0) or Data Warehouse Edition (V3.0).

Prerequisites

Procedure

  1. Add an ApsaraDB RDS for SQL Server data source. For more information, see Add an SQL Server 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 batch data synchronization job. For more information, see Configure a batch synchronization task by using the codeless UI.