Quick BI:Add an RDS for MySQL Data Source

Limitations

Supports MySQL versions 5.5, 5.6, 5.7, and 8.0.

Procedure

1. Add IP addresses to the whitelist.

   Before you connect to the RDS for MySQL instance, add the IP addresses of Quick BI to its whitelist. For more information about how to configure the whitelist, see Configure an IP address whitelist.

2. Test the data source connection and create the data source.

   1. Log on to the Quick BI console.

   2. Add a data source by following these steps:

      1. Go to the page for creating data sources. For more information, see Create a data source.

      2. On the Alibaba Cloud Databases tab, select RDS for MySQL.

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

   Parameter	Description
   Data source	The MySQL database source. Supported sources include Alibaba Cloud, Tencent Cloud, Huawei Cloud, Microsoft Azure, AWS, and self-managed databases. In this example, select Alibaba Cloud.
   Display name	The display name for the data source in the data source list. The name cannot contain special characters or have leading or trailing spaces.
   Database address and port	The public address and port of the database. For a VPC data source, use the internal address and port. Log on to the RDS console. On the Basic Information page, click View Connection Details to obtain the database address. Example: rm-xxxxxxxxxxxxxxxxxx.mysql.rds.aliyuncs.com.
   Database	The name of the database you specified when creating the MySQL database. Log on to the RDS console. On the Database Management page, obtain the Database Name.
   Username and password	The username and password for the MySQL database. Note Ensure that the user has the create, insert, update, and delete permissions on the tables in the database.
   Database version	The MySQL version of your database. Log on to the RDS console. On the Instance List page, find the version number in the Database Type column. If the database version is MySQL 5.7 or earlier, select 5.7. If the database version is MySQL 8.0, select 8.0.
   VPC data source	If you use an Alibaba Cloud VPC, select VPC data source and configure the following parameters: AccessKey ID and AccessKey Secret: The AccessKey ID and AccessKey Secret of an account with management permissions on the target database instance. Ensure that the account has the Read permission on the target instance. If the account has the Write permission, Quick BI automatically adds its IP addresses to the whitelist; otherwise, you must add them manually. For more information, see Create a custom policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. For more information, see View the AccessKey information of a RAM user. Instance ID and region: The ID of the database instance and the region where it is located. Log on to the RDS console to obtain the instance ID from the Basic Information page. Note When using a VPC data source, you must enter the database's internal address and port.
   SSL	If SSL is configured for the data source, select SSL to encrypt data in transit.
   Initialize SQL	When enabled, you can specify SQL statements to run when the connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.
   Enable file upload entry	When enabled, users can upload files to this data source.

4. Click Test Connection to verify the connection.

   

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