Palo supports the connection to Yonghong BI, you can connect your Yonghong BI according to the following steps.

Preparations

Install and log in Yonghong BI.

Bind EIP for Leader Node of Palo cluster.

Connect Palo

1. Start Yonghong BI, click New button on the top left and select MySQL at Connect data source.

   

2. Then fill in the data source configuration as the following ways:

   • Driver: select Default driver: com.mysql.jdbc.Driver
   • URL: jdbc:mysql://Databaseserver:port/DatabaseName. Fill in Leader Node binding EIP of Palo cluster at Databaseserver; Fill in the port number of the MySQL protocol connection target of Palo cluster at port, generally defaulted as 9030, as shown in the figure below; DatabaseName is unnecessary to fill in.

   

   • Server login: Select User name and password
   • User name: The account created in Palo cluster, the administrator account is admin.
   • Password: The connection password when creating the cluster.
   • Other items are unnecessary to fill in.

3. Click Connection test, the following display indicates that the connection is succeeded.

   

   Then click Save

   

   Fill in the data source name (defined by the user) at File name, then click OK to save the data source.

   

   Next, you can see the data source you just added in the directory tree on the left.

   

   Thus, we have connected Palo data source to Yonghong BI to perform free exploration and data analysis.