Alibaba Cloud data source: PolarDB for PostgreSQL (Oracle-compatible)

Procedure

1. Add IP addresses to the whitelist.

   Before you connect to a PolarDB for PostgreSQL (Oracle-compatible) database, you must add the IP addresses of Quick BI to the database whitelist. For more information, see Set Cluster Whitelist.

2. Test the connection and create the data source.

   1. Log on to the Quick BI console.

   2. To add the data source:

      1. Navigate to the data source creation page. For details, see Create a data source.

      2. On the Alibaba Cloud Databases tab, select PolarDB for PostgreSQL (Oracle-compatible).

   3. In the Configure Connection dialog box, configure the following parameters.

      Parameter	Description
      connection method	When you select automatic connection, the system populates the database configuration after you select a database from your account.
      display name	The display name of the data source in the list. The name must not contain special characters or leading or trailing spaces.
      database address	The public endpoint of your PolarDB for PostgreSQL (Oracle-compatible) database. For a VPC data source, enter the internal address and port instead. Log on to the PolarDB console and find the address under network information. Example: xxxxxxxxxxxxxxxxxxxxxx.ppas.rds.aliyuncs.com. For more information, see View or apply for a connection string.
      port	The port number of the database service.
      database	The name of the database you want to connect to.
      schema	The name of the schema you want to connect to.
      username and password	The username and password for the database. The user must have CREATE, INSERT, UPDATE, and DELETE permissions on the tables.
      VPC data source	If your database is in a Virtual Private Cloud (VPC), select VPC Data Source and configure the following parameters. AccessKey ID and AccessKey Secret: The AccessKey pair of an account that can access the target database. The account must have read permissions on the instance. If the account also has write permissions, the system automatically adds the required IP addresses to the whitelist. Otherwise, add them manually. For more information, see Create a custom policy. To obtain the AccessKey ID and AccessKey Secret, log on to the RAM console. instance ID and region: The ID and region of the database instance. To obtain this information, log on to the PolarDB console. instance version: Select the version of your instance. Supported versions are 1.0 and 2.0. Note If you select VPC Data Source, enter the database's internal address and port in the Database Address and Port fields.
      initial SQL	SQL statements that run immediately after a connection is established. Only SET statements are allowed. Separate multiple statements with semicolons (;).
      Enable file upload entry	Enables file uploads for this data source.

   4. Click Test Connection to test the connection.

      

   5. If the connection test is successful, click OK to add the data source.