Quick BI:Add a Tencent TDSQL-H LibraDB Data Source

Prerequisites

You must have already created the Tencent TDSQL-H LibraDB database.

Limits

Support is limited to mainstream mergetree-type table engines.

Procedure

1. Add Quick BI to the whitelist.

   Before connecting to Tencent TDSQL-H LibraDB, ensure the IP address of Quick BI is whitelisted in Tencent TDSQL-H LibraDB.

2. Establish the data source connection.

   1. Access the or the international Quick BI console.

   2. To add a data source, please refer to the instructions provided in the figure below.

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

      2. Click on Show More.

         

      3. Choose the Tencent TDSQL-H LibraDB data source.

         

   3. In the Configure Connection dialog box, you can configure the following settings to suit 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 Tencent TDSQL-H LibraDB database is deployed. Log on to the Tencent TDSQL-H LibraDB console, enable the public address on the instance product page, and view it in the basic information.
      Database	The name of the database to be connected.
      Username and Password	The username and password to log on to the Tencent TDSQL-H LibraDB database. Note Ensure that the user who logs on to the Tencent TDSQL-H LibraDB database has create, insert, update, and delete permissions on the tables in the database.
      Time Zone	The time zone where the Tencent TDSQL-H LibraDB database is deployed.
      SSL	If the target data source has SSL configured, you can select the secure protocol SSL to protect data security.

   4. To verify the data source connectivity, click Connection Test.

      

   5. Once the test succeeds, click OK to finalize the addition of the data source.