AWS data source: RDS for MySQL

Limitations

Supported MySQL versions: 5.5, 5.6, 5.7, and 8.0.

Procedure

1. Add IP addresses to the allowlist.

   Before you connect to AWS MySQL, add the IP addresses of Quick BI to the AWS MySQL allowlist. For instructions, see Controlling access with security groups.

2. Verify the connection and create the data source.

   1. Log on to the Quick BI console.

   2. Add a data source:

      1. Go to the data source creation page, as described in Create a data source.

      2. On the AWS Databases tab, select the MySQL data source.

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

   Parameter	Description
   Data source type	The MySQL data source type supports Alibaba Cloud, Tencent Cloud, Huawei Cloud, Microsoft Azure, AWS, and self-hosted databases. In this example, select AWS.
   Display name	The display name shown in the data source list. Do not use special characters or leading or trailing spaces.
   Database address and port	The public endpoint and port of your MySQL database. You can find this information in the Amazon RDS console on the database instance details page. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com. For more information, see Connecting to a DB instance running the MySQL database engine.
   Database	The name of the database to connect to.
   Username and password	The username and password of your MySQL database account. Note Ensure that the database user has CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
   Database version	The version of your MySQL database. Select 5.7 for MySQL 5.7 and earlier. Select 8.0 for MySQL 8.0.
   SSL	Select this option to encrypt the connection with SSL.
   Initialize SQL	When enabled, you can specify SQL statements that run each time a new connection is established. Only SET statements are allowed. Separate multiple statements with a semicolon (;).
   Enable file upload	When enabled, you can upload files to this data source.

4. Click Test Connection to verify the connection.

   

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