Quick BI:Tencent Cloud Data Source PostgreSQL

Limits

Supports PostgreSQL version 8.2 and above.

Procedure

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

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

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

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

   2. Navigate to the data source creation interface as shown below.

      1. Access the data source creation entry.

      2. Select PostgreSQL as the data source type.

         

      3. Choose Tencent Cloud as the data source type.

         

3. In the Configure Connection dialog box, configure the connection according to 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 external network address where the PostgreSQL database is deployed. Log on to the Tencent Cloud PostgreSQL console, enable the external network address on the instance product page, and view it in the basic information.
   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 initialized and executed after the data source connection. Only SET statements are allowed for the SQL statement initialized and executed after each data source connection, and statements are separated by periods.
   Enable file upload entry	After enabling, file upload 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.