All Products
Search
Document Center

ApsaraDB for OceanBase:Create a PolarDB-O data source

Last Updated:Dec 12, 2024

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 risks

You can choose to automatically or manually add public CIDR blocks for the data transmission service, but security risks exist. Your use of the data transmission service indicates that you have understood and acknowledged the possible security risks. You must take basic security protection measures, such as setting a complex password for your account, limiting the open port numbers of CIDR blocks, enabling authentication for communication among internal APIs, and regularly check for and limit CIDR blocks that are not required.

The data transmission service will add or delete the CIDR blocks automatically added to an allowlist or security group based on business needs and security risks. Do not use the CIDR blocks in an allowlist or security group for business needs other than the data transmission service. If you use such CIDR blocks for other business needs, the issues thus incurred are beyond the guarantee scope of the SLA of the data transmission service. For more information about how to add an IP address to an allowlist or security group for the data transmission service, see Add an allowlist.

Procedure

  1. Log on to the ApsaraDB for OceanBase console.

  2. In the left-side navigation pane, choose Data Transmission > Data Source Management.

  3. On the Data Sources page, click New 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. Select an instance type from the Instance Type drop-down list. The corresponding configuration section automatically appears.

    image

    Instance type

    Parameter

    Description

    Alibaba Cloud PolarDB-O instance

    Instance ID/Name

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

    Self-managed database in a virtual private cloud (VPC)

    VPC

    The target VPC. Select it from the drop-down list.

    Host IP Address

    The IP address of the host where the database is located.

    Port

    The port number of the host where the database is located.

    Self-managed database with a public IP address

    Host IP Address

    The IP address of the host where the database is located.

    Port

    The port number of the host where the database is located.

    Common parameters

    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 Apply for cross-account authorization.

    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)

    Additional information about the data source.

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

  7. After the test is passed, click OK.