Create a data source

Limits

Only users with the AliyunOceanBaseFullAccess permission can create data sources. For more information about the access policy, see AliyunOceanBaseFullAccess.

Procedure

1. Log on to the OceanBase Management Console .

2. On the Migration Evaluation > Compatibility Assessment page, create an online evaluation task.

   For more information, see Execute an online evaluation.

3. On the Select Source Database Type page, click Create Data Source to the right of the Source Data Source drop-down list.

   

4. (Optional) If this is the first time you create a compatibility assessment task, or if the service-linked role (AliyunServiceRoleForOceanbaseMigrationAssessment) has been deleted, click OK in the Create Service-linked Role for Migration Evaluation dialog box.

   When you click OK, a service-linked role is automatically created for the OceanBase Migration Evaluation service. For more information about the access policy of this role, see Service-linked role for Migration Evaluation.

   

5. In the Create Data Source dialog box, enter a Data Source Name and select a Database Type.

6. Configure the parameters based on the selected database type.

   The supported database types are Oracle and MySQL. The required parameters vary depending on the selected database type.

   • If you set Database Type to Oracle, configure the following parameters.

     

     Parameter	Description
     Instance Type	Includes Self-managed database in VPC and Self-managed database with public IP.
     VPC	From the VPC drop-down list, select the VPC where your source database is located. Note This parameter is displayed only when you set Instance Type to Self-managed database in VPC.
     vSwitch	From the vSwitch drop-down list, select the ID of the virtual switch in a supported zone. You can move the mouse pointer over the tip icon to the right of vSwitch to view the zone restrictions. Note This parameter is displayed only when you set Instance Type to Self-managed database in VPC.
     Host IP	The IP address of the database host.
     Port	The port number of the database host.
     Username	The name of the database user.
     Password	The password for the database user.
     Connection Type	Includes SERVICE_NAME and SID. Select a type as needed.
     Connection Name	After you select a connection type, query the corresponding connection name in the source database and enter it here.

   • If you set Database Type to MySQL, configure the following parameters.

     After you select an Instance Type from the Instance Type drop-down list, the corresponding form is automatically displayed.

     

     Parameter	Description
     Instance ID	From the Instance ID list, select the destination instance. Note This parameter is not displayed when you set Instance Type to Self-managed database in VPC or Self-managed database with public IP.
     VPC	From the VPC drop-down list, select the VPC where your source database is located. Note This parameter is not displayed when you set Instance Type to Self-managed database with public IP.
     vSwitch	From the vSwitch drop-down list, select the ID of the virtual switch in a supported zone. You can move the mouse pointer over the tip icon to the right of vSwitch to view the zone restrictions. Note This parameter is not displayed when you set Instance Type to Self-managed database with public IP.
     Host IP	The IP address of the database host.
     Port	The port number of the database host.
     Username	The name of the database user.
     Password	The password for the database user.

7. Click Test Connection to verify the network connectivity between the migration evaluation server and the database, and validate the username and password.

8. After the connection test is successful, click OK.