You must create a data source before you can create a data migration or data synchronization task. This topic describes how to create an OceanBase data source in Data Transmission Service.
Security risk notice
When you use OceanBase Data Transmission Service, you can add its public IP address CIDR blocks to a whitelist automatically or manually. This action may pose security risks. Using this product, you acknowledge and accept these potential risks. You must implement basic security protection measures. These measures include, but are not limited to, using complex account passwords, restricting open ports for each CIDR block, using authentication for internal API communication, and periodically reviewing and restricting IP address CIDR blocks that do not require access.
OceanBase Data Transmission Service automatically adjusts whitelists or security groups by adding or deleting entries based on factors such as business needs and security risks. Do not use the IP address segments in these whitelists or security groups for business purposes unrelated to OceanBase Data Transmission Service. Any issues that arise from using these IP address segments for other business purposes are not covered by the OceanBase Data Transmission Service SLA. For more information about the whitelists or security groups that Data Transmission Service automatically or manually adds, see the Add Whitelist module documentation.
Procedure
Log on to the OceanBase Management Console .
In the navigation pane on the left, click Data Transmission > Data Source Management.
On the Data Source List page, click Create Data Source in the upper-right corner.
In the Create Data Source dialog box, Data Source Type is set to OceanBase by default. Select an Instance Type and configure the parameters.
If you set Instance Type to OceanBase Cluster Instance, configure the following parameters.
Parameter
Description
Data Source Name
The name of the data source. The name can contain Chinese characters, digits, and letters. It cannot contain spaces and must be no more than 32 characters long.
Cross-Alibaba Cloud Account
Data Transmission Service supports configuring data migration or data synchronization tasks for instances under different Alibaba Cloud accounts. This enables cross-account data migration or synchronization.
Select this option as needed. If you select this option, enter the other Alibaba Cloud account. If you do not have the required permissions for that account, request authorization first. For more information, see Request cross-account authorization.
Cluster ID/Name
The ID or name of the cluster where the OceanBase database tenant resides.
Tenant Name
The name of the OceanBase database tenant.
Tenant Mode
The mode of the OceanBase database tenant. This parameter is automatically filled in and cannot be modified.
Username
The username for the OceanBase database.
Create a dedicated database user for the data migration or sync task. For more information, see Create a user and grant permissions for an OceanBase cluster instance in MySQL mode or Create a user and grant permissions for an OceanBase cluster instance in Oracle mode.
Password
The password for the OceanBase database user.
Remarks (Optional)
Remarks about the data source.
__oceanbase_inner_drc_user Password (Optional)
This user is mainly used for migrating data from tables without a unique key in the OceanBase database. Note: You must create this user under the tenant where the current data source is located.
In the Create Data Source dialog box, click Expand next to Advanced Options and configure this parameter as needed.
If you set Instance Type to OceanBase Tenant Instance, configure the following parameters.
Parameter
Description
Data Source Name
The name of the data source. The name can contain Chinese characters, digits, and letters. It cannot contain spaces and must be no more than 32 characters long.
Cross-Alibaba Cloud Account
Data Transmission Service supports configuring data migration or data synchronization tasks for instances under different Alibaba Cloud accounts. This enables cross-account data migration or synchronization.
Select this option as needed. If you select this option, enter the authorized Alibaba Cloud account of the other party. For more information, see Request cross-account authorization.
Tenant Name
The name of the OceanBase database tenant.
Tenant Mode
The mode of the OceanBase database tenant. This parameter is automatically filled in and cannot be modified.
Username
The username for the OceanBase database. Create a dedicated database user for the data migration or sync task. For more information, see Create a database user.
Password
The password for the database user.
Remarks (Optional)
Remarks about the data source.
__oceanbase_inner_drc_user Password (Optional)
This user is mainly used for migrating data from tables without a unique key in the OceanBase database. Note: You must create this user under the tenant where the current data source is located.
In the Create Data Source dialog box, click Expand next to Advanced Options and configure this parameter as needed.
If you set Instance Type to Self-managed Database in VPC, configure the following parameters.
Parameter
Description
Data Source Name
The name of the data source. The name can contain Chinese characters, digits, and letters. It cannot contain spaces and must be no more than 32 characters long.
Cross-Alibaba Cloud Account
Data Transmission Service supports configuring data migration or data synchronization tasks for instances under different Alibaba Cloud accounts. This enables cross-account data migration or synchronization.
Select this option as needed. If you select this option, enter the authorized Alibaba Cloud account of the other party. For more information, see Request cross-account authorization.
VPC
The unique ID of the VPC that you requested on the public cloud.
Tenant Type
The type of the OceanBase database tenant. Valid values are MySQL and Oracle.
Host IP
The IP address of the database host.
Port
The port number of the database host.
Tenant Name
The name of the OceanBase database tenant.
Cluster Name
The name of the cluster where the OceanBase database tenant resides.
Username
The username for the OceanBase database.
Create a dedicated database user for the data migration or sync task. For more information, see Create a database user.
Password
The password for the OceanBase database user.
Remarks (Optional)
Remarks about the data source.
(Optional) In the New Data Source dialog box, you can click Expand next to Advanced Options and configure the parameters based on your business needs.
Parameter
Description
DRC Username
The name of the DRC user. This user is mainly used to read incremental logs and database object structure information from the OceanBase database. Create this user under the sys tenant of the business cluster.
Password
The password for the DRC user.
oblogproxy IP (Optional)
The incremental log proxy service for OceanBase databases. This service lets applications access incremental logs and manage real-time incremental tasks. It also lets you subscribe to incremental logs in a network-isolated environment.
oblogproxy Port (Optional)
__oceanbase_inner_drc_user Password (Optional)
This user is mainly used for migrating data from tables without a unique key in the OceanBase database. Note: You must create this user under the tenant where the current data source is located.
If you set Instance Type to OceanBase Serverless Instance, configure the following parameters.
Parameter
Description
Data Source Name
The name of the data source. The name can contain Chinese characters, digits, and letters. It cannot contain spaces and must be no more than 32 characters long.
Cross-Alibaba Cloud Account
Data Transmission Service supports configuring data migration or data synchronization tasks for instances under different Alibaba Cloud accounts. This enables cross-account data migration or synchronization.
Select this option as needed. If you select this option, enter the authorized Alibaba Cloud account of the other party. For more information, see Request cross-account authorization.
Instance Name
Select a created Serverless instance from the drop-down list. For more information, see Create a Serverless instance.
Tenant Mode
The mode of the OceanBase database tenant. This parameter is automatically filled in and cannot be modified.
Username
The username for the OceanBase database. Create a dedicated database user for the data migration or sync task. For more information, see Create a user and grant permissions for an OceanBase Serverless instance.
Password
The password for the database user.
Remarks (Optional)
Remarks about the data source.
__oceanbase_inner_drc_user Password (Optional)
This user is mainly used for migrating data from tables without a unique key in the OceanBase database. Note: You must create this user under the tenant where the current data source is located.
In the Create Data Source dialog box, click Expand next to Advanced Options and configure this parameter as needed.
If you set Instance Type to OBKV Instance, configure the following parameters.
Parameter
Description
Data Source Name
The name of the data source. The name can contain Chinese characters, digits, and letters. It cannot contain spaces and must be no more than 32 characters long.
Cross-Alibaba Cloud Account
Data Transmission Service supports configuring data migration or data synchronization tasks for instances under different Alibaba Cloud accounts. This enables cross-account data migration or synchronization.
Select this option as needed. If you select this option, enter the authorized Alibaba Cloud account of the other party. For more information, see Request cross-account authorization.
Cluster ID/Name
Select a created OBKV instance from the drop-down list. For more information, see Purchase an instance. Set Series to Standard Edition (Key-Value).
Tenant Name
Select the tenant ID/name that corresponds to the cluster ID/name from the drop-down list.
Username
The username for the OceanBase database. Create a dedicated database user for the data migration or sync task. For more information, see Create a user and grant permissions for an OBKV instance.
Password
The password for the database user.
Remarks (Optional)
Remarks about the data source.
Click Test Connection to verify the network connectivity to the data source and validate the username and password.
After the test is successful, click OK.
