Quick BI:Tencent TDSQL-H LibraDB data source

Prerequisites

A Tencent TDSQL-H LibraDB database is created.

Limits

only mainstream mergetree table engines are supported.

Procedure

1. Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.

   Before connecting to Tencent TDSQL-H LibraDB, you need to add the Quick BI IP address to the whitelist of Tencent TDSQL-H LibraDB.

2. Add a Hologres data source and verify that the data source can be connected.

   1. After you log on to the Quick BI console.

   2. Follow the instructions in the following figure to add a data source

      1. Go to the Create Data Source page.

      2. Click Show More.

         

      3. Select Tencent TDSQL-H LibraDB data source.

         

   3. In the Configure Connection dialog box, configure the following settings based on your business requirements.

      Feature	Description
      Name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
      Database Address and Port Number	Deploy the public endpoint of Tencent TDSQL-H LibraDB database. Log on to the Tencent TDSQL-H LibraDB console, open the public endpoint on the instance details page, and view the public endpoint in the Basic Information section.
      Instance	The name of the database to which you want to connect.
      Username and Password	The username and password used to log on to Tencent TDSQL-H LibraDB. Note Make sure that the user who logs on to Tencent TDSQL-H LibraDB has the permissions to create, insert, update, and delete tables in the database.
      Time zone	The time zone where the Tencent TDSQL-H LibraDB database is deployed.
      SSL	If SSL is configured for the destination data source, you can select SSL to protect data security.

   4. Click Test Connection to verify that the data source can be connected.

      

   5. Click OK.