This topic describes how to add an ApsaraDB RDS for MySQL data source.

Prerequisites

  • An ApsaraDB RDS for MySQL database is created.
    Note Quick BI is compatible with MySQL 5.7 or earlier and MySQL 8.0.
  • The username and password that are used to access the ApsaraDB RDS for MySQL database are obtained.
  • A whitelist is configured in the ApsaraDB RDS console to allow Quick BI to access the ApsaraDB RDS for MySQL database. For more information, see Configure a whitelist.

Procedure

  1. Log on to the Quick BI console.
  2. Perform the steps that are shown in the following figure to add an ApsaraDB RDS for MySQL data source.
    Data Sources_intl
  3. In the Add MySQL Data Source dialog box, configure the parameters.
    Parameter Description
    Name The name of the data source. The name is displayed in the data source list.

    The name can contain letters, digits, underscores (_), and hyphens (-).

    Database Address and Port Number The hostname or IP address and the port number of the ApsaraDB RDS for MySQL database that you want to access.
    Database The name of the ApsaraDB RDS for MySQL database that is customized when you deploy the database.
    Username and Password The username and password that are used to access the ApsaraDB RDS for MySQL database.
    Note Make sure that the user who logs on to the ApsaraDB RDS for MySQL database has the CREATE, INSERT, UPDATE, and DELETE permissions on tables in the database.
    Database Version The version of the database. Valid values:
    • 5.7: Quick BI is compatible with MySQL 5.7 and earlier.
    • 8.0: Quick BI is compatible with MySQL 8.0.
    VPC Data Source If you use a virtual private cloud (VPC) to connect Quick BI to the database, select VPC Data Source and configure the following parameters:
    • AccessKey ID and AccessKey Secret: the AccessKey pair that is used to manage the ApsaraDB RDS for MySQL database.
    • Instance ID and Region: the ID of the MySQL instance on which the ApsaraDB RDS for MySQL database is deployed and the region in which the instance is deployed.
  4. Click Test Connection to verify that the data source can be connected.
  5. After the data source passes the connectivity test, click OK.
    If a data source that uses the same configuration exists, a message that indicates a configuration conflict appears. You do not need to repeatedly add a data source.