Connect your SelectDB database to Quick BI by adding it as a data source. After the connection is established, you can analyze and visualize data in Quick BI. Quick BI supports connecting to a SelectDB database over the public network or through an Alibaba Cloud VPC. This topic explains how to add a SelectDB data source.
Prerequisites
Ensure network connectivity:
If you connect Quick BI to your SelectDB database over the public network, add the Quick BI IP addresses to your database's allowlist. For more information, see Use security groups.
If you connect Quick BI to your SelectDB database over a private network, connect using one of the following methods:
If your SelectDB database is hosted on an Alibaba Cloud ECS instance, you can connect to it through a VPC.
Alternatively, establish an SSH tunnel through a bastion host.
You have created a SelectDB database.
You have the username and password for your SelectDB database.
Procedure
Log on to the Quick BI console.
Add the data source:
Go to the page for creating a data source. For more information, see Create a data source.
On the User-created Data Source tab, select SelectDB.
In the Configure Connection dialog box, configure the following settings based on your business requirements.
Parameter
Description
Display name
The name for the data source as it appears in the data source list.
The name must not contain special characters or have leading or trailing spaces.
Database address
The IP address or domain name of your SelectDB database.
Port
The port number of the database.
Database
The name of the database that you specified when you created the SelectDB database.
Username and Password
Enter the username and password for connecting to the SelectDB database. Ensure that the user has CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
VPC data source
Select VPC Data Source and configure the following parameters only if your SelectDB database is deployed on an Alibaba Cloud ECS instance and uses a VPC network.
Purchaser AccessKey ID: The AccessKey ID of the account that purchased the instance.
For more information, see Create an AccessKey.
NoteThe AccessKey ID must have Read permissions on the target instance. If the AccessKey ID also has Write permissions on the corresponding security group, Quick BI automatically adds the required IP addresses to the allowlist. Otherwise, you must add them manually. For more information, see Create a custom policy.
Purchaser AccessKey Secret: The AccessKey Secret of the account that purchased the instance.
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 where the ECS instance is located.
For more information, see View instance information.
SSH
If you select SSH, configure the following parameters:
Contact your operations engineer or system administrator to obtain the bastion host information.
SSH host: Enter the IP address of the bastion host.
SSH username: The username for logging on to the bastion host.
SSH password: The password that corresponds to the SSH username.
SSH port: The port of the bastion host. The default is 22.
For more information, see Use OpenSSH or Xshell to connect to a Linux instance.
Click Test Connection to verify the connection.
If the connection test is successful, click OK to add the data source.
Next steps
After you create the data source, you can create datasets and analyze data.
To add tables or custom SQL queries from your SelectDB database to Quick BI, see Create a dataset.
To add charts and analyze data, see Create a dashboard and Overview of chart types.
To drill down and perform in-depth data analysis, see Step 3: Configure and display drill-down settings.