Quick BI:Add a RDS for MySQL Data Source

Limits

Supports versions 5.5, 5.6, 5.7, and 8.0.

Procedure

1. Add a whitelist.

   Before connecting to Alibaba Cloud MySQL, add the IP address of Quick BI to the whitelist of Alibaba Cloud MySQL. For more information on adding to an Alibaba Cloud MySQL whitelist, see Set IP whitelist.

2. Verify the data source connection and create a data source.

   1. Log on to the Quick BI console.

   2. Follow the instructions in the figure below to add a data source.

      1. Access the data source creation interface through the data source creation entry.

      2. On the Alibaba Cloud Database tab, select RDS MySQL as the data source.

3. In the Configure Connection dialog box, complete the configurations as required by your business scenario.

   Name	Description
   Database Source	The MySQL database source supports Alibaba Cloud, Tencent Cloud, Huawei Cloud, Microsoft Cloud, AWS, and self-built. In this example, select Alibaba Cloud.
   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 and Port	The external address and external port of the deployed MySQL database. (If using a VPC data source, fill in the internal address and internal port of the deployed database). Please log on to the RDS Management Console, click View Connection Details in the Basic Information section to obtain the database address. For example: rm-xxxxxxxxxxxxxxxxxx.mysql.rds.aliyuncs.com.
   Database	The name of the database that is customized when you deploy the MySQL database. Log on to the RDS Management Console, and obtain the Database Name in Database Management.
   Username and Password	The username and password that are used to access the MySQL database. Note 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. Log on to the RDS Management Console, and obtain the version number in Database Type in the Instance List. If the database type is MySQL 5.7 or below, select 5.7. If the database type is MySQL 8.0, select 8.0.
   VPC Data Source	When using Alibaba Cloud VPC network, select VPC Data Source and configure the following parameters: Purchaser AccessId and Purchaser AccessKey: AccessKey ID and AccessKey Secret with management permissions for the target database. Ensure that the account has Read permission on the destination instance. Additionally, if you have Write permission, the system will automatically add the whitelist. Otherwise, you need to add it manually. For more information, see Create a custom policy. Log on to the RAM Management Console to obtain the AccessKey ID and AccessKey Secret. See View AccessKey information of a RAM user. Instance ID and Area: The instance ID and area of the database. Log on to the RDS Management Console, and obtain the instance ID in the basic information area. Note If you select VPC data source, you need to fill in the internal address and internal port for the database address and port.
   Initialize SQL	After enabling, you can configure the SQL statement that is executed after the data source connection is initialized. Only SET statements are allowed for the SQL statement that is executed after each data source connection is initialized. Separate statements with a semicolon.
   Enable File Upload Entry	After enabling, file upload is supported.

4. Click Connection Test to verify the connectivity of the data source.

   

5. Once the test is successful, click OK to finalize the addition of the data source.