This topic describes how to add a user-created Kingbase data source.
Limits
Version 7.1.2 is supported.
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 the Kingbase database over the Internet, add the Quick BI IP address to the whitelist of the Kingbase database.
After you log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a Hologres data source.
Go to the Create Data Source page.
Click Show More.
Select the Kingbase data source.
In the Add Kingbase Data Source dialog box, configure the parameters based on your business requirements.
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 and Port Number
The address where the Kingbase database is deployed, including the IP address or domain name.
Database
The name of the database to which you want to connect.
Username and Password
The username that is used to connect to the database. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.
Engine Version
V7 and V8 are supported.
VPC Data Source
If you use a VPC, select VPC Data Source and configure the following parameters:
AccessKey ID and AccessKey: the AccessKey ID and AccessKey secret that are used to access the Kingbase cluster.
Instance ID: Log on to the ECS console and obtain the instance ID on the Instances tab.
Region of the ECS instance: Log on to the ECS console and obtain the region where the instance is located in the upper-left corner.
SSH
Specifies whether to access 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 test whether the data source can be connected.
After the data source passes the connectivity test, 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 Kingbase database or user-created custom 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.