Add AnalyticDB for PostgreSQL as a data source - DataV

This topic outlines how to add an AnalyticDB for PostgreSQL data source in DataV.

Prerequisites

Ensure the AnalyticDB for PostgreSQL data source is prepared.

Important

You must first add the whitelist IP address of the corresponding area to your data source whitelist to ensure that DataV-Board can access your database normally. For more information, see configure database whitelist.

Limits

All versions are supported.

Add a data source through the intranet

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
Select AnalyticDB for PostgreSQL from the Type dropdown menu.
Choose Intranet from the Network dropdown and select the instance's location, defaulting to China East 2.

Enter the database details.

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 VPC is where your AnalyticDB for PostgreSQL instance is located. You can obtain it from the AnalyticDB for PostgreSQL console.
Instance ID	The ID of the database instance under the VPC. You can obtain it from the AnalyticDB for PostgreSQL console. Note Usually, you can directly view the VPC-connected instance ID of the database instance in the console of the database product. However, due to the implementation mechanism of the VPC network, sometimes the instance ID displayed in the console is not the instance ID required by the DataV data source config VPC network. Therefore, you need to obtain the VPC-connected instance ID required by DataV through the OpenAPI of the database product, which is usually VPCCloudInstanceId or VPCInstanceId in the database instance details. For the specific interface to obtain the VPC-connected instance ID of the database product, please use the DescribeDBInstanceNetInfo interface to obtain the VPC-connected instance ID.
Domain Name	The URL address to connect to the database. Important This URL address is not the URL of the official website page, nor is it the native IP. It is the URL address that the DataV server needs to access your database through the public network or the intranet of some Alibaba Cloud regions. For example, when using Alibaba Cloud AnalyticDB for PostgreSQL in an external network environment, the domain name example is: gp-bp1uxxxxxxxxxxxxxx0o.gpdb.rds.aliyuncs.com. You can obtain it from the basic information page of the AnalyticDB for PostgreSQL console.
Port	The port set by the database.
Username	The username that is used to log on to the database.
Password	The password that is used to log on to the database.
Database	The name of the currently selected database.

Upon entering the database details, the system will automatically test the connection to ensure it is functioning correctly.

Once the connection test succeeds, click OK to finalize the data source addition.

The new data source will appear in the data source list automatically.

Add a data source through the internet

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
Select AnalyticDB for PostgreSQL from the Type dropdown menu.
Choose Internet from the Network dropdown.

Enter the database details.

Parameter	Description
Name	The display name of the data source. You can specify a custom name.
Domain Name	The URL address to connect to the database. Important This URL address is not the URL of the official website page, nor is it the native IP. It is the URL address that the DataV server needs to access your database through the public network or the intranet of some Alibaba Cloud regions. For example, when using Alibaba Cloud AnalyticDB for PostgreSQL in an external network environment, the domain name example is: gp-bp1uxxxxxxxxxxxxxx0o.gpdb.rds.aliyuncs.com. You can obtain it from the basic information page of the AnalyticDB for PostgreSQL console.
Port	The port set by the database.
Username	The username that is used to log on to the database.
Password	The password that is used to log on to the database.
Database	The name of the currently selected database.

Upon entering the database details, the system will automatically test the connection to ensure it is functioning correctly.

Once the connection test succeeds, click OK to finalize the data source addition.

The new data source will appear in the data source list automatically.

What to do next

Once you have the raw data, you can consult datasource config for widget data adaptation.

FAQ

For additional questions, consult the FAQ about datasource config.