Quick BI:Add a Huawei Cloud GaussDB(DWS) Data Source

Procedure

1. Add to the whitelist.

   Before connecting to Huawei GaussDB(DWS), you must add the IP address of Quick BI to the whitelist of Huawei GaussDB(DWS).

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

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

   2. Follow the instructions in the figure below to add a data source.

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

      2. Click to show more.

         

      3. Select the Huawei GaussDB(DWS) data source.

         

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

      Name	Description
      Display Name	The display name in the data source configuration list. The name cannot contain special characters or start or end with spaces.
      Database Address and Port	The external network address where the Huawei GaussDB(DWS) database is deployed. Log on to the Huawei Cloud Management Console. Bind the Elastic IP Address (EIP) on the instance basic information page and view it on the connection management page. For more information, see obtain the cluster connection address.
      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(DWS) database. Note Ensure that the user who logs on to the Huawei GaussDB(DWS) database has the create, insert, update, and delete permissions on the tables in the database.
      SSL	If the target data source has SSL configured, you can select the SSL security protocol to protect data security.

   4. Click Connection Test to verify the data source connectivity.

      

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