Create an OBSharding data source

Creating a data migration or synchronization task requires that you have created a data source. This topic describes how to create an OBSharding data source in OceanBase Migration Service (OMS).

Prerequisites

• You have obtained the OBSharding console address, Access Key, and Security Key.

• The OBSharding console and OMS console are connected to each other.

• The OBSharding physical instance nodes are connected to OMS.

• The OceanBase Database user has been created on each physical node and has the same user privileges.

Procedure

1. Log in to the OMS console.

2. In the left-side navigation pane, click Data Source Management.

3. On the Data Source Management page, click New Data Source in the upper-right corner.

   

4. In the New Data Source dialog box, set Data Source Type to OBSharding.

5. Configure the following parameters.

   Parameter	Description
   Data Source Identifier	We recommend that you use a combination of Chinese characters, digits, and letters. The name cannot contain spaces and must be no longer than 32 characters. Notice The data source ID must be globally unique in OMS.
   Region	Select the region from the drop-down list. This parameter specifies the cm_region parameter configured when OMS was deployed. This parameter is displayed only in a multi-region scenario. Make sure that the mapping between the data source and the region is consistent. Otherwise, the migration and synchronization performance may be poor.
   OBSharding Console	Enter the OBSharding console address. OMS uses this address to call the OBSharding OpenAPI.
   Access Key/Security Key	Enter the Access Key and Security Key of the OBSharding user. To obtain the Access Key and Security Key, log in to the OBSharding console, select System Management > User Management, click the name of the user, and view the Access Key information. Notice Before you proceed, click Test Connection to test the connectivity with OBSharding.
   Instance ID	Select the instance ID from the drop-down list. To obtain the instance ID, log in to the OBSharding console, select Instances, and view the instance list.
   Database Name	Select the name of the logical database in the target instance from the drop-down list.
   Database Username/Password	Enter the username and password of the database user. Make sure that the database user has been created on all physical data nodes associated with the logical database and has the same username and password.
   Remarks (Optional)	Remarks about the data source.

   If you use an OBSharding data source and select Incremental Synchronization when you create a data migration task, you must also specify the following parameters.

   Parameter	Description
   DRC User Name (Optional)	The username of the DRC user. This user is used to read the incremental logs and database schema information of OceanBase Database. Create this user in the sys tenant of all OceanBase physical data source nodes.
   Password (Optional)	The password of the DRC user.

6. In the New Data Source dialog box, click Create.