Create a PolarDB-O data source

更新时间:
复制 MD 格式

Before you create a data migration or synchronization task, you must create a data source. This topic describes how to create a PolarDB-O data source by using the 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

  1. Log on to the OceanBase Management Console .

  2. In the navigation pane on the left, click Data Transmission > Data Source Management.

  3. On the Data Source List page, click Create Data Source in the upper-right corner.

    image.png

  4. In the New Data Source dialog box, select PolarDB-O for Data Source Type.

  5. Configure the parameters.

    image

    Parameter

    Description

    Data Source Identifier

    We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 32 characters in length.

    Cross Alibaba Cloud Account

    The data transmission service allows you to configure a task to migrate or synchronize data between instances under different Alibaba Cloud accounts.

    You can choose whether to select this option based on business needs. If you select this option, enter the Alibaba Cloud account of the target instance. If you do not have permissions on this Alibaba Cloud account, request for authorization first. For more information, see Request cross-account authorization.

    Instance ID/Name

    The ID of the target PolarDB-O instance. Select the ID from the drop-down list.

    Username

    The username of the PolarDB-O database user for data migration or synchronization. We recommend that you create a dedicated database user for the migration or synchronization task. For more information, see PolarDB-O data source.

    Password

    The password of the database user.

    Database Name

    The name of the PolarDB-O database.

    Note

    When you migrate data from the data source, you can select only the migration objects in the specified database for the data migration task.

    Remarks (Optional)

    The additional information about the data source.

  6. Click Test Connection to verify the network connection between the data transmission service and the data source, as well as the validity of the username and password.

  7. After the test is passed, click OK.