Quick BI:Add a PolarDB for PostgreSQL (Compatible with Oracle) Data Source

Procedure

1. Add a whitelist.

   Before connecting to Alibaba PolarDB for Oracle, add the IP address of Quick BI to the whitelist of Alibaba PolarDB for Oracle. For more information on whitelist configuration, see setting a cluster whitelist.

2. Add a data source and verify the connection.

   1. Log on to the or the international Quick BI console.

   2. To add a data source, follow these steps:

      1. Navigate to the data source creation interface through the data source creation entry.

      2. On the Alibaba Cloud Database tab, select PolarDB for PostgreSQL (Compatible with Oracle) data source.

   3. In the Configure connection dialog box, configure the connection based on your business needs.

      Name	Description
      Display name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
      Database address	The public address where the PolarDB for Oracle database is deployed (if using a VPC data source, you need to fill in the internal address and internal port where the database is deployed). Log on to the PolarDB console to obtain the database address in the network information section. Example: xxxxxxxxxxxxxxxxxxxxxx.ppas.rds.aliyuncs.com. For more information, see view or request a connection address.
      Port	The corresponding port number of the database.
      Database	The name of the database to be connected.
      Schema	The schema of the database that you want to access.
      Username and password	The username and password that are used to access the database. Ensure that the username has create, insert, update, and delete permissions on tables in the database.
      VPC data source	If the database uses the Alibaba Cloud VPC network, select the VPC data source and configure the following parameters. Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret that have access privileges to the destination database. Ensure that the account has Reads permission on the destination instance. Additionally, if it has Write permission, the system will automatically add a whitelist. Otherwise, you need to add it manually. For more information, see create a custom policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. Instance ID and Area: The instance ID and area where the database is located. Log on to the PolarDB console to obtain the instance ID and area. Instance version: Select the version corresponding to the current instance. Versions 1.0 and 2.0 are supported. Note If you select the VPC data source, the database address and port need to be filled with the internal address and internal port.
      Init SQL	After enabling, you can configure the SQL statement to be executed after the data source connection is initialized. Only SET statements are allowed for the SQL statement executed after each data source connection is initialized. Statements are separated by periods.
      Enable upload file entry	After enabling, uploading files is supported.

   4. Click Connection test to verify the data source connectivity.

      

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