All Products
Search
Document Center

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

Last Updated:Oct 13, 2023

Quick BI can connect to the Huawei Cloud GaussDB(DWS) database. This topic describes how to add a Huawei GaussDB(DWS)L 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.

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

        image.png
    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.

      image.png
    5. Click OK.

What to do next

After you add a data source, you can create a dataset and analyze data.