OceanBase Migration Service (OMS) allows you to download the settings of synchronization objects in a data synchronization task and supports automatic settings and verification of object settings based on imported CSV files. This enables you to save task settings and configure multiple tasks at a time. The import feature is suitable for renaming and setting hundreds of objects at a time.
Format requirements for importing objects
When you synchronize data from an ODP logical table to the MySQL compatible mode of OceanBase Database, the CSV file must contain the following columns:
Source database name, source table name, target database name, target table name, column mapping, and sharding columns (separated by semicolons).
For data synchronization tasks other than those that synchronize data from ODP logical tables to the MySQL compatible mode of OceanBase Database, the CSV file must contain the following columns:
Source database name, source table name, topic name, selected columns (separated by semicolons), column mapping, sharding columns (separated by semicolons), and row filter conditions.
Download object settings
After you create a data synchronization task that has a non-IDB data source as the source, you can download the synchronization object settings.
Notice
You cannot download the object settings for a data synchronization task that has an IDB data source as the source.
Log in to the OMS console.
In the left-side navigation pane, click Data Synchronization.
On the Data Synchronization page, click the name of the task whose synchronization object settings you want to download.
On the details page of the task, click the More > Download Objects Settings icon in the upper-right corner.
Import object settings
OMS allows you to rename database tables, set row filter conditions, filter columns, and specify sharding columns by importing a CSV file. You can download the object settings or template of a task, modify the settings as needed, and then import the settings.
Notice
If you use an Excel file for editing, save it as a CSV file that is separated by commas (,), and then import the file.
Configure the data synchronization task to the Select Synchronization Objects step.
For more information, see the corresponding topic in Data Synchronization.
Select Specify Objects and click Target Object(s) > Import Objects in the upper-right corner of the list.
Notice
For data synchronization tasks with an IDB data source as the source, importing objects is not supported.
In the dialog box that appears, click OK.
Click Import CSV File in the lower part of the Import Synchronization Objects dialog box, and select a local CSV file to import it.
You can also click Download CSV Template File in the lower part of the dialog box to download the template. Then, configure the template as needed and click Import CSV File to import the synchronization objects.
The imported CSV file is displayed in the interface. You can edit the file as needed.
Note
You can edit the CSV file manually or by using an SQL script. You can also click Download Objects Settings on the details page of the task to generate the CSV file.
You can enter different database or table names to map the names.
Click Validate to check the source type and whether the row filter conditions are correct. If the verification succeeds, the number of verified tables and views is displayed.
Click OK to return to the Select Synchronization Objects step of the data synchronization task.
Complete subsequent task settings as prompted.