All Products
Search
Document Center

Quick BI:AWS Data Sources SQL Server

Last Updated:Jan 20, 2025

This topic explains how to create an AWS data source for 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.

        image

      3. Select AWS for the data source type.

        image

  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.

    image

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

What to Do next

Following the creation of a data source, you can proceed to create datasets and analyze data.