This topic explains how to create a user-created Gbase8a data source. The Professional Edition and Pro Edition of the group space are required to support this creation.
Prerequisites
Ensure your network meets the following criteria:
For Internet connections between Quick BI and the Gbase8a database, include Quick BI's IP address in the database whitelist. For more information, see Add Security Group Rule.
For internal network connections between Quick BI and the Gbase8a database, use one of the following methods:
Connect through Alibaba Cloud VPC if the Gbase8a database is hosted on Alibaba Cloud ECS.
Alternatively, deploy a jump server and establish an SSH tunnel to access the database.
A user-created Gbase8a database must be available.
You must have the username and password for the user-created Gbase8a database.
Limits
Only versions 8.6 and 9.5 are supported.
Procedure
Log on to the Quick BI console.
Follow the steps in the figure below to add a data source.
Navigate to the data source creation page via the data source creation entry.
Click Show more.
Select the Gbase8a data source.
In the New Data Source dialog box, enter the required configuration details.
Name
Description
Display Name
The display name in the data source configuration list.
The name cannot contain special characters or start or end with spaces.
Database Address
The address where the Gbase8a database is deployed, including the IP address or domain name.
Port
The correct port number. Default value: 5258.
Database
The name of the database that you want to access.
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
Specifies whether the data source is a user-created ECS VPC data source based on your business requirements. If you select VPC Data Source, you need to configure the following parameters:
Purchaser Accessid: The AccessKey ID of the purchaser of this instance.
For more information, see Obtain AccessKey.
NoteMake sure that the AccessKey ID has Read permissions on the destination instance. If it has Write permissions on the corresponding security group, the system automatically adds the whitelist. Otherwise, you need to add it manually. For more information, see Create a custom policy.
Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance.
For more information, see Obtain AccessKey.
Instance ID: The ID of the purchaser of this instance.
For more information, see View instance information.
Area: The area where this instance is located.
For more information, see View instance information.
SSH
Specifies whether to access the data source over an SSH tunnel based on your business requirements. If you select SSH, you need to configure the following parameters:
SSH Host: The hostname or IP address.
SSH Username: The SSH username that is used to connect to the database.
SSH Password: The password of the SSH username that is used to connect to the database.
SSH Port: The port that is used to connect to the database. Default value: 22.
Click Connection Test to verify the data source connectivity.
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 perform data analysis.
To add data tables from the Gbase8a database or create ad hoc analysis SQL in Quick BI, refer to Create and Manage Datasets.
For adding visualization charts and data analysis, see Create a Dashboard and Visualization Chart Overview.
To delve deeper into data analysis, consult Drill Settings and Display.