AWS data source: Aurora MySQL

Limitations

Quick BI supports Aurora MySQL versions 2.11.5 and 3.05.2.

Procedure

1. Add IP addresses to the allow list.

   Before you connect to Aurora MySQL, you must add the Quick BI IP addresses to the Aurora MySQL allow list.

2. Go to the Create a data source page.

3. On the AWS Databases tab, select the Aurora MySQL data source.

4. In the Configure Connection dialog box, set the following parameters.

   Parameter	Description
   Display name	The display name of the data source in the data source list. The name cannot contain special characters or leading or trailing spaces.
   Database address	The public endpoint of your Aurora MySQL database cluster. To find this address, log in to the Amazon RDS console, click your target database, and locate the endpoint on the Connectivity & security tab. For example: xxxxxxxx.rds.amazonaws.com. For more information, see Create and connect to an Aurora MySQL DB cluster.
   Port	The database port number. Default: 3306.
   Database	The name of the database to connect to.
   Username and password	The credentials used to log in to the Aurora MySQL database. Note Ensure that the database user has create, insert, update, and delete permissions on the tables in the database.
   Database version	Select the version that matches your 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	Enable this option if your data source requires an SSL connection.
   Initialization SQL	Specify SQL statements to run immediately after a connection is established. Only SET statements are allowed. Separate multiple statements with a semicolon (;).

   1. Click Connection test to verify the data source connectivity.

5. After the connection test succeeds, click OK to add the data source.