Use DataWorks to move data from an Oracle database into AnalyticDB for MySQL. DataWorks Data Integration handles the connection and transfer — you configure data sources and a synchronization task.
Prerequisites
Before you begin, ensure that you have:
-
Configured both the source (Oracle) and destination (AnalyticDB for MySQL) data sources. For supported source and destination types, see Supported data source types and synchronization operations. For data source configuration requirements, see Data source overview
Synchronize Oracle data
-
Add an Oracle data source. For details, see Add an Oracle data source.
-
Add an AnalyticDB for MySQL data source. For details, see AnalyticDB for MySQL 3.0 data source.
-
Configure a data synchronization job. For details, see Configure a synchronization task in Data Integration.