Quick BI:Huawei Cloud GaussDB(DWS) data source

Procedure

1. Add IP addresses to the whitelist.

   Before connecting to Huawei Cloud GaussDB(DWS), add the IP addresses of Quick BI to your GaussDB(DWS) instance's whitelist.

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

   1. Log on to the Quick BI console.

   2. Follow the steps below to add a data source:

      1. Go to the page for creating a data source.

      2. On the Huawei Cloud tab, click GaussDB(DWS).

         

   3. In the Configure Connection dialog box, configure the following parameters.

      Parameter	Description
      display name	The display name for this data source in the data source list. Enter a valid name. Do not use special characters or include leading or trailing spaces.
      host and port	The public endpoint of your Huawei Cloud GaussDB(DWS) database. To find the endpoint, log on to the Huawei Cloud console, go to your instance's basic information page, and bind an elastic IP address. The endpoint is available on the connection management page.
      database	The name of the database to connect to.
      schema	The name of the schema to connect to.
      username and password	The username and password for the GaussDB(DWS) database. Note Make sure that the user has the create, insert, update, and delete permissions on tables in the database.
      SSL	Enable this option if your data source uses SSL encryption.

   4. Click Test Connection to verify the connection.

      

   5. After a successful test, click OK to add the data source.