This topic describes how to add a HUAWEI CLOUD data source of the SQL Server type.
A HUAWEI CLOUD SQL Server database is created.
You have obtained the username and password of the HUAWEI CLOUD SQL Server database.
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 the HUAWEI CLOUD SQL Server, add the Quick BI IP address to the whitelist of the HUAWEI CLOUD SQL Server.
Add a Hologres data source and verify that the data source can be connected.
In the Configure Connection dialog box, configure the following settings based on your business scenario.
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.
The public endpoint where the SQL Server database is deployed. Log in to the HUAWEI CLOUD management console, bind the Elastic IP Address to the instance on the Basic Information page, and view it on the Connection Management page.
The port number of the database that you want to access. Default value: 1433.
The name of the database that you want to access.
The schema of the database. Default value: dbo.
The username that you use to access the database.
The password that is used to log on to the database.
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.
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 drill down and further analyze data. For more information, see Drilling, filter interaction, and hyperlink.