You must configure data sources before you create a data migration project. To migrate data from or to an IDB database, you must create the IDB database as the source or destination data source. This topic describes how to create an IDB database as a data source in OceanBase Migration Service (OMS).
Background information
OMS allows you to create an IDB data source and synchronize the data of the IDB data source to a MySQL tenant of OceanBase Database and DataHub. An IDB database manages the metadata of logical databases and tables. As OMS accesses a logical table by using its GUID, OMS can obtain the physical topology corresponding to the GUID from the IDB database. All physical tables corresponding to the logical table that is specified by the GUID can be obtained from the physical topology. Bagualu allows you to obtain the information of a physical OceanBase cluster. OMS pulls the cluster logs during the incremental synchronization stage by using the configurl parameter on ConfigServer. The value of the configurl parameter contains the URLs of all nodes in the cluster.
Procedure
Log on to the OMS console.
In the left-side navigation pane, click Data Source Management.
On the Data Sources page, click New Data Source in the upper-right corner.
In the New Data Source panel, select OceanBase for Data Source Type .
Select Logical Data Source , and select IDB from the drop-down list.
Specify the following parameters.
Parameter Description Data Source Identifier The name of the data source. The name must be 1 to 32 characters in length and can contain Chinese characters, digits, and case-sensitive English letters. Environment Valid values: PROD, DEV, and SIT. IDB URL The endpoint of the IDB data source. IDB Username The username used to access the IDB data source. IDB Password The password used to access the IDB data source. Bagualu URL The endpoint of Bagualu. Bagualu Username The username used to access Bagualu. Bagualu Password The password used to access Bagualu. obproxy Address Optional. The endpoint of obproxy that is used to access all physical tables corresponding to a logical table from the IDB data source. Full Synchronization User Optional. The username used to access the physical tenant in the logical table to be synchronized. This parameter is checked during the precheck of a full synchronization task, but not during the connection test. Full Synchronization Password Optional. The password used to access the physical tenant in the logical table to be synchronized. This parameter is checked during the precheck of a full synchronization task, but not during the connection test. Remarks Optional. Additional information about the data source. Click Test Connection to test the service status of the IDB data source, Bagualu, and obproxy. In addition, make sure that you have entered the correct usernames and passwords to ensure the normal execution of subsequent steps.
After the connection test succeeds, click OK.