Adding an AnalyticDB for MySQL 2.0 data source connects your Alibaba Cloud AnalyticDB for MySQL 2.0 database with Quick BI. After establishing the connection, you can analyze and visualize data in Quick BI. Quick BI supports connecting to Alibaba Cloud AnalyticDB for MySQL 2.0 over the Internet. This topic describes how to add an Alibaba Cloud AnalyticDB for MySQL 2.0 data source.
Prerequisites
You have created an AnalyticDB MySQL cluster with version 2.0.
If you are using the cloud-native data warehouse AnalyticDB MySQL 2.0, you can add an AnalyticDB for MySQL 2.0 cloud data source when integrating with Quick BI for data analysis.
Limits
Only space administrators and developers are authorized to add data sources.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a data source.
Access the data source creation interface from the data source creation entry point.
On the Alibaba Cloud Database tab, select AnalyticDB for MySQL as the data source.
Select Alibaba AnalyticDB for MySQL 2.0 as the database version.
In the Add AnalyticDB For MySQL 2.0 Data Source dialog box, complete the configuration.
Name
Description
Select database version
Select AnalyticDB for MySQL 2.0.
Display 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 and Port
The address and port of the classic network where the AnalyticDB for MySQL 2.0 database is deployed.
Database
The name of the database to connect to AnalyticDB for MySQL 2.0.
AccessKey ID and AccessKey Secret
The AccessKey ID and AccessKey Secret with access permissions to the target AnalyticDB for MySQL 2.0 database.
Log on to AccessKey Management to obtain the AccessKey ID and AccessKey Secret.
Initialize SQL
After enabling, you can configure the SQL statement to be executed after the data source connection is initialized.
Only SET statements are allowed for the SQL statement executed after each data source connection initialization, separated by semicolons.
Click Connection Test to verify the data source connectivity.
After the test is successful, click OK to complete adding the data source.
What to do next
After you add a data source, you can create a dataset and analyze data.
To add data tables or custom SQL from the AnalyticDB for MySQL 2.0 cloud database to Quick BI, see Create a dataset.
To add visualization charts and analyze data, see Create a dashboard and Overview of visualization charts.
To drill down and perform in-depth data analysis, see Drilling settings and display.