Quick BI:Microsoft cloud data source MySQL

Prerequisites

You must have a Microsoft Cloud MySQL database already created.

Limits

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

Procedure

1. Add the whitelist.

   Before connecting to the Microsoft Cloud MySQL, add Quick BI's IP address to the whitelist of your Microsoft Cloud MySQL instance.

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

   1. Log on to the or the international Quick BI console.

   2. You can add a data source by following the instructions in the figure below.

      1. Navigate to the data source creation page using the provided link.

      2. Choose MySQL as the data source.

         

      3. Select Microsoft Cloud for the data source type.

         

   3. Within the Configure Connection dialog box, you can perform the following configurations tailored to your business scenario.

      Name	Description
      Data source type	The MySQL data source type supports Alibaba Cloud, Tencent Cloud, Huawei Cloud, Microsoft Cloud, AWS, and self-built. In this example, select Microsoft Cloud.
      Display name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
      Database address and port	The public address where the MySQL database is deployed. Log on to the Azure portal and obtain the public address.
      Database	The name of the database to be connected.
      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 the create, insert, update, and delete permissions on the tables in the database.
      Database version	The version of the MySQL database to be deployed. If the database type is MySQL 5.7 or earlier, select 5.7. If the database type is MySQL 8.0, select 8.0.
      SSL	If the target data source is configured with SSL, you can select the secure protocol SSL to protect data security.
      Initialize SQL	The SQL statement that is executed to initialize each time the data source is connected. Only the SET statement is allowed, and statements are separated by periods.
      Enable file upload entry	After it is enabled, file upload is supported.

   4. To test the data source connectivity, click connection test.

      

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