Quick BI:Tencent Cloud Data Source TDSQL-H LibraDB

Prerequisites

You have created a Tencent TDSQL-H LibraDB database instance.

Limitations

Only tables that use the MergeTree family of table engines are supported.

Procedure

1. Add IP addresses to the allowlist.

   Add the IP addresses of Quick BI to the allowlist of your Tencent TDSQL-H LibraDB instance.

2. Create the data source.

   1. Log on to the Quick BI console.

   2. Add the data source.

      1. Go to the page to create a data source.

      2. On the Tencent Cloud Databases tab, click TDSQL-H LibraDB.

         

   3. In the Configure Connection dialog box, configure the following parameters as required.

      Parameter	Description
      Display name	A custom name for this data source connection. The name cannot contain special characters or leading or trailing spaces.
      Database address and Port	Log on to the Tencent TDSQL-H LibraDB console, enable the public IP address on the instance details page, and copy the address and port from the basic information.
      Database	The name of the database to connect to.
      Username and Password	The username and password of the Tencent TDSQL-H LibraDB database. Note Ensure that the database user has the CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
      Time zone	The time zone of your Tencent TDSQL-H LibraDB database.
      SSL	Select this to enable a secure connection if your data source uses SSL.

   4. Click Test Connection to verify the data source connection.

      

   5. When the test succeeds, click OK to create the data source.