Connect your ApsaraDB for SelectDB instance to Quick BI to build charts and dashboards from your database data. After completing this guide, you will have a working data source in Quick BI that you can use to create datasets and visualizations.
Prerequisites
Before you begin, make sure you have:
A public endpoint configured for the ApsaraDB for SelectDB instance. See Apply for or release a public endpoint
The username and password for the instance
Add SelectDB as a data source
Step 1: Open the data source creation wizard
Log in to the Quick BI console.
Log on to the Quick BI console.
On the Workbench tab, select a workspace in the left panel. In the navigation pane, choose Data Construction > Data Sources. In the upper-right corner, click Create Data Sources.
In the Select Data source step, click Show More.
Select SelectDB.
Step 2: Configure the IP address whitelist
In the Configure Connection step, click Copy Whitelist to get the CIDR blocks used by Quick BI, then add them to the IP address whitelist of your ApsaraDB for SelectDB instance. See Configure an IP address whitelist.
Complete the whitelist step before testing the connection. Without it, the connectivity test will fail.
Step 3: Configure connection parameters
Fill in the connection parameters using the values from your SelectDB instance details page.
| Parameter | Description |
|---|---|
| Name | A display name for this data source in the data source list. Cannot contain special characters or start or end with a space. |
| Database address | The public endpoint of the ApsaraDB for SelectDB instance. |
| Port number | The port used to connect over the MySQL protocol. |
| Database | The name of the database to connect to. |
| Username | Set to admin. |
| Password | The instance password. To reset it, go to the instance details page and click Reset Password. |
| VPC Data Source | Leave blank. |
| SSH | Leave blank. |
Step 4: Test and save the connection
Click Test Connection to verify the connection.
After the connectivity test passes, click OK. The SelectDB instance is now added as a data source.
What's next
With a data source connected, you can start building reports in Quick BI:
Create datasets: Add tables or write custom SQL queries against your SelectDB database. See Create and manage datasets.
Build dashboards: Add charts and visualizations to a dashboard. See Create a dashboard. For available chart types, see Overview of visualization charts.
Drill down into data: Configure interactive drill-down for in-depth analysis. See Configure the drilling feature.