Add an AnalyticDB for MySQL 2.0 data source to connect Quick BI to your AnalyticDB for MySQL 2.0 database. Once connected, you can analyze and visualize data in Quick BI. This topic explains how to add an Alibaba Cloud AnalyticDB for MySQL 2.0 data source.
Prerequisites
You have created an AnalyticDB for MySQL 2.0 cluster.
If you use AnalyticDB for MySQL 2.0 as a cloud-native data warehouse, you can add it as a cloud data source in Quick BI.
Limitations
Only workspace administrators and developers can add data sources.
Procedure
Log on to the Quick BI console.
Follow the steps below to add a data source.
Go to the Create Data Source page.
On the Alibaba Cloud Databases tab, select the AnalyticDB for MySQL data source.
For the database version, select AnalyticDB for MySQL 2.0.
In the Add AnalyticDB for MySQL 2.0 data source dialog box, configure the following parameters.
Parameter
Description
Select database version
Select AnalyticDB for MySQL 2.0.
Display name
The display name of the data source in the data source list.
The name cannot contain special characters or begin or end with a space.
Database address and port
The resource group endpoint and port of your AnalyticDB for MySQL 2.0 database.
Database
The name of the target AnalyticDB for MySQL 2.0 database.
AccessKey ID and AccessKey Secret
The AccessKey ID and AccessKey Secret with permissions to access the target AnalyticDB for MySQL 2.0 database.
Log on to AccessKey Management to obtain the AccessKey ID and AccessKey Secret.
Initialize SQL
If enabled, you can configure SQL statements that run automatically upon connecting to the data source.
Only SET statements are allowed. Separate multiple statements with a semicolon (;).
Click Test connection to verify the connection.
After the test passes, click OK to add the data source.
Next steps
After creating a data source, you can create datasets and analyze data.
To add data tables or use custom SQL from your AnalyticDB for MySQL 2.0 database, see Create a dataset.
To add visualization charts and analyze data, see Create a dashboard and Overview of visualization charts.
To drill down into your data, see Step 3: Configure and display drill-down data.