Add a PolarDB for PostgreSQL data source over an internal or public network-DataV(DataV)-阿里云帮助中心

You can add a PolarDB for PostgreSQL data source to DataV over an internal or public network. PolarDB is a next-generation, cloud-native relational database developed by Alibaba Cloud that is fully compatible with PostgreSQL syntax.

Prerequisites

You have an available PolarDB for PostgreSQL data source.

Important

You must add the IP addresses for the corresponding region to the whitelist of your data source. This ensures that DataV can access your database. For more information, see Configure a database whitelist.

Limits

This feature is available only in DataV Enterprise Edition and later versions.

Add a data source over an internal network

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source in the navigation pane on the left. On the Data Source page, click New Data Source.
From the Type list, select PolarDB for PostgreSQL.
Set Network to Internal Network and select the region where the PolarDB instance is located.

Enter the database information.

Parameter	Description
Name	The display name of the data source. You can enter any name.
VPC ID	The ID of the VPC where your PolarDB for PostgreSQL instance resides. You can find this ID on the instance details page in the PolarDB console. Before you can view the VPC ID and VPC Instance ID, you must add the DataV VPC internal network IP address for the instance's region to the whitelist.
VPC Instance ID	The ID of the database instance within the VPC. You can find this ID on the instance details page in the PolarDB console.
Domain Name	The internal network address used to connect to the database. Important This is the domain name or IP address that the DataV server uses to access your database over the public network or an Alibaba Cloud internal network in certain regions. For example, the internal network address of an Alibaba Cloud PolarDB for PostgreSQL instance might look like `xxxxxxxx.pg.polardb.rds.aliyuncs.com`. You can obtain this address from the instance details page in the PolarDB console after you add the DataV VPC internal network IP address for the instance's region to the whitelist and the internal network address takes effect.
Port	The port number of the database.
Username	The username used to log in to the database.
Password	The password used to log in to the database.
Database	The name of the database.

After you enter the database information, the system automatically tests the connection to verify that the database is accessible.
After the connection test is successful, click OK to add the data source.

The new data source is automatically added to the data source list.

Add a data source over a public network

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source in the navigation pane on the left. On the Data Source page, click New Data Source.
From the Type list, select PolarDB for PostgreSQL.
Set Network to Public Network.

Enter the PolarDB for PostgreSQL data source information.

Parameter	Description
Name	The display name of the data source. You can enter any name.
Domain Name	The public network address used to connect to the database. Important This is the domain name or IP address that the DataV server uses to access your database over the public network or an Alibaba Cloud internal network in certain regions. For example, the public network address of an Alibaba Cloud PolarDB for PostgreSQL instance might look like `xxxxxxxx.pg.polardb.rds.aliyuncs.com`. In the PolarDB console, on the instance details page, you can request a public network address. After you add the DataV public network IP addresses to the whitelist and the public network address takes effect, you can use it.
Port	The port number of the database.
Username	The username used to log in to the database.
Password	The password used to log in to the database.
Database	The name of the database.

After you enter the information, click OK to add the data source.

The new data source is automatically added to the data source list.

What to do next

After you obtain the raw data, see Configure a widget data source to adapt the data for your widgets.

FAQ

For more information, see FAQ about data source configuration and usage.