This topic explains how to add a Huawei GaussDB data source in Quick BI, enabling the connection to a Huawei GaussDB database for data analysis and visualization.
Prerequisites
You have already created a Huawei GaussDB database.
Procedure
Add a whitelist.
Before connecting to Huawei GaussDB, add the IP address of Quick BI to the Huawei GaussDB whitelist.
Verify the data source connection and create a data source.
Log on to the or the international Quick BI console.
Use the following steps to add a data source:
Navigate to the data source creation interface via the data source creation entry.
Choose the Huawei GaussDB data source.
In the Configure Connection dialog box, configure the connection according to your business needs.
Name
Description
Display Name
The display name in the data source configuration list.
Enter a standard name. Do not use special characters or start or end with spaces.
Database Address and Port
The external network address where the Huawei GaussDB database is deployed.
Log on to the Huawei Cloud Management Console, bind an Elastic IP Address (EIP) on the instance basic information page, and view it on the connection management page.
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 database.
NoteEnsure that the user who logs on to the Huawei GaussDB database has the create, insert, update, and delete permissions on the tables in the database.
Test the connectivity by clicking Connection Test.
Once the test is successful, click OK to finalize the data source addition.
What to Do next
Once the data source is created, you can proceed to create datasets and analyze data.
For instructions on adding data tables or custom SQL statements from the Huawei GaussDB data source to Quick BI, refer to Create and Manage Datasets.
For guidance on creating visualization charts and analyzing data, refer to Create a Dashboard and Visualization Chart Overview.
For detailed steps on drilling and in-depth data analysis, refer to Drill Settings and Display.