You can add an Aurora MySQL data source to connect Aurora MySQL databases to Quick BI. After the connection is established, you can analyze and visualize data in Quick BI. This topic describes how to add an Aurora MySQL data source.
Limits
Aurora MySQL 2.11.5 and 3.05.2 are supported.
Procedure
Add IP addresses to the whitelist.
Before you connect to Aurora MySQL, you must add Quick BI IP addresses to the whitelist of Aurora MySQL.
Go to the Create Data Source page from the entry for creating a data source.
On the AWS Database tab, select Aurora MySQL as the data source type.
In the Configure Connection dialog box, configure the parameters 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
The public endpoint of the Aurora MySQL database cluster.
Log on to the Amazon RDS console, click the database in the database list to go to the details page, and obtain the endpoint name from the "Connectivity & security" tab. This is the database address, for example: xxxxxxxx.rds.amazonaws.com.
For more information, see Creating an Aurora MySQL DB cluster and connecting to it.
Port
The port number of the database. The default port number is 3306.
Database
The name of the database to be connected.
Username and Password
The username and password used to log on to the Aurora MySQL database.
NoteMake sure that the user who logs on to the Aurora MySQL database has the create, insert, update, and delete permissions on tables in the database.
Database Version
The version of the Aurora MySQL database:
If your database version is Aurora MySQL 2.x, select Aurora MySQL 2.
If your database version is Aurora MySQL 3.x, select Aurora MySQL 3.
SSL
If the target data source has SSL configured, you can select the SSL security protocol to protect data security.
Init SQL
After this feature is enabled, you can configure SQL statements that are executed for initialization after the data source is connected.
The SQL statements that are executed for initialization each time the data source is connected. Only SET statements are allowed, and statements must be separated by semicolons.
Click Test Connection to test the connectivity of the data source.
After the test is successful, click OK to add the data source.
What to do next
After you add a data source, you can create a dataset and analyze data.
To add data tables from the SQL Server data source or custom SQL statements to Quick BI, see Create a dataset.
To add visualization charts and analyze data, see Create a dashboard and Overview of visualization charts.
To drill down and analyze data in depth, see Drill-down settings and display.