Add a MySQL data source to connect the HUAWEI CLOUD MySQL database to the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. This topic describes how to add a HUAWEI CLOUD MySQL data source.
Prerequisites
A HUAWEI CLOUD MySQL database is created.
Limits
Supports 5.5, 5.6, 5.7, and 8.0 versions.
Procedure
Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.
Before connecting to HUAWEI CLOUD MySQL, you must add the Quick BI IP address to the whitelist of the HUAWEI CLOUD MySQL instance.
Add a Hologres data source and verify that the data source can be connected.
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 MySQL Data Source.
Select HUAWEI CLOUD for Data Source Type.
In the Configure Connection dialog box, configure the following settings based on your business requirements.
Feature
Description
Source Type
The MySQL data source type supports Alibaba Cloud, Tencent Cloud, HUAWEI CLOUD, Microsoft Cloud, AWS, and self-managed MySQL data sources.
HUAWEI CLOUD is selected in this example.
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 MySQL database is deployed. Log in to the HUAWEI CLOUD management console, bind the Elastic IP Address to the instance on the Basic Information page, and view it on the Connection Management page.
Instance
The name of the database to which you want to connect.
Username and Password
The username and password that are used to access the ApsaraDB RDS for MySQL database.
NoteMake sure that the user who logs on to the ApsaraDB RDS for MySQL database has the CREATE, INSERT, UPDATE, and DELETE permissions on tables in the database.
Engine Version
The version of the MySQL database.
If the database type is MySQL 5.7 or below, select 5.7. If the database type is MySQL 8.0, select 8.0.
SSL
If SSL is configured for the destination data source, you can select SSL to protect data security.
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.
Enable the file upload portal
You can upload files after you enable this function.
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 a data table in a MySQL data source or a user-created SQL 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.