All Products
Search
Document Center

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

Last Updated:Jan 20, 2025

This topic explains how to establish 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.

        image.png

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

        image.png

    3. In the Configure Connection dialog box, you can configure the following settings to suit your business scenario.image

      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.

      image

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

What to Do next

Following data source creation, proceed to dataset creation and data analysis.