ApsaraDB for OceanBase:Create a PostgreSQL data source

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 a whitelist or security group based on business needs and security risks. Do not use the CIDR blocks in a whitelist 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 a whitelist or security group for the data transmission service, see Add a whitelist.

Prerequisites

You have created an ApsaraDB RDS for PostgreSQL instance. For more information, see Create an ApsaraDB RDS for PostgreSQL instance.

Procedure

1. Log on to the ApsaraDB for OceanBase console.

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

3. In the Data Sources section, click New Data Source in the upper-right corner.

4. In the New Data Source dialog box, set Data Source Type to PostgreSQL and set the parameters.

   

   Parameter	Description
   Instance Type	Currently, only RDS Instance is supported.
   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.
   RDS Instance ID	The ID of the target ApsaraDB RDS instance. Select the ID from the drop-down list.
   Username	The username used for migrating or synchronizing the data of the ApsaraDB RDS for PostgreSQL instance. We recommend that you create a dedicated privileged account for data migration or data synchronization. For more information, see PostgreSQL data source.
   Password	The password of the database user.
   Database Name	The name of the ApsaraDB RDS for PostgreSQL database. Note When the data source serves as the source of a data migration or synchronization task, you can select migration or synchronization objects only in the specified database.
   Remarks (Optional)	Additional information about the data source.

5. 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.

6. After the test is passed, click OK.