All Products
Search
Document Center

Quick BI:Add a Huawei Cloud GaussDB Data Source

Last Updated:Jan 20, 2025

This topic explains how to add a Huawei GaussDB data source in Quick BI, enabling the connection to a Huawei GaussDB database for data analysis and visualization.

Prerequisites

You have already created a Huawei GaussDB database.

Procedure

  1. Add a whitelist.

    Before connecting to Huawei GaussDB, add the IP address of Quick BI to the Huawei GaussDB whitelist.

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

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

    2. Use the following steps to add a data source:

      1. Navigate to the data source creation interface via the data source creation entry.

      2. Choose the Huawei GaussDB data source.

        image

    3. In the Configure Connection dialog box, configure the connection according to your business needs.image

      Name

      Description

      Display Name

      The display name in the data source configuration list.

      Enter a standard name. Do not use special characters or start or end with spaces.

      Database Address and Port

      The external network address where the Huawei GaussDB database is deployed.

      Log on to the Huawei Cloud Management Console, bind an Elastic IP Address (EIP) on the instance basic information page, and view it on the connection management page.

      Database

      The name of the database to be connected.

      Schema

      The schema of the database that you want to access.

      Username and Password

      The username and password to log on to the Huawei GaussDB database.

      Note

      Ensure that the user who logs on to the Huawei GaussDB database has the create, insert, update, and delete permissions on the tables in the database.

    4. Test the connectivity by clicking Connection Test.

      image

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

What to Do next

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