Tencent Cloud PostgreSQL data source

Limitations

This data source supports PostgreSQL 8.2 and later.

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 for the data source. The name must not contain special characters or leading or trailing spaces.
   Database address and Port	The public endpoint of your PostgreSQL database. To obtain the endpoint, log on to the Tencent Cloud PostgreSQL console, enable the public endpoint for the instance, and then view the endpoint in the Basic Information section of the instance details page. See Connect to a PostgreSQL instance.
   Database	The name of the target database.
   Schema	The name of the database schema.
   Username and Password	The credentials for accessing the PostgreSQL database.
   SSL	If your data source is SSL-enabled, select this option to encrypt the connection and protect data in transit.
   Initial SQL	When enabled, this option allows you to specify SQL statements that run each time a connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.
   Enable uploading files	Allows you to upload files.

4. Click Test connection to verify the connection.

   

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