Quick BI:AWS Data Sources SQL Server

Prerequisites

• An AWS SQL Server database has been created.

• You have obtained the username and password for the AWS SQL Server database.

Limits

Support is provided for versions from 2008 to 2022.

Procedure

1. Add Quick BI's IP address to the whitelist.

   Before connecting to AWS SQL Server, add the IP address of Quick BI to the AWS SQL Server whitelist.

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

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

   2. Add a data source as shown in the following figure.

      1. Access the data source creation interface via the data source creation entry.

      2. Choose SQL Server as the data source.

         

      3. Select AWS for the data source type.

         

3. In the Configuration Connection dialog box, configure the settings as needed for your business scenario.

   Name	Description
   Display Name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database Address	The public address where the SQL Server database is deployed. Log on to the Amazon RDS console and obtain the public address in the instance details. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com.
   Port	Enter the correct port number. The default is 1433.
   Database	The name of the database that you want to access.
   Schema	The schema of the database that you want to access. The default is dbo.
   Username	The corresponding username.
   Password	The corresponding password of the database.
   Enable file upload entry	After enabling, file upload is supported.
   Initialize SQL	After enabling, you can configure the SQL statement to be executed after the data source connection is initialized. Only SET statements are allowed for the SQL statement executed after each data source connection initialization. Separate statements with a semicolon.

4. Click Connection Test to verify the data source's connectivity.

   

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