Before you configure a real-time data synchronization node to synchronize data from a data source to an Elasticsearch data source, you must add both data sources to DataWorks for subsequent source and destination configurations.

Prerequisites

Before you add a data source, make sure that the following operations are performed:
  • Prepare data sources: A source data source and a destination data source are created.
  • Create and authorize an account: An account that is used to access data sources is created.

Precautions

DataWorks provides workspaces in basic mode and standard mode for you to develop data. 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 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 Configure a MySQL data source.

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 Configure a PolarDB connection.

If the connectivity test fails when you add a PolarDB for MySQL data source, follow the instructions described in What do I do if the PolarDB data source cannot be connected? to handle the exception.

Add the source (SQL Server)

To add an SQL Server 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 an SQL Server data source, see Configure an SQL Server connection.

Add the destination (Elasticsearch)

For more information, see Configure an Elasticsearch connection.

What to do next

After you add data sources, you can create and run a data synchronization solution to synchronize data from the source data source to the destination data source.

For more information, see Configure and view a batch synchronization solution used to synchronize all data in a database or Configure and view a real-time synchronization solution used to synchronize all data in a database.