Connect your Alibaba Cloud AnalyticDB for MySQL 2.0 database with Quick BI by adding it as a data source. Once connected, you can perform data analysis and visualization within Quick BI. Quick BI facilitates connections to Alibaba Cloud AnalyticDB for MySQL 2.0 over the Internet. This topic guides you through the process of adding an Alibaba Cloud AnalyticDB for MySQL 2.0 data source.
Prerequisites
You must have an AnalyticDB MySQL cluster created, with the cluster version being 2.0.
If you are utilizing the cloud-native data warehouse AnalyticDB MySQL 2.0, you can integrate it with Quick BI for data analysis by adding an AnalyticDB for MySQL 2.0 cloud data source.
Limits
Only space administrators and developers are authorized to add data sources.
Procedure
Log on to the Quick BI console.
Navigate to the data source creation interface using the designated entry point.
Access the data source creation interface.
Choose Alibaba AnalyticDB for MySQL as the data source type.

Select Alibaba AnalyticDB for MySQL 2.0 as the database version.

In the Add Analyticdb For Mysql 2.0 Data Source dialog box, fill in the required configuration details.
Name | Description |
Select database version | Select AnalyticDB for MySQL 2.0. |
Display Name | The display name in the datasource config 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 privileges 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 periods. |
Click Connection Test to verify the data source connectivity.

Once the test is successful, click OK to finalize the addition of the data source.
What to Do next
After the data source is established, you can proceed to create datasets and analyze data.