Quick BI:Add a Huawei Cloud GaussDB(DWS) data source

Procedure

1. Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.

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

2. Add a Hologres data source and verify that the data source can be connected.

   1. After you log on to the Quick BI console.

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

      1. Go to the Create Data Source page.

      2. Click Show More.

         

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

         

   3. In the Configure Connection dialog box, configure the following settings based on your business requirements.

      Component	Description
      Display Name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
      Database Address and Port Number	Deploy the public endpoint of the Huawei GaussDB(DWS) database. Log in to the HUAWEI CLOUD management console, bind the Elastic IP Address to the instance on the Basic Information page, and view it on the Connection Management page.
      Database	The name of the database to which you want to connect.
      Schema	The schema of the database.
      Username and Password	User name and password for logging in to the Huawei GaussDB(DWS) database. Note Make sure that the user who logs on to the Huawei GaussDB(DWS) database has the permissions to create, insert, update, and delete tables in the database.
      SSL	If SSL is configured for the destination data source, you can select SSL to protect data security.

   4. Click Test Connection to verify that the data source can be connected.

      

   5. Click OK.