HUAWEI CLOUD RDS for SQL Server data source

Prerequisites

• You have created a HUAWEI CLOUD SQL Server database instance.

• You have the username and password for the HUAWEI CLOUD SQL Server database.

Limitations

This data source supports SQL Server versions from 2008 to 2022.

Procedure

1. Add IP addresses to the whitelist.

   Before connecting to HUAWEI CLOUD SQL Server, add the IP addresses of Quick BI to the whitelist of your HUAWEI CLOUD SQL Server instance.

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

   1. Log on to the Quick BI console.

   2. Add a data source:

      1. Go to the data source creation page from the Create Data Source entry point.

      2. On the HUAWEI CLOUD databases tab, select RDS for SQL Server.

3. In the connection configuration dialog box, configure the following parameters.

   Parameter	Description
   display name	The name of the data source as it appears in the data source list. The name cannot contain special characters or leading or trailing spaces.
   database address	The public endpoint of the SQL Server database instance. To obtain this address, log on to the HUAWEI CLOUD console. On the instance details page, bind an elastic public IP address. You can then view the address on the connection management page.
   port	The port number of the database. The default value is 1433.
   database	The name of the database to connect to.
   schema	The name of the schema to connect to. The default is dbo.
   username	The username for database authentication.
   password	The password that corresponds to the username.
   Enable upload entry	Select this option to allow file uploads.
   initialization SQL	Specifies SQL statements that are executed immediately after a connection is established. Only SET statements are allowed. Separate multiple statements with semicolons (;).

4. Click test connection to verify the data source connection.

   

5. After a successful connection test, click OK to create the data source.