Palo supports connecting to FineBI. You can follow these instructional steps to connect to your visualization tool, FineBI.

Preparation

• Install FineBI version 5.0 and above.
• Install MySQL JDBC Driver.

Log in to the server

1. Open FineBI，click on the "Server Address" in the software to configure your account.

2. Configure your account on the server page opened.

3. After successful configuration of your account, go to the next step: Database Selection.

4.Select the database for configuration. For corporate formal usage, please refer to FineBI Help Document.Configuration of External Databasefor configuration. Here for easier demonstration, we will choose the "Internal Database" and log in directly.

5.Log in and enter FineBI.

Connect to Palo

1.Click on "System Management - Data Connection - Data Connection Management", and choose the MySQL Type.

2.On the page of Database Configuration, fill in the connection information of Palo Cluster.

Configuration Item	Filling Instruction
Name of Data Connection	Create a name for the connection for easier future management
Driver	Selectcom.mysql.jdbc.Driver
Name of Database	Name of the Database in Palo
Host	On the page of the Palo Cluster - Details - Configuration Information, bind Eip for LeaderNode and fill in this IP address
Port	9030
User Name	Account created in Palo Cluster, administrator's account admin
Password	Connection password created when creating the cluster

3.After filling Configuration information, click "Connection Test" on the top right corner to test the connection. When the system prompts success connection, click "Save" on the top right corner of the page. At this point, FineBI has been successfully connected to the Palo Database.

Use FineBI

1. After successful connection of the database, Palo data analysis in FineBI is available. Click on "Data Preparation" to add business package.

2.Enter the business package, click on "Add Table" button, select the database table and enter.

3.Already connected tables in the Palo database are visible on the page of database tables.

4.Selected the data to be analyzed, click "confirm" to start database connection.

5.After successful database connection, FineBI is ready for visual analysis of the data.

For more instructions on how to use FineBI, please refer to [FineBI Help Document]. (https://help.fanruan.com/finebi/)