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
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.
To incorporate data tables or custom SQL from the AnalyticDB for MySQL 2.0 cloud database into Quick BI, refer to Create and Manage Datasets.
For adding visualization charts and data analysis, see Create a Dashboard and Overview of Visualization Charts.
To delve deeper into data analysis through drilling, consult Drilling Settings and Display.