This topic describes how to add an AnalyticDB for PostgreSQL data source in DataV.
Prerequisites
An AnalyticDB for PostgreSQL data source is available.Add a data source over a private network
Log on to the DataV console.
On the My Data tab, select Data Source Management and click Add Data.
- From the Type list, select AnalyticDB for PostgreSQL.
- From the Network list, select Private Network and the region where the instance is located. The default region is China (Shanghai).
- Enter the database information.
Parameter Description Name The display name of the data source. You can specify a custom name. VPC ID The ID of the VPC-connected instance. This is the VPC where your AnalyticDB for PostgreSQL instance resides. Obtain the ID from the AnalyticDB for PostgreSQL console. Instance ID The ID of the database instance in the VPC. Obtain the ID from the AnalyticDB for PostgreSQL console. Note Typically, the VPC-connected instance ID of a database instance is available in the product console. However, due to how VPC networks are implemented, the instance ID shown in the console is sometimes not the correct ID for configuring a VPC-based data source in DataV. Therefore, use the product's OpenAPI to obtain the required VPC-connected instance ID. This is usually the VPCCloudInstanceId or VPCInstanceId in the instance details. Use the DescribeDBInstanceNetInfo operation to obtain the VPC-connected instance ID.Domain Name The URL used to connect to the database. Important This URL is not a website URL or a native IP address. It is the URL that the DataV server uses to access your database over the public network or the private network of some Alibaba Cloud regions.For example, for an Alibaba Cloud AnalyticDB for PostgreSQL instance accessed over the public network, the domain name is similar to `gp-bp1uxxxxxxxxxxxxxx0o.gpdb.rds.aliyuncs.com`. Obtain the domain name from the basic information page in the AnalyticDB for PostgreSQL console.
Port The port number set for the database. Username The username for logging on to the database. Password The password for logging on to the database. Database The name of the currently selected database. After you enter the database information, the system automatically tests the connection.
- After a successful connection test, click OK to add the data source.
The new data source automatically appears in the data source list.
Add a data source over the public network
Log on to the DataV console.
On the My Data tab, select Data Source Management and click Add Data.
- From the Type list, select AnalyticDB for PostgreSQL.
- From the Network list, select Public Network.
- Enter the database information.
Parameter Description Name The display name of the data source. You can specify a custom name. Domain Name The URL used to connect to the database. Important This URL is not a website URL or a native IP address. It is the URL that the DataV server uses to access your database over the public network or the private network of some Alibaba Cloud regions.For example, for an Alibaba Cloud AnalyticDB for PostgreSQL instance accessed over the public network, the domain name is similar to `gp-bp1uxxxxxxxxxxxxxx0o.gpdb.rds.aliyuncs.com`. Obtain the domain name from the basic information page in the AnalyticDB for PostgreSQL console.
Port The port number set for the database. Username The username for logging on to the database. Password The password for logging on to the database. Database The name of the currently selected database. After you enter the database information, the system automatically tests the connection.
- After a successful connection test, click OK to add the data source.
The new data source automatically appears in the data source list.