This topic describes how to add an ApsaraDB RDS for PostgreSQL data source in DataV.

Add an ApsaraDB RDS for PostgreSQL data source over an internal network

  1. Log on to the DataV console.
  2. Click the Data Sources tab and then Add Source.
  3. Select RDS for PostgreSQL from the Type drop-down list.
  4. Select Intranet from the network type drop-down list, and select the region where the target ApsaraDB RDS for PostgreSQL instance resides from the region drop-down list.
  5. Specify a network type for the internal network of the database, such as VPC or classic network.
    • VPC
      1. Turn on VPC to enter the VPC mode.Add an ApsaraDB RDS for PostgreSQL data source over a VPC (internal network)
      2. Enter database information.
        Note If you need to create a database, see Create a database for an RDS MySQL instance.
        Parameter Description
        Name The name that you want to display for the data source.
        Domain Name The domain name or IP address that is used to connect to the database.
        Notice The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

        If you need to access an ApsaraDB RDS for PostgreSQL database over an internal network, an example of the domain name is pgm-bpxxxxxxxxxxxxxx15970.pg.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

        VPC ID The ID of the VPC to which your ApsaraDB RDS for PostgreSQL instance belongs. You can log on to the ApsaraDB for RDS console and navigate to Instances > Basic Information to view the VPC ID of the target ApsaraDB RDS for PostgreSQL instance in the Network Type column.Obtain VPC ID
        Instance ID The ID of the database instance in the VPC. You can log on to the ApsaraDB for RDS console and view the ID of the target database instance on the Instances page.
        Username The username that is used to connect to the database.
        Password The password that is used to connect to the database.
        Port The port that is used to connect to the database.
        Database The database that you want to use as the data source.
      3. After you enter the database information, DataV automatically tests whether the database can be connected.
    • Classic network
      1. Turn off VPC to enter the classic network mode.
      2. Enter database information.Add an ApsaraDB RDS for PostgreSQL data source over a classic network (internal network)
        Note If you need to create a database, see Create a database for an RDS MySQL instance.
        Parameter Description
        Name The name that you want to display for the data source.
        Domain Name The domain name or IP address that is used to connect to the database.
        Notice The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

        If you need to access an ApsaraDB RDS for PostgreSQL database over an internal network, an example of the domain name is pgm-bpxxxxxxxxxxxxxx15970.pg.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

        Username The username that is used to connect to the database.
        Password The password that is used to connect to the database.
        Port The port that is used to connect to the database.
        Database The database that you want to use as the data source.
      3. After you enter the database information, DataV automatically tests whether the database can be connected.
  6. After the connectivity test is complete, click OK.

    The added data source is displayed in the data source list.

Add an ApsaraDB RDS for PostgreSQL data source over the Internet

  1. Log on to the DataV console.
  2. Click the Data Sources tab and then Add Source.
  3. Select RDS for PostgreSQL from the Type drop-down list.
  4. Select Internet from the network type drop-down list.
  5. Enter database information.
    Add an ApsaraDB RDS for PostgreSQL data source (Internet)
    Parameter Description
    Name The name that you want to display for the data source.
    Domain Name The domain name or IP address that is used to connect to the database.
    Notice The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

    If you need to access an ApsaraDB RDS for PostgreSQL database over the Internet, an example of the domain name is pgm-bpxxxxxxxxxxxxxxqo.pg.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

    Username The username that is used to connect to the database.
    Password The password that is used to connect to the database.
    Port The port that is used to connect to the database.
    Database The database that you want to use as the data source.

    After you enter the database information, DataV automatically tests whether the database can be connected.

  6. After the database passes the connectivity test, click OK.

    The added data source is displayed in the data source list.