Before you configure a data synchronization solution or node, you must prepare data sources that you need to use, purchase an exclusive resource group for Data Integration, and establish network connections between the resource group and data sources. In addition, you must create accounts used to access the databases in the data sources and grant the accounts the permissions that are required to perform operations on the databases. This way, the accounts can be used to perform operations on the databases during data synchronization. This topic describes configurations required for preparing a database that is used for data synchronization.

Configurations required for preparing a database

  • An account to which the required permissions are granted

    Before you configure a data synchronization solution or node, you must create an account that can be used to access a database and grant the account the permissions required to perform specific operations on the database based on your configurations for data synchronization. For example, if a schema that has the same name as the schema in the source database must be created in the destination database during data synchronization, you must grant the account that is used to access the destination database the permissions to create schemas in advance. Statements that are used to grant operation permissions vary based on the database type. You can refer to the documentation for the statement syntax for each type of database to grant the required permissions in advance. This prevents error messages such as Access denied and permission denied from being reported when you configure or run a data synchronization solution or node. You can refer to the answers to the following questions to resolve the permission issue that may occur when you synchronize data from Hologres and MySQL in real time: Real-time synchronization and Real-time synchronization.

  • Other settings

    For specific types of databases, you must also make other preparations such as enabling the binary logging feature or enabling the generation of database-level redo log files.

Configurations required for preparing databases that are used for data synchronization vary based on the database type. You can refer to the related topic to make the preparations.