Quick BI:Add a GaussDB Data Source

Prerequisites

You have 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 Quick BI console.

   2. Follow these steps to add a data source:

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

      2. On the Huawei Cloud Database tab, select the GaussDB data source.

         

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

      Name	Description
      Display Name	The name of the data source. The name is displayed in the data source 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. Click Connection Test to test the connectivity of the data source.

      

   5. After the test is successful, click OK to complete adding the data source.