Connect Quick BI to a Huawei Cloud MySQL database by adding a MySQL data source. After the connection is established, you can analyze and visualize your data in Quick BI.
Prerequisites
You have created a Huawei Cloud MySQL database instance.
Limitations
This data source supports MySQL versions 5.5, 5.6, 5.7, and 8.0.
Procedure
-
Add IP addresses to the allowlist.
Before you connect to Huawei Cloud MySQL, you must add the Quick BI IP addresses to the allowlist of your Huawei Cloud MySQL instance.
-
Test the connection and create the data source.
-
Log on to the Quick BI console.
-
To add a data source:
-
Follow the steps in Create a data source to navigate to the data source creation page.
-
On the Huawei Cloud Databases tab, select the MySQL data source.
-
-
In the Configure Connection dialog box, configure the following parameters.
Parameter
Description
Display name
The display name of the data source in the data source list.
Enter a name that does not contain special characters or leading or trailing spaces.
Database address and port
To obtain the endpoint, log on to the Huawei Cloud console, go to the basic information page of the instance, and bind an elastic IP address. The endpoint is available on the connection management page.
Database
The name of the database to connect to.
Username and password
The username and password for the MySQL database.
NoteEnsure that the user has create, insert, update, and delete permissions on the database tables.
Database version
The MySQL version of your database.
Select 5.7 for MySQL 5.7 or earlier. Select 8.0 for MySQL 8.0.
SSL
Enable this option if SSL is configured for the target data source to secure data transmission.
Initialization SQL
When enabled, initialization SQL statements run after a connection is established.
Only
SETstatements are allowed. Separate multiple statements with a semicolon (;).Enable file upload
When enabled, you can upload files to this data source.
-
Click Test Connection to verify connectivity.
-
After the connection test succeeds, click OK to add the data source.
-
Next steps
After the data source is created, you can create a dataset to start analyzing your data.
-
To add tables or custom SQL queries from your MySQL data source to Quick BI, see Create a dataset.
-
To create visualizations and analyze data, see Create a dashboard and Overview of visualizations.
-
To drill down into your data for in-depth analysis, see Step 3: Configure and display drill down actions.