Adding a PolarDB for MySQL data source establishes a connection between the Alibaba Cloud PolarDB for MySQL database and Quick BI. After a successful connection, you can analyze and visualize data in Quick BI. Quick BI supports connections to Alibaba Cloud PolarDB for MySQL through either a public network or Alibaba Cloud VPC. This topic describes how to add an Alibaba Cloud PolarDB for MySQL data source.
Prerequisites
You have created an Alibaba Cloud PolarDB MySQL engine cluster. For more information, see Quick Start.
Background information
If you use a PolarDB database with a MySQL engine (PolarDB for MySQL), you can add a PolarDB for MySQL cloud data source when integrating with Quick BI for data analysis. For more information about PolarDB MySQL, see What is PolarDB.
To prevent data access failures due to data source whitelist restrictions, you need to add Quick BI's IP address to your data source's whitelist. For more information about integration configuration, see Setting a whitelist (migrated to parent).
Limits
Only space administrators and developers can add data sources.
Creating PolarDB for MySQL data sources is supported only in the Professional Edition and Premium Edition.
Supports versions 5.6, 5.7, 8.0.1, and 8.0.2.
Procedure
Log on to the Quick BI console.
Follow the steps in the image below to add a data source:
Access the data source creation interface through the data source creation entry.
On the Alibaba Cloud Database tab, select PolarDB for MySQL data source.
In the Configure Connection dialog box, configure the settings based on your business scenario.
Name
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
The public address of the PolarDB for MySQL database cluster deployment (if using a VPC data source, you need to fill in the internal address and internal port of the database deployment).
Log on to the PolarDB console, and in the basic information area, click Request on the right side of the public network to obtain the database address. Example: xxxxxxxxxxxxxxxxx.mysql.polardb.rds.aliyuncs.com.
Database
The custom database name when deploying the PolarDB for MySQL database cluster.
Log on to the PolarDB console, and in Database Management, obtain the Database Name.
Username and Password
The username and password for logging on to the PolarDB for MySQL database cluster.
Database Version
The version number of the MySQL engine in the PolarDB database cluster deployment.
Log on to the PolarDB console, and in the Cluster List, obtain the version number of the MySQL engine in Compatibility.
If the version number of the MySQL engine is MySQL 5.7 or below, select 5.7.
If the version number of the MySQL engine is MySQL 8.0, select 8.0.
VPC Data Source
When using Alibaba Cloud VPC network, select VPC Data Source and configure the following parameters:
Purchaser AccessId and Purchaser AccessKey: AccessKey ID and AccessKey Secret with access permissions to the target PolarDB for MySQL database. Ensure that the account has Read permission for the destination instance. Additionally, if Write permission is granted, the system will automatically add a whitelist. Otherwise, you need to add it manually. For related operation instructions, see Create a custom policy.
Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret.
Instance ID and Region: PolarDB for MySQL database cluster ID and its region.
Log on to the PolarDB console, and in the basic information area, obtain the instance ID.
NoteIf you select VPC Data Source, you need to fill in the internal address and internal port for the database address and port.
SSL
If the target data source is configured with SSL, you can select the SSL security protocol to protect data security.
Initialize SQL
The SQL statement executed after each data source connection is initialized. Only SET statements are allowed, separated by semicolons.
Enable File Upload Entry
Once enabled, it supports uploading files to the current database.
Click Connection Test to verify the data source connectivity.
After the test is successful, click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
To add data tables or custom SQL from the PolarDB for MySQL data source to Quick BI, see Create a dataset.
To add visualization charts and analyze data, see Create a dashboard and Visualization chart overview.
To drill down and perform in-depth data analysis, see Drill settings and display.