DataV:Add RDS for PostgreSQL data source

Add data source through intranet

1. Access the DataV console.

2. On the Workbench page, click Data Preparation > Data Source in the left-side navigation pane to access the Data Source page, and then click Create Data Source.

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

4. Select Intranet and choose the region where the RDS instance is located.

5. Select the network type for the intranet database, which includes Virtual Private Cloud (VPC) and Classic Network.

   • Virtual Private Cloud (VPC)

     1. Activate the VPC switch to enter VPC mode.

     2. Enter the database information.

        Note

        To create a new database, see Create a Database.

        Parameter	Description
        Name	The name of the data source. You can specify a custom name.
        VPC ID	The ID of the VPC-connected instance, which is the VPC where your RDS for PostgreSQL instance is located. You can obtain it from the RDS Management Console under Instance List Basic Information Network Type.
        Instance ID	The ID of the database instance under the VPC. You can obtain it from the RDS Management Console on the instance basic information page. 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 OPEN API of the database product, which is usually the VpcCloudInstanceId or VpcInstanceId in the database instance details. For the specific database product interface to obtain the VPC-connected instance ID, see Query Instance Details.
        Domain Name	The connection address of 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 intranet of some Alibaba Cloud regions. For example, when using Alibaba Cloud RDS for PostgreSQL in an intranet environment, the domain name example is: pgm-bpxxxxxxxxxxxxxx15970.pg.rds.aliyuncs.com, which can be obtained from the RDS Management Console on the instance basic information page.
        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.

     3. After entering the database information, the system will automatically test the connection to ensure it is functioning correctly.

   • Classic Network

     1. Deactivate the VPC switch to enter Classic Network mode.

     2. Enter the database information.

        Note

        To create a new database, see Create a Database.

        Parameter	Description
        Name	The name of the data source. You can specify a custom name.
        Domain Name	The connection address of 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 intranet of some Alibaba Cloud regions. For example, when using Alibaba Cloud RDS for PostgreSQL in an intranet environment, the domain name example is: pgm-bpxxxxxxxxxxxxxx15970.pg.rds.aliyuncs.com, which can be obtained from the RDS Management Console on the instance basic information page.
        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.

     3. After entering the database information, the system will automatically test the connection to ensure it is functioning correctly.

6. Once the connection test is successful, click OK to finalize the data source addition.

   Upon completion, the data source will appear in the data source list automatically.

Add data source through the internet

1. Access the DataV console.

2. On the Workbench page, click Data Preparation > Data Source in the left-side navigation pane to access the Data Source page, and then click Create Data Source.

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

4. Select Internet from the list.

   For internet address settings, see Set Connection Address.

5. Enter the database information.

   

   Parameter	Description
   Name	The name of the data source. You can specify a custom name.
   Domain Name	The connection address of 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 intranet of some Alibaba Cloud regions. For example, when using Alibaba Cloud RDS for PostgreSQL in an internet environment, the domain name example is: pgm-bpxxxxxxxxxxxxxxqo.pg.rds.aliyuncs.com, which can be obtained from the RDS Management Console on the instance basic information page.
   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 database information, the system will automatically test the connection to ensure it is functioning correctly.

6. Once the connection test is successful, click OK to finalize the data source addition.

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

What to do next

Once you have the raw data, you can refer to widget data source configuration for widget data adaptation.

FAQ

For more information, see Data Source FAQ.