All Products
Search

This Product

    AnalyticDB for MySQL:Import data from Oracle

    Document Center

    AnalyticDB for MySQL:Import data from Oracle

    Last Updated:Mar 14, 2024

    This topic describes how to use DataWorks to import data from Oracle 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.

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

    Procedure

    1. Add an Oracle data source. For more information, see Add an Oracle 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.