Before you configure a real-time data sync node to synchronize data from a data source to the DataHub data source, you must add both data sources to DataWorks for subsequent source and destination configurations.
Prerequisites
- Prepare data sources: A source data source and a destination data source are created.
- Create and grant permission to an account: An account that is used to access data sources is created.
Precautions
DataWorks provides workspaces in basic mode and standard mode. A workspace in basic mode does not isolate the development environment from the production environment. A workspace in standard mode isolates the development environment from the production environment.
If you use a workspace in standard mode, you must separately add data sources to the development environment and production environment.
Add a source PolarDB for MySQL data source
To add a source PolarDB for MySQL data source, you must configure information such as the network connection type and the access account and password as planned. For more information about how to add a source PolarDB for MySQL data source, see Add a PolarDB data source.
If the source PolarDB for MySQL data source that you want to add fails the connectivity test, follow the instructions described in What do I do if the PolarDB data source cannot be connected? to handle the exception.
Add ApsaraDB for OceanBase as the source
To add ApsaraDB for OceanBase as the source, you must configure information such as the network connection type, and the access account and password as planned. For more information about how to add ApsaraDB for OceanBase as the source, see Add an ApsaraDB for OceanBase data source.
Add a source MySQL data source
To add a source MySQL data source, you must configure information such as the network connection type and the access account and password as planned. For more information about how to add a source MySQL data source, see Add a MySQL data source.
Add DataHub as the destination
For more information, see Add a DataHub data source.
Add a source Oracle data source
To add a source Oracle data source, you must configure information such as the network connection type and the access account and password as planned. For more information about how to add a source Oracle data source, see Add an Oracle data source.
What to do next
After you add data sources, you can create and run a data sync node to synchronize data from the source data source to the destination data source.
For more information, see Configure and manage a real-time data synchronization node.