You can use FineBI to connect to AnalyticDB for MySQL and manage data in a visualized manner with operations such as filtering, grouping, adding columns, setting fields, and sorting. This can facilitate and accelerate data integration.

Prerequisites

  • For more information about the compatibility of FineBI with AnalyticDB for MySQL, see Compatibility overview.
  • MySQL Connector/J is installed.
  • FineBI 5.0 or later is installed.
  • A MySQL server such as ApsaraDB RDS for MySQL is installed to import FineBI metadata if you have not installed FineBI before.
  • A public endpoint is applied for if you need to use a public endpoint to connect to AnalyticDB for MySQL clusters. For more information, see Apply for or release a public endpoint.

Step 1. Log on to the MySQL server

  1. Start FineBI.
  2. Click the server address and follow the instructions to configure Account Settings.
    Note If you have already installed and used FineBI, start with step 2.
  3. Click Next Step to select the database. Click Configure Database in the External Database section.
  4. On the External Database Configuration page, follow the instructions on the page to configure the parameters.
    Note You must specify the parameters for connecting to the MySQL database instead of the AnalyticDB for MySQL database.
    Parameter Description
    Database Type The engine of the database. Select MySQL from the drop-down list.
    Driver The type of the driver. Select com.mysql.jdbc.Driver from the drop-down list.
    Database Name The name of the database into which FineBI metadata is imported. You can also create a new database. After you have connected FineBI to the MySQL server, the CREATE DATABASE finedb; statement is automatically executed to create the finedb database.
    Host The address of the MySQL server, which can be the address of a local or remote server.
    Port Number The port number of the MySQL server address. The default port number is 3306.
    Username The account created in the MySQL server.
    Password The password of the account.
    URL The URL generated by the system.
  5. After you configure the preceding parameters, click Enable New Database to import FineBI metadata.
  6. After you import the FineBI metadata, click Logon to log on to the MySQL server.

Step 2. Connect to AnalyticDB for MySQL

  1. In the left-side navigation pane, choose Management System > Database Endpoint > Create New Database Endpoint > MySQL.
  2. In the database connection dialog box that appears, set parameters for connecting to the AnalyticDB for MySQL database.
    Parameter Description
    Endpoint Name The name of the database endpoint. We recommend that you choose an identifiable name to facilitate subsequent management.
    Driver The type of the driver. Select com.mysql.jdbc.Driver from the drop-down list.
    URL The connection string of the AnalyticDB for MySQL cluster to which you want to connect. The format is jdbc:mysql://hostname:port/dbname.
    • hostname: the public or VPC endpoint of the cluster. You can view the endpoint on the Cluster Information page of the AnalyticDB for MySQL console.
    • port: the port number of the AnalyticDB for MySQL cluster endpoint. The default port number is 3306.
    • dbname: the name of the database in the AnalyticDB for MySQL cluster.
    Username The account used to connect to the AnalyticDB for MySQL cluster. You can use one of the following account types:
    • Privileged account
    • Standard account
    Password The password of the account used to connect to the AnalyticDB for MySQL cluster.
    SQL Validation Query An SQL statement that can be used to test database connectivity.
  3. After you configure the preceding parameters, click Test to test the connectivity. After the connection passes the test, click Save in the upper-right corner.
    FineBI is connected to the AnalyticDB for MySQL database.

Use FineBI

After FineBI is connected to the AnalyticDB for MySQL database, you can obtain data from the AnalyticDB for MySQL database and use FineBI to generate reports. For more information about how to use FineBI, visit FineBI.