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
Create the source and destination data sources. For information about data source configuration, see Configure a data source.
For some data sources such as MySQL, Hologres, and Oracle, you must enable the log feature. Different data sources require different methods to enable logs. For information about data source configuration, see Data source list.
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.