You can connect to an ApsaraDB for SelectDB instance by using Quick BI. After an ApsaraDB for SelectDB instance is connected to Quick BI, you can analyze and display the data of the ApsaraDB for SelectDB instance in a visualized manner. This topic describes how to add an ApsaraDB for SelectDB instance as a data source to Quick BI.
Prerequisites
You have applied for a public endpoint for the ApsaraDB for SelectDB instance to which you want to connect. For more information, see Apply for or release a public endpoint.
The username and password that are used to log on to the ApsaraDB for SelectDB instance are obtained.
Procedure
Log on to the Quick BI console.
On the left-side of the Workbench tab, select a workspace. In the left-side navigation pane, choose Data Construction > Data Sources. In the upper-right corner of the Data Sources page, click Create Data Sources.
In the Create Data Source wizard, perform the following steps to add a data source:
In the Select Data Source step, click Show More.
Select SelectDB.
In the Configure Connection step, click Copy Whitelist to obtain the CIDR blocks of Quick BI. Add the copied content to the IP address whitelist of the ApsaraDB for SelectDB instance. For more information, see Configure an IP address whitelist.
Configure the parameters based on your business requirements. The following table describes the parameters.
Parameter
Description
Name
The name of the data source. The name is displayed in the data source list.
You must enter a valid value. The name cannot contain special characters. The name cannot start or end with a space.
Database address
The public endpoint of the ApsaraDB for SelectDB instance.
Port Number
The port number that is used to connect to the ApsaraDB for SelectDB instance over the MySQL protocol.
Database
The name of the database to which you want to connect in the ApsaraDB for SelectDB instance.
Username and Password
The username and password that are used to log on to the ApsaraDB for SelectDB instance.
Set the Username parameter to admin.
If you forget the password, go to the details page of the ApsaraDB for SelectDB instance and click Reset Password.
VPC Data Source
You do not need to configure this parameter.
SSH
You do not need to configure this parameter.
Click Test Connection to test whether 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 a data source is added to Quick BI, you can create datasets for data analysis by performing standard operations of Quick BI.
You can add tables and custom SQL statements of the ApsaraDB for SelectDB database to Quick BI. For more information, 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.