The SelectDB data source is used to connect the SelectDB database to the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. Quick BI, you can connect to the SelectDB database over the Internet or Alibaba Cloud VPC. This topic describes how to add a user-created SelectDB data source.
Prerequisites
Your network meets the following requirements:
If you Quick BI connect to the SelectDB 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 the Quick BI to the SelectDB database over an internal network, use one of the following methods to connect the data source to the Quick BI:
If the SelectDB database is deployed on an Elastic Compute Service (ECS) instance, you can connect the database to the database by using a virtual private cloud (VPC).
You can deploy a jump server and access the database over an SSH tunnel.
A user-created SelectDB database is created.
The username and password of the user-created SelectDB database are obtained.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a user-created MongoDB data source.
Go to the Create Data Source page.
Click Show More.
Select SelectDB.
In the Configure Connection dialog box, configure the following settings based on your business scenario.
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 SelectDB database is deployed, including the IP address or domain name.
Port Number
The port corresponding to the address of the SelectDB database.
Database
The custom database name when you deploy the SelectDB database.
Username and Password
The username and password used to log on to the SelectDB database. Make sure that the username has the 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 the SelectDB database is deployed on a ECS and the network type is Alibaba Cloud VPC.
AccessKey ID: the AccessKey ID that is used to purchase the instance.
For more information, see Obtain an AccessKey pair.
AccessKey: the AccessKey secret that is used to purchase the instance.
For more information, see Obtain an AccessKey pair.
Instance ID: the ID of the ECS instance.
Region: the region in which the ECS instance is deployed.
SSH
If you select SSH, you must configure the following parameters:
You can deploy a jump server and access the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators.
SSH Host: the IP address of the jump server.
SSH Username: the username that is used to log on to the jump server.
SSH Password: the password that is used to log on to the jump server.
SSH Port Number: the port number that is used to connect to the jump server. Default value: 22.
For more information, see Connect to a Linux instance by using a password.
Click Test Connection to verify that the data source can be connected.
After the connectivity test is passed, click OK. Then, the ApsaraDB for SelectDB instance is added as a data source.
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 data tables in the SelectDB 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.