Launched by Baidu smart cloud, Sugar , rich in components and out-of-the-box, is an agile BI and data visualization platform, which needs no SQL and any encoding. Palo can be compatible with the cloud visualization platform Sugar perfectly. Cooperating with Sugar, Palo can achieve high-performance visual chart analysis and powerful interactive analysis.

You can connect your visualization tool Sugar according to the following steps.

Preparations

• Open Sugar service.
• Install MySQL JDBC driver.

Create Palo data source in Sugar

1. Enter the Sugar service to create a zone on the home page, or use the created zone.

   

2. Click "Data source" on the left after entering the created zone, and click the button "Add data source" in the upper left corner of the page.

   

3. Select "Apache Doris (Baidu Palo)" from "Type" option box.

   

4. Fill in the connection information of Palo cluster on the page of "Add data source".

   

   Configuration items	Instructions for filling
   Data source name	Create a data source name for subsequent management
   Description	Self-defined descriptions are suggested to supplement the detailed management information for the data source
   Database address Host	Bind the LeaderNode with EiP on the page of Palo cluster details - Configuration information and fill in this IP address (Eip needs to be purchased and bound by the user).
   Port	9030
   Database name	Database name in Palo
   User name	The account created in Palo cluster, the administrator account is "admin".
   Password	The connection password when creating the cluster.

5. Click "Connection test" below for connectivity test after filling in the configuration information, then click "Add" button on the page when the system prompts "Connected". In this way, Sugar has been successfully connected to the Palo database.

   

Use Sugar

1. Data analysis for Palo can be achieved in Sugar after completed data source connection. The added data source can be seen in data source management list.

   

2. Then various operations for the data source, such as "Create data model", can be done by clicking to perform visual data analysis in corresponding page.

   

Refer to [Sugar help document] for more instructions on using Sugar. (https://cloud.baidu.com/doc/SUGAR/index.html).