Quick BI:Tencent Cloud PostgreSQL data source

Limitations

Only PostgreSQL 8.2 and later are supported.

Procedure

1. Add IP addresses to the allowlist.

   To connect to Tencent Cloud PostgreSQL, add the IP addresses of Quick BI to the allowlist of your Tencent Cloud PostgreSQL instance. For more information, see Manage security groups.

2. Verify the connection and create the data source.

   1. Log on to the Quick BI console.

   2. To add the data source:

      1. Go to the Create Data Source page.

      2. On the Tencent Cloud databases tab, select TencentDB for PostgreSQL.

3. In the Configure connection dialog box, set the following parameters.

   Parameter	Description
   Display name	The display name of the data source. The name cannot contain special characters or leading or trailing spaces.
   Database address and Port	The public endpoint of your PostgreSQL database. To obtain it, log on to the Tencent Cloud PostgreSQL console, enable the public endpoint, and view it in the Basic Information section of the instance details page. See Connect to a PostgreSQL instance.
   Database	The name of the database to connect to.
   Schema	The database schema to use.
   Username and Password	The credentials used to access the PostgreSQL database.
   SSL	Select this option to encrypt the connection and protect data in transit if your data source supports SSL.
   Initial SQL	Specifies SQL statements to run each time a connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.
   Enable uploading files	Enables file uploads to the data source.

4. Click Test connection to verify the connection.

   

5. After a successful connection test, click OK to create the data source.