This topic uses MySQL database as an example to describe how to connect Quick BI to RDS MySQL.

Assume that you already have a MySQL database running properly and the data in this database can be used.

Prerequisites

Configure Quick BI

Copy the IP address from Quick BI
  1. Log on to the Quick BI console.
  2. Click Workspace > Data Sources to go to the data source management page.
  3. Click Create Data Source > Cloud Database > MySQL to create a MySQL data source.
  4. Copy the IP address displayed in the blue area, as shown in the following figure.


Obtain the endpoint of the MySQL database from RDS
  1. Log on to the RDS console.
  2. Select the region where the target instance is located.
  3. Click the name of the instance to go to the Basic Information page.

    The IP address is the database endpoint.

Set the IP address whitelists on RDS
  1. In the left-side navigation pane, click Data Security to go to the data security management page.
  2. On the Whitelist Settings tab page, click Modify, as shown in the following figure.

  3. Click Clear to delete the IP address 127.0.0.1.
  4. Click Add Whitelist Group to add a new whitelist group.
  5. Enter a new group name and paste the IP address in the whitelist area.
  6. Click OK to complete the whitelist settings.

    For more information, see Set whitelists.

Verify the data source connection
  1. Go back to the Quick BI data source management page.
  2. Click Create Data Source > Cloud Database > MySQL.
  3. Enter the data source connection information as shown in the following figure.


    • Name: The display name of the data source.
    • Database Endpoint: The IP address of the database.
    • Port: The port number.
    • Database: The database name.
    • User Name: The name of the database user.
    • Password: The database password.
  4. Click Test Connection to verify that the data source connection is functioning properly.

    If the connection functions properly, a prompt message is displayed.

  5. Click Add. The data source is added.

    For more information, see Create a cloud data source, Create a data source from external database, and Upload local files.

More information

You can obtain more detailed information about Quick BI and RDS from the following links.