Add an AnalyticDB for MySQL 2.0

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

1. Log on to the Quick BI console.

2. Navigate to the data source creation interface using the designated entry point.

   1. Access the data source creation interface.

   2. Choose Alibaba AnalyticDB for MySQL as the data source type.

      

   3. Select Alibaba AnalyticDB for MySQL 2.0 as the database version.

      

3. 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.

4. Click Connection Test to verify the data source connectivity.

   

5. 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.