This topic describes how to use FineReport to connect to an AnalyticDB for MySQL cluster and manage reports.

Prerequisites

  • MySQL Connector/J is installed.
  • FineReport is installed.

Use FineReport to connect to an AnalyticDB for MySQL cluster

  1. Start FineReport and choose Server > Define Data Connection.
  2. In the Define Data Connection dialog box that appears, configure the parameters.
    Parameter Description
    Database 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.
    URL The connection string of the AnalyticDB for MySQL cluster to which you want to connect. The format is jdbc:mysql://hostname:port.
    • hostname: the public or VPC endpoint of the cluster.
    • port: the port number of the AnalyticDB for MySQL cluster endpoint. The default port number is 3306.
    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.
  3. After you configure the preceding parameters, click Test Connection to test the connectivity. After the connection passes the test, click Confirm to connect to the AnalyticDB for MySQL cluster.

Use FineReport

After you use FineReport to connect to the AnalyticDB for MySQL cluster, you can obtain data from the AnalyticDB for MySQL cluster and use FineReport to generate reports. For more information about how to use FineReport, visit FineReport.