AnalyticDB:FineBI 6.0

Test environment

Download FineBI 6.0.

Test scope

• On the database selection page, select External Database and click Configure Database >. On the configuration page, set Database Type to mysql, Driver to com.mysql.jdbc.Driver, Database Name to adb_demo, Username to account1, Host to your database host address, Password to your password, and Port to 3306. FineBI automatically generates the Database Connection URL in the format jdbc:mysql://host_address:3306/adb_demo?useUnicode=true. After you enter the settings, click Enable New Database.
  Note You must enter the connection information for a MySQL database, not an AnalyticDB for MySQL database.
  After the database connects, the import process begins, which includes the Connect Database and Import Data steps. The status shows Connection successful, importing data.... Wait for the import to complete.
• In the left-side navigation pane, navigate to Management System > Data Connection, click New Data Connection, and select MySQL from the drop-down list. On the Data Connection (MySQL) configuration page, set Data Connection Name to AnalyticDB for MySQL, select the appropriate Driver, enter the URL (including the database host address), Username, and Password. Configure Connection Pool Attributes as needed.
• In the Select Table dialog box, select a data connection type from the left panel, such as MySQL, ADB, or Server Dataset. The corresponding databases (for example, binary_test, course, dimension_test_date, and school) appear as tabs on the right. Select the checkboxes for the required databases and click OK.
• The school table contains four fields: id (numeric), name (text), create_time (date), and update_time (date). All fields are selected by default.
• In the Data Query Configuration dialog box, select ADB from the Data from data connection drop-down list. In the SQL Statement editor, enter select * from school limit 10 and click OK. The query results, including the id, name, create_time, and update_time fields, appear on the right. In the Parameter Settings section below, you can configure dynamic parameters using the ${parameter_name} syntax.