Quick BI:Azure Database for MySQL data source

Prerequisites

You have created an Azure Database for MySQL instance.

Limitations

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

Procedure

1. Add IP addresses to an allowlist.

   Before you connect to the database, you must add the IP addresses of Quick BI to the allowlist of your Azure Database for MySQL instance. For instructions, see Manage firewall rules for Azure Database for MySQL - Flexible Server using the Azure portal.

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

   1. Log on to the Quick BI console.

   2. Follow the steps in the figures to add a data source.

      1. From the Create Data Source entry point, go to the Create Data Source page.

      2. On the Azure Databases tab, select Azure Database for MySQL.

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

      Parameter	Description
      Data source type	MySQL data sources can be deployed on Alibaba Cloud, Tencent Cloud, HUAWEI CLOUD, Azure, and AWS, or be self-managed. In this example, select Azure.
      Display name	The display name shown in the data source list. Use standard naming conventions. Do not use special characters or leading or trailing spaces.
      Database address and port	The public endpoint of your MySQL database, available from the Azure portal.
      Database	The name of the database to connect to.
      Username and password	The credentials for accessing the MySQL database. Note The database user must have CREATE, INSERT, UPDATE, and DELETE permissions on the target tables.
      Database version	The MySQL version of your database. Select 5.7 for MySQL 5.7 or earlier, or 8.0 for MySQL 8.0.
      SSL	Enable this option to encrypt data in transit if your data source uses SSL.
      Initial SQL	SQL statements to run immediately after connecting to the data source. Only SET statements are allowed. Use semicolons (;) to separate multiple statements.
      Enable file upload	Allows file uploads to this data source.

   4. Click Test Connection to verify the connection.

      

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