Add a PolarDB for MySQL data source to connect to the Alibaba Cloud PolarDB for MySQL database and the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. You can connect a Quick BI to an Alibaba Cloud PolarDB for MySQL over the Internet or a VPC. This topic describes how to add an Alibaba Cloud PolarDB for MySQL data source.
Prerequisites
An Apsara PolarDB for MySQL cluster is created. For more information, see Quick start.
Background information
If you use a PolarDB database (PolarDB for MySQL) that runs MySQL, you can add a cloud data source PolarDB for MySQL when you connect the database to the Quick BI for data analysis. For more information about PolarDB for MySQL, see What is PolarDB?
To prevent data access failures due to the whitelist of the data source, you must add the Quick BI IP address to the whitelist of the data source. For more information, see Configure a whitelist.
Limits
Only workspace administrators and developers can add data sources.
Only Advanced Edition and Quick BI Enterprise Standard allow you to create PolarDB for MySQL data sources.
Procedure
After you log on to the Quick BI console.
Follow the instructions in the following figure to add a data source
Go to the Create Data Source page.
Select the Alibaba PolarDB for MySQL data source.
In the Configure Connection dialog box, configure the following settings based on your business requirements.
Item
Description
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 Number
The public endpoint where the PolarDB for MySQL database cluster is deployed (If you use a VPC data source, you must enter the internal endpoint and internal port of the deployed database).
Log on to the PolarDB console. In the Basic Information section, click Apply on the right side of Internet to obtain the database endpoint. Example: xxxxxxxxxxxxxxxxx.mysql.polardb.rds.aliyuncs.com.
Database
The name of the database that is customized when the PolarDB for MySQL DB cluster is deployed.
Log on to the PolarDB console. On the Databases page, obtain the name of the database.
Username and Password
The username and password used to log on to the PolarDB for MySQL DB cluster.
Engine Version
The version number of the MySQL engine where the PolarDB cluster is deployed.
Log on to the PolarDB console. In the Cluster List section, obtain the version number of the MySQL engine that is specified in Compatibility.
If the version number of the MySQL engine is MySQL 5.7 or earlier, select 5.7.
If the version number of the MySQL engine is MySQL 8.0, select 8.0.
VPC data source
If you use a VPC, select VPC data source and set the following parameters:
AccessKey ID and AccessKey: the AccessKey ID and AccessKey secret that are used to access the PolarDB for MySQL database.
Log on to the RAM console and obtain the AccessKey ID and AccessKey secret.
Instance ID and Region :PolarDB for MySQL the ID and region of the cluster.
Click Test Connection to verify that the data source can be connected.
After the database passes the connectivity test, 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 a data table in the PolarDB for MySQL data source or a user-created SQL statement to the Quick BI, see Create and manage datasets.
You can add charts and analyze data. For more information, see Create a dashboard and Overview.
You can drill down and further analyze data. For more information, see Drilling, filter interaction, and hyperlink.