DataV Connection

Background information

DataV is an Alibaba Cloud product that uses visual applications to analyze and display complex data. DataV provides a graphical interface to help users from various backgrounds create professional visual applications. These applications meet the display requirements for various business scenarios, such as conference exhibitions, business monitoring, risk warnings, and geographic information analysis. For more information, see What is DataV-Board.

Prerequisites

• The DataV service is activated. For more information, see Activate DataV.

• An AnalyticDB for PostgreSQL data source is available.

Procedure

1. Log on to the DataV console.

2. On the Workbench page, click Data Preparation > Data Sources. On the Data Sources page, click Add Data Source.

3. From the Type list, select AnalyticDB for PostgreSQL.

4. In the Network list, select the network type and the region where the instance is located.

   • Private Network: Connects using the private endpoint of the AnalyticDB for PostgreSQL instance.

   • Public Network: Connects using the public endpoint of the AnalyticDB for PostgreSQL instance.

5. Enter the database information.

   Parameter	Description
   Name	The display name of the data source. You can enter a custom name.
   VPC ID	The ID of the VPC where your AnalyticDB for PostgreSQL instance is located. This parameter is required for private network connections.
   VPC Instance ID	The ID of the database instance in the VPC. This parameter is required for private network connections. Note The VPC-connected instance ID can usually be found in the database product console. However, due to the VPC network implementation, the instance ID on the console may not be the ID that DataV requires. Call the DescribeDBInstanceNetInfo - View instance connection information operation to get the correct VPC-connected instance ID for the AnalyticDB for PostgreSQL instance.
   Domain Name	The endpoint of the AnalyticDB for PostgreSQL instance. Select the endpoint that corresponds to the network type. The endpoint is available on the Basic Information page in the Database Connection Information section.
   Port	The port that is set for the database.
   Username	The username used to log on to the database.
   Password	The password used to log on 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.

6. 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.