Quick BI:Add a RDS for SQL Server Data Source

Prerequisites

• You have created a Huawei Cloud SQL Server database.

• You have retrieved the username and password for the Huawei Cloud SQL Server database.

Limits

Support is provided for versions from 2008 to 2022.

Procedure

1. Add the whitelist.

   Before connecting to Huawei Cloud SQL Server, add Quick BI's IP address to the Huawei Cloud SQL Server whitelist.

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

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

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

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

      2. On the HUAWEI CLOUD Database tab, select RDS for SQL Server data source.

3. In the connection configuration dialog box, complete the configurations according to your business scenario.

   Name	Description
   Display Name	The display name in the data source configuration list. The name must be standardized. It cannot contain special characters or start or end with spaces.
   Database Address	The public address of the SQL Server database. Log on to the Huawei Cloud Management Console, bind an Elastic IP Address (EIP) on the instance basic information page, and view it on the connection management page.
   Port	Enter the correct port number. The default is 1433.
   Database	The name of the database to connect to.
   Schema	The schema of the database to connect to. The default is dbo.
   Username	The corresponding username.
   Password	The corresponding password of the database.
   SSL	If the target data source is configured with SSL, 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 during the initialization of the data source connection. Only SET statements are allowed for SQL statements executed during each initialization of the data source connection. Separate statements with periods.

4. Click Connection test to verify the data source connectivity.

   

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