This chapter shows how to configure Quick BI to render data from ApsaraDB for RDS. The following information uses a MySQL database as an example.

Assume that you already have an existing MySQL database running and data to render.

The configuration includes the following three parts.

  • Configure Quick BI
  • Create a dashboard
  • Publish a dashboard

Prerequisites

Configure Quick BI

Copy IP ranges from the Quick BI
  1. Log on to the Quick BI console.
  2. Select Workbench > Data sources, to enter the data source management page
  3. Select Create > From Cloud Database > MySQL, to create a new data source from the Cloud database.
  4. Copy IP ranges, which are displayed in the blue area. See the following figure.


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

    The Internet Address is the database endpoint.

Set whitelist on RDS
  1. Select Security in the left-side navigation pane to visit the Security 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 a Whitelist Group to add a new whitelist group.
  5. Enter a new group name and paste IP ranges in the whitelist area.
  6. Click OK to complete the whitelist settings.

    For more information, see Set whitelist .

Verify the data source connection
  1. Go back to the Quick BI data sources management page.
  2. Select Create > From Cloud Database > MySQL.
  3. Enter the required information for connecting to a data source, as shown in the following figure.


    • Name: The name of the data source.
    • Database Endpoint: Enter the host name or Internet address.
    • Port: Enter the correct port number.
    • Database: The name of the database to be connected to.
    • User Name: The user name of the database.
    • Password: The password of the database.
  4. Click Test Connection to perform the data source connectivity test.

    If the connection goes well, a successful information is displayed.

  5. Click Add.  The data source is added.

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

Create a dashboard

  1. Select a data table in the data source management page.
  2. Click Create Dataset next to the data table.
  3. Click Dashboards to enter the dashboard management page.
  4. Select Create > Dashboard to enter the dashboard editing page.
  5. Select or search for the dataset that you want to analyze, as shown in following figure.


    For more information about dashboard basic operations, see Dashboard basic operations.

  6. Double-click a chart icon, for example, the line chart.   The line chart sample is displayed.
  7. Select required dimension fields and measurement fields. 


  8. Click Update to complete the line chart creation.
  9. Click Save to save current dashboard.

Make public a dashboard

  1. Select a dashboard in the dashboard management page.
  2. Click Make Public icon next to the selected dashboard. 


  3. Select an expiration date, and select Regenerate URL.
  4. Copy the generated URL to your browser to view the dashboard contents.

Further reading

You can get further detailed information from the following addresses.