Quick BI:Add a RDS for PostgreSQL Data Source

Limits

Support is available for PostgreSQL version 8.2 and higher.

Procedure

1. Add Quick BI's IP address to the whitelist.

   Before connecting to Huawei Cloud PostgreSQL, add Quick BI's IP address to the PostgreSQL whitelist.

2. Verify the data source connection and create the data source.

   1. Log on to the Quick BI console.

   2. Follow the instructions in the figure below to add the data source:

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

      2. On the HUAWEI CLOUD Database tab, select PostgreSQL data source.

1. In the Configure Connection dialog box, configure the connection settings as needed for your scenario.

   Name	Description
   Display Name	The display name in the datasource config list. Please enter a standard name. Do not use special characters or include spaces at the beginning or end.
   Database Address and Port	The external network address where the PostgreSQL database is deployed. Log on to the Huawei Cloud management console, bind the Elastic IP Address (EIP) on the instance basic information page, and view it on the EIP page.
   Database	The name of the database to be connected.
   Schema	The schema name of the PostgreSQL database.
   Username and Password	The username and password for logging on to the PostgreSQL database.
   SSL	If the target data source is configured with SSL, you can select the security protocol SSL to protect data security.
   Initialize SQL	After enabling, you can configure the SQL statement that is executed to initialize after the data source connection. Only SET statements are allowed for the SQL statement executed to initialize after each data source connection. Separate statements with periods.
   Enable upload file entry	After enabling, uploading files is supported.

2. Click Connection Test to verify the data source connectivity.

   

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