You can add an AnalyticDB for PostgreSQL data source to DataV over an internal network or the public network.
Prerequisites
An AnalyticDB for PostgreSQL data source has been prepared.
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 supported only in DataV Enterprise Edition or higher.
Add a data source over an internal network
Access the DataV console.
On the Workbench page, click in the navigation pane on the left. On the Data Source page, click New Data Source.
-
From the Type list, select AnalyticDB for PostgreSQL.
-
From the Network list, select Internal Network, and then select the region where the instance is located. The default region is China (Shanghai).
-
Enter the database information.
Parameter
Description
Name
A custom display name for the data source.
VPC ID
The ID of the VPC where your AnalyticDB for PostgreSQL instance is located. Obtain the ID from the AnalyticDB for PostgreSQL console.
VPC Instance ID
The ID of the database instance in the VPC. Obtain the ID from the AnalyticDB for PostgreSQL console.
NoteThe VPC-connected instance ID shown in the database console might not match the one required by DataV due to how VPC networks are implemented. If so, use the product's OpenAPI to get the correct VPC-connected instance ID. The required ID is typically the value of the VPCCloudInstanceId or VPCInstanceId parameter in the database instance details. To get the VPC-connected instance ID, call the DescribeDBInstanceNetInfo operation.
Domain Name
The endpoint for connecting to the database.
ImportantThis URL must be accessible to DataV servers over the public network or an internal network within supported Alibaba Cloud regions. Do not use a website URL or a raw IP address.
For example, for an AnalyticDB for PostgreSQL instance in a public network environment, the domain name is similar to `gp-bp1uxxxxxxxxxxxxxx0o.gpdb.rds.aliyuncs.com`. You can obtain the domain name from the Basic Information page in the AnalyticDB for PostgreSQL console.
Port
The port number of 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 database to connect to.
After you enter the database information, the system automatically tests the connection.
-
After the connection test succeeds, click OK to add the data source.
The data source is automatically added to the data source list.
Add a data source over the public network
Access the DataV console.
On the Workbench page, click in the navigation pane on the left. On the Data Source page, click New Data Source.
-
From the Type list, select AnalyticDB for PostgreSQL.
-
From the Network list, select Public Network.
-
Enter the database information.
Parameter
Description
Name
A custom display name for the data source.
Domain Name
The endpoint for connecting to the database.
ImportantThis URL must be accessible to DataV servers over the public network or an internal network within supported Alibaba Cloud regions. Do not use a website URL or a raw IP address.
For example, for an AnalyticDB for PostgreSQL instance in a public network environment, the domain name is similar to `gp-bp1uxxxxxxxxxxxxxx0o.gpdb.rds.aliyuncs.com`. You can obtain the domain name from the Basic Information page in the AnalyticDB for PostgreSQL console.
Port
The port number of 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 database to connect to.
After you enter the database information, the system automatically tests the connection.
-
After the connection test succeeds, click OK to add the data source.
The 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.