This topic describes how to add a Tencent Cloud data source of the SQL Server type.
Prerequisites
A Tencent Cloud SQL Server database is created.
The username and password of the Tengxun SQL Server database have been obtained.
Limits
2008 to 2022 versions is supported.
Procedure
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 you connect to the TencentDB for SQL Server instance, you must add the Quick BI IP address to the whitelist of the TencentDB for SQL Server instance.
Add a Hologres data source and verify that the data source can be connected.
After you log on to the Quick BI console.
Follow the instructions in the following figure to add a data source
Go to the Create Data Source page.
Select the SQL Server data source.
Select Tencent Cloud for Data Source Type.
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
The hostname or IP address of the database that you want to access. The public endpoint where the SQL Server database is deployed. Log on to the Tencent Cloud SQL Server console.
. On the Instance Details page, open the public endpoint and query it under Basic Information.
Port Number
The port number of the database that you want to access. Default value: 1433.
Instance
The name of the database that you want to access.
Schema
The schema of the database. Default value: dbo.
Username
The username that you use to access the database.
Password
The password that is used to log on to the database.
SSL
If SSL is configured for the destination data source, you can select SSL to protect data security.
Enable the file upload portal
You can upload files after you enable this function.
Click Test Connection to verify that the data source can be connected.
Click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add a data table in an SQL Server data source or a user-created SQL Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.