Quick BI:AWS Data Source PostgreSQL

Limits

Support is provided for PostgreSQL version 8.2 and above.

Procedure

1. Add Quick BI to the whitelist.

   Before connecting to AWS PostgreSQL, add the IP address of Quick BI to the AWS PostgreSQL whitelist.

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

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

   2. You can add a data source by following the instructions in the figure below.

      1. Access the data source creation interface via the data source creation entry.

      2. Choose the PostgreSQL data source.

         

      3. Select AWS as the data source type.

         

3. In the configure connection dialog box, complete the necessary configurations based on your business scenario.

   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 and port	The public address where the PostgreSQL database is deployed. Log on to the Amazon RDS console and obtain the public address in the instance details. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com.
   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 to be executed for initialization after the data source connection. Only SET statements are allowed for the SQL statement executed after each data source connection initialization, and statements are separated by semicolons.
   Enable upload file entry	After enabling, file upload is supported.

4. Click connection test to verify the data source's connectivity.

   

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