Add a AnalyticDB for MySQL 2.0 data source to connect the Alibaba Cloud AnalyticDB for MySQL 2.0 database to the Quick BI. After the connection is successful, you can analyze and display data on the 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
An AnalyticDB for MySQL cluster is created. The version of the cluster is 2.0.
If you are using the cloud-native data warehouse AnalyticDB for MySQL 2.0, you can add AnalyticDB for MySQL 2.0 cloud data sources when connecting to the Quick BI for data analysis. For more information about AnalyticDB for MySQL, see cloud-native Data Warehouse AnalyticDB for MySQL Product Introduction.
Limits
Only workspace administrators and developers can add data sources.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add an AnalyticDB for MySQL V2.0 data source.
Go to the Create Data Source page from the Create Data Source page.
Select the Alibaba AnalyticDB for MySQL data source.
Select Alibaba AnalyticDB for MySQL 2.0 for the database version.
In the Add AnalyticDB for MySQL 2.0 Data Source dialog box, configure the following settings.
Feature
Description
Engine Version
Select AnalyticDB for MySQL 2.0.
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 Number
The address and port of the classic network where the AnalyticDB for MySQL 2.0 database is deployed.
Instance
The database name of the connection AnalyticDB for MySQL 2.0.
AccessKey ID and AccessKey Secret
The AccessKey ID and AccessKey secret that are used to access the destination AnalyticDB for MySQL 2.0 database.
You can obtain the AccessKey ID and AccessKey secret on the AccessKey Management page.
Initialize SQL statements
The SQL statement that is initialized and executed after each data source connection. Only SET statements are allowed. The statements are separated by semicolons.
Click Test Connection to verify that the data source can be connected.
Click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add data tables or custom SQL statements from the AnalyticDB for MySQL 2.0 ApsaraDB to the Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.