Quick BI:Add a Huawei Cloud GaussDB Data Source

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.

         

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

      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.

      

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