Quick BI:Tencent Cloud data source: TencentDB for SQL Server

Prerequisites

• A TencentDB for SQL Server instance is created.

• You have the username and password for the TencentDB for SQL Server instance.

Limitations

SQL Server 2008 to 2022 are supported.

Procedure

1. Configure an IP address whitelist.

   Before you connect to TencentDB for SQL Server, add the IP addresses of Quick BI to the IP address whitelist for your TencentDB for SQL Server instance. For instructions, see Configure a security group.

2. Test the connection and create the data source.

   1. Log on to the Quick BI console.

   2. Follow these steps to add a data source:

      1. Go to the data source creation page. For more information, see Create a data source.

      2. On the Tencent Cloud tab, select TencentDB for SQL Server.

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

   Parameter	Description
   Display name	The display name shown in the data source list. The name must not contain special characters or leading or trailing spaces.
   Database address	The hostname or public IP address of the TencentDB for SQL Server instance. To obtain the public IP address, log on to the Tencent Cloud console, enable the public endpoint on the instance details page, and find the address in the basic information section. For more information, see Connect to a SQL Server instance from a local client.
   Port	The port number. Default: 1433.
   Database	The name of the database.
   Schema	The schema name. Default: dbo.
   Username	The username for accessing the database.
   Password	The password for the username.
   Enable file upload	Enable this option to allow file uploads.
   Initial SQL	Enable this option to run SQL statements automatically after a connection is established. The statements run each time the data source is initialized. Only SET statements are allowed. Separate multiple statements with semicolons (;).

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

   

5. If the connection test is successful, click OK to add the data source.