Quick BI can connect to the Huawei Cloud GaussDB database. This topic describes how to add a Huawei GaussDBL data source.
Prerequisites
A Huawei GaussDB database is created.
Procedure
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, you need to add the Quick BI IP address to the whitelist of Huawei GaussDB.
Add a Hologres data source and verify that the data source can be connected.
After you log on to the Quick BI console.
Follow the instructions in the following figure to add a data source
Go to the Create Data Source page.
Click Show More.
Select the Huawei GaussDB data source.
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
The public endpoint of the Huawei GaussDB 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 database.
NoteMake sure that the user who logs in to the Huawei GaussDB database has the permissions to create, insert, update, and delete tables in the database.
Click Test Connection to verify that the data source can be connected.
Click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add a data table in the Huawei GaussDB data source or a user-created custom SQL Quick BI, see Create and manage datasets.
You can add charts and analyze data. For more information, see Create a dashboard and Overview.
You can drill down and further analyze data. For more information, see Drilling, filter interaction, and hyperlink.