Connect Quick BI to an Alibaba Cloud PolarDB for MySQL database over a public network or VPC, then analyze and visualize your data in Quick BI.
Prerequisites
You have created a PolarDB for MySQL cluster. For more information, see Quick Start.
Background Information
PolarDB for MySQL clusters can serve as data sources in Quick BI. For more information about PolarDB, see What is PolarDB?.
To avoid connection failures due to whitelist restrictions, add the IP addresses of Quick BI to your data source's whitelist. For configuration details, see Configure a whitelist.
Limitations
-
Only workspace administrators and developers can add data sources.
-
Only the Professional and Advanced editions of Quick BI support creating PolarDB for MySQL data sources.
-
PolarDB for MySQL versions 5.6, 5.7, 8.0.1, and 8.0.2 are supported.
Procedure
-
Log on to the Quick BI console.
-
Add a data source.
-
Go to the data source creation page. For more information, see Create a data source.
-
On the Alibaba Cloud Databases tab, select PolarDB for MySQL.
-
-
In the Configure Connection dialog box, configure the following parameters.
Parameter
Description
Display name
The name of the data source shown in the configuration list.
The name cannot contain special characters, leading spaces, or trailing spaces.
Database endpoint and port
The public endpoint of the PolarDB for MySQL cluster. For a VPC-based data source, enter the internal endpoint and port number instead.
To obtain the endpoint, log on to the PolarDB console and click Apply next to the public endpoint in the Basic Information section. Example:
xxxxxxxxxxxxxxxxx.mysql.polardb.rds.aliyuncs.com.Database
The database name in your PolarDB for MySQL cluster.
To obtain the database name, log on to the PolarDB console and find the Database Name in the Database Management section.
Username and password
The username and password for your PolarDB for MySQL cluster.
Database version
The MySQL engine version of your PolarDB cluster.
To obtain the version, log on to the PolarDB console and find the engine version under Compatibility in the Cluster List section.
-
If the MySQL engine version is 5.7 or earlier, select 5.7.
-
If the MySQL engine version is 8.0, select 8.0.
VPC-based data source
To connect through an Alibaba Cloud VPC, select VPC-based data source and configure the following parameters:
-
Purchaser's AccessId and Purchaser's AccessKey: The AccessKey ID and AccessKey Secret of an account with permissions to access the target PolarDB for MySQL database. The account must have read permissions on the target instance. If the account also has write permissions, Quick BI automatically adds its IP address to the whitelist. Otherwise, you must add it manually. For more information, see Create a custom policy.
To obtain an AccessKey ID and AccessKey Secret, log on to the RAM console.
-
Instance ID and region: The ID of the PolarDB for MySQL cluster and the region where the cluster is located.
To obtain the instance ID, log on to the PolarDB console and find the ID in the Basic Information section.
NoteIf you select a VPC-based data source, you must enter the internal endpoint and internal port for the database endpoint and port.
SSL
Select SSL to encrypt data transmission if your data source requires it.
Initialization SQL
SQL statements to run after each connection is established. Only
SETstatements are allowed. Separate multiple statements with semicolons (;).Enable file upload entry
Allow file uploads to this database.
-
-
Click Test Connection to verify the connection.
-
If the connection test is successful, click OK.
Next steps
After the data source is created, you can build a dataset and start analyzing data.
-
To add tables or custom SQL queries from your PolarDB for MySQL data source to Quick BI, see Create a dataset.
-
To add visual charts and analyze data, see Create a dashboard and Overview of visual charts.
-
To perform a drill-down analysis of your data, see Step 3: Configure and use drill-down.