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
- Start FineBI.
- 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.
- Click Next Step to select the database. Click Configure Database in the External Database section.
- 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. |
- After you configure the preceding parameters, click Enable New Database to import FineBI metadata.
- After you import the FineBI metadata, click Logon to log on to the MySQL server.
Step 2. Connect to AnalyticDB for MySQL
- In the left-side navigation pane, choose .
- 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. |
- 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.