This topic describes how to add a user-created GBase data source in a group workspace. Only Quick BI Enterprise Standard and Quick BI Pro allow you to add user-created GBase data sources in group workspaces.
Prerequisites
Your network meets the following requirements:
If you want to connect your Quick BI to the GBase database over the Internet, add the Quick BI IP address to the whitelist of the database. For more information, see Add security group rules.
If you want to connect Quick BI to your GBase database over an internal network, make sure that one of the following methods is used to ensure the connectivity between Quick BI and the user-created GBase data source:
If the GBase database is deployed on an Elastic Compute Service (ECS) instance, you can use a virtual private cloud (VPC) to access the data source.
You can deploy a jump server and connect to the database over an SSH tunnel.
A GBase database is created.
The username and password that are used to access the GBase database are obtained.
Limits
Supports 8.6 and 9.5 versions.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a user-created GBase data source.
Go to the Create Data Source page.
Click Show More.
Select Gbase data source.
In the Add GBase Data Source dialog box, configure the parameters.
Parameter
Description
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
The address where the GBase database is deployed, including the IP address or domain name.
Port Number
The port number that is used to connect to the database. The default value is 5258.
Database
The name of the database to connect.
Username
The username that is used to connect to the database.
Password
The password that is used to connect to the database.
VPC Data Source
Select this option if you use a VPC to connect to the data source. If you select VPC Data Source, you must configure the following parameters:
AccessKey ID: the AccessKey ID that is used to purchase the instance.
AccessKey: the AccessKey secret that is used to purchase the instance.
Instance ID: the ID of the instance.
Region: the region in which the instance is deployed.
SSH
Specifies whether to connect to the data source over an SSH tunnel based on your business requirements. If you select SSH, you must configure the following parameters:
SSH Host: the hostname or IP address of the SSH host.
SSH Username: the username that is used to log on to the SSH host.
SSH Password: the password that is used to log on to the SSH host.
SSH Port Number: the port number that is used to connect to the SSH host. Default value: 22.
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 tables in the GBase database or user-created SQL statements to the Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.