Quick BI:AWS Data Sources SQL Server

Prerequisites

• The AWS SQL Server database is created.

• The username and password of the AWS SQL Server database are obtained.

Limits

2008 to 2022 versions is supported.

Procedure

1. 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 AWS SQL Server, add the Quick BI IP address to the AWS SQL Server whitelist.

2. Add a Hologres data source and verify that the data source can be connected.

   1. After you log on to the Quick BI console.

   2. Follow the instructions in the following figure to add a data source

      1. Go to the Create Data Source page.

      2. Select the SQL Server data source.

         

      3. Select AWS for Data Source Type.

         

3. 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 public endpoint where the SQL Server database is deployed. Log on to the Amazon RDS console and obtain the public endpoint in the instance details. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com.
   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.

4. Click Test Connection to verify that the data source can be connected.

   

5. Click OK.