This topic describes how to add a user-created Gbase 8a data source, a feature available only in Quick BI Professional Edition and Advanced Edition.
Prerequisites
Ensure you have network connectivity:
If you connect to your Gbase 8a database over the public network, you must add the IP addresses of Quick BI to the database whitelist. For more information, see Use a security group.
If you connect to your Gbase 8a database over a private network, use one of the following methods to connect the data source to Quick BI:
If your Gbase 8a database is deployed on an Alibaba Cloud ECS instance, you can connect to it through a VPC.
You can also set up a bastion host and access the database through an SSH tunnel.
You have a self-managed Gbase 8a database.
You have the username and password for your Gbase 8a database.
Limitations
Quick BI supports Gbase 8a versions 8.6 and 9.5.
Procedure
Log on to the Quick BI console.
Follow these steps to add the data source.
Go to the page for creating data sources. For instructions, see Create a data source.
On the User-Created Data Source tab, select the Gbase 8a data source.
In the Configure Connection dialog box, set the following parameters.
Parameter
Description
Display name
The name of the data source as it appears in the data source list.
The name must not contain special characters or leading or trailing spaces.
Host
The IP address or domain name of the Gbase 8a database.
Port
The port used to connect to the database. The default is 5258.
Database
The name of the database to connect to.
Username
The username for logging on to the database.
Password
The password that corresponds to the username.
VPC data source
Select this option if your data source is a user-created data source in an ECS VPC. If you select VPC data source, set the following parameters:
AccessKey ID: The AccessKey ID of the Alibaba Cloud account that owns the instance.
For more information, see Create an AccessKey.
NoteEnsure that the AccessKey ID has read permission on the target instance. If the AccessKey also has write permission on the relevant security group, Quick BI automatically adds its IP addresses to the whitelist. Otherwise, you must add the IP addresses manually. For more information, see Create a custom policy.
AccessKey Secret: The AccessKey Secret that corresponds to the AccessKey ID.
For more information, see Create an AccessKey.
Instance ID: The ID of the ECS instance.
For more information, see View instance information.
Region: The region of the ECS instance.
For more information, see View instance information.
SSH
Select this option if you want to connect to the data source through an SSH tunnel. If you select SSH, set the following parameters:
SSH Host: The hostname or IP address of the bastion host.
SSH Username: The username for the SSH connection.
SSH Password: The password for the SSH username.
SSH Port: The port for the SSH connection. The default is 22.
Click Test Connection to verify the data source connection.
After the connection test succeeds, click OK to add the data source.
Next steps
After you add the data source, you can create datasets and analyze data.
To add tables from your Gbase 8a database or create a dataset based on ad hoc SQL queries, see Create a dataset.
To add visualizations and analyze data, see Create a dashboard and Overview of visualizations.
To drill down for in-depth data analysis, see Step 3: Configure and display drill-down data.