Quick BI:Tencent Cloud Data Source SQL Server

Prerequisites

• You have created a Tencent Cloud SQL Server database.

• You have obtained the username and password for the Tencent Cloud SQL Server database.

Limits

Support is available for versions from 2008 to 2022.

Procedure

1. Add the IP address of Quick BI to the whitelist of your Tencent Cloud SQL Server.

   Before connecting to Tencent Cloud SQL Server, you need to add the IP address of Quick BI to the whitelist.

2. Verify the data source connection and create a data source.

   1. Log on to the or the international Quick BI console.

   2. Follow the instructions below to add a data source.

      1. Navigate to the data source creation page from the data source creation entry.

      2. Select the SQL Server data source type.

         

      3. Choose Tencent Cloud as the data source type.

         

3. In the Configure Connection dialog box, complete the configurations as per your business scenario.

   Name	Description
   Display Name	The display name in the datasource config list. The name must be standardized. It cannot contain special characters or start or end with spaces.
   Database Address	Enter the hostname or IP address. This is the public address of the SQL Server database. Log on to the Tencent Cloud SQL Server console , enable the public address on the instance product page, and query it under Basic Information.
   Port	Enter the correct port number. The default value is 1433.
   Database	The name of the database to connect to.
   Schema	The schema of the database to connect to. The default value is dbo.
   Username	The corresponding username.
   Password	The corresponding password of the database.
   SSL	If the target data source has SSL configured, you can select the SSL security protocol to protect data security.
   Enable file upload entry	After enabling, file uploads are supported.
   Initialize SQL	After enabling, you can configure the SQL statements to be executed for initialization after the data source connection is established. Only SET statements are allowed in the SQL statements executed for initialization after each data source connection. Separate statements with periods.

4. Click Connection Test to verify the data source's connectivity.

   

5. Once the test is successful, click OK to finalize the data source addition.