Learn how to add an AWS_MySQL data source in Quick BI to establish a connection with your AWS_MySQL database. Once connected, you can perform data analysis and visualization in Quick BI. This topic guides you through the process of adding an AWS_MySQL data source.
Limits
Supports MySQL versions 5.5, 5.6, 5.7, and 8.0.
Procedure
Add a whitelist.
Before connecting to AWS_MySQL, add the IP address of Quick BI to the AWS_MySQL whitelist.
Verify the data source connection and create a data source.
Log on to or the Quick BI console.
Follow the steps below to add a data source:
Access the data source creation interface via the data source creation entry.
Select the MySQL data source type.
Choose AWS as the data source type.
In the configure connection dialog box, complete the configurations as per your business requirements.
Name
Description
Name
Description
Data source type
The MySQL data source type supports Alibaba Cloud, Tencent Cloud, Huawei Cloud, Microsoft Cloud, AWS, and self-built.
In this example, select AWS.
Display name
The display name in the datasource config list.
The name cannot contain special characters or start or end with spaces.
Database address and port
The public address where the MySQL database is deployed. Log on to the Amazon RDS console and obtain the public address in the instance details. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com.
Database
The name of the database to be connected.
Username and password
The username and password that are used to access the MySQL database.
Ensure that the user who logs on to the MySQL database has create, insert, update, and delete permissions on the tables in the database.
Database version
The version of the MySQL database that is deployed.
If the database type is MySQL 5.7 or earlier, select 5.7. If the database type is MySQL 8.0, select 8.0.
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 that is executed after each data source connection is initialized. Only SET statements are allowed, and statements are separated by periods.
Enable upload file entry
After starting, support uploading files.
Click connection test to verify the data source connectivity.
Once the test is successful, click OK to finalize the data source addition.
What to Do next
After the data source is created, proceed to create datasets and analyze data.
For adding MySQL data tables or custom SQL statements to Quick BI, refer to Create and Manage Datasets.
For creating visualization charts and analyzing data, refer to Create a Dashboard and Overview of Visualization Charts.
For drilling and in-depth data analysis, refer to Drilling Settings and Display.
