All Products
Search
Document Center

Quick BI:AWS Data Source PostgreSQL

Last Updated:Jan 20, 2025

This topic explains how to create an AWS data source of the PostgreSQL type.

Prerequisites

  • You have created an AWS PostgreSQL database.

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

Limits

Support is provided for PostgreSQL version 8.2 and above.

Procedure

  1. Add Quick BI to the whitelist.

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

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

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

    2. You can add a data source by following the instructions in the figure below.

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

      2. Choose the PostgreSQL data source.

        image

      3. Select AWS as the data source type.

        image

  3. In the configure connection dialog box, complete the necessary configurations based on 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 and port

    The public address where the PostgreSQL database is deployed. Log on to the Amazon RDS console and obtain the public address in the instance details. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com.

    Database

    The name of the database to be connected.

    Schema

    The schema name of the PostgreSQL database.

    Username and password

    The username and password for logging on to the PostgreSQL database.

    SSL

    If the target data source is configured with SSL, you can select the security protocol SSL to protect data security.

    Initialize SQL

    After enabling, you can configure the SQL statement to be executed for initialization after the data source connection.

    Only SET statements are allowed for the SQL statement executed after each data source connection initialization, and statements are separated by semicolons.

    Enable upload file entry

    After enabling, file upload is supported.

  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

After the data source is created, you can proceed to create datasets and analyze data.