Add PolarDB for PostgreSQL data source through internal/external network - DataV

This topic outlines how to add a PolarDB for PostgreSQL data source in DataV, along with instructions for configuring the necessary parameters. PolarDB is a next-generation, cloud-native relational database developed by Alibaba that is fully compatible with PostgreSQL syntax.

Prerequisites

Ensure that the PolarDB for PostgreSQL data source is ready to be added.

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

Supports only Enterprise Edition or higher.

Add data source through internal network

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.
From the Type list, select PolarDB for PostgreSQL.
Choose Internal Network and select the region where your PolarDB instance is located.

Enter the database information.

Parameter	Description
Name	The 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 PolarDB for PostgreSQL instance is located. You can obtain it on the PolarDB console on the basic information page of the instance. You can configure and add the whitelist of the DataV VPC internal network address in the region where the instance is located to view the VPC ID and VPC Instance ID of the instance.
Instance ID	The ID of the database instance under the VPC. You can obtain it on the basic information page of the instance in the PolarDB console.
Domain Name	The internal network address for connecting to the database. Important This address is the domain name or IP address that the DataV server can access your database through the public network or the internal network of some Alibaba Cloud regions. For example, when using Alibaba Cloud PolarDB for PostgreSQL in an internal network environment, the domain name example is: xxxxxxxx.pg.polardb.rds.aliyuncs.com. You can configure and add the whitelist of the DataV VPC internal network address in the region where the instance is located on the PolarDB console on the basic information page of the instance. After the internal network address takes effect, it can be used.
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.

The system will automatically test the connection to confirm normal database connectivity after you input the database details.
Once the connection test is successful, click OK to finalize the data source addition.

The new data source will be listed automatically in the data source list.

Add data source through external network

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.
From the Type list, select PolarDB for PostgreSQL.
Choose External Network from the list.

Provide the required PolarDB for PostgreSQL data source details.

Parameter	Description
Name	The name of the data source. You can specify a custom name.
Domain Name	The external network address for connecting to the database. Important This address is the domain name or IP address that the DataV server can access your database through the public network or the internal network of some Alibaba Cloud regions. For example, when using Alibaba Cloud PolarDB for PostgreSQL in an external network environment, the domain name example is: xxxxxxxx.pg.polardb.rds.aliyuncs.com. You can apply for an external network address and configure and add the whitelist of the DataV external network on the PolarDB console on the basic information page of the instance. After the external network address takes effect, it can be used.
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.

After entering the details, click OK to add the data source successfully.

The newly added 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.