You can connect Yonghong BI to MaxCompute projects. This helps you analyze and visualize data. This topic describes how to connect Yonghong BI to MaxCompute projects and use Yonghong BI to analyze and visualize data.
Background information
Yonghong Desktop is a desktop BI tool that is used to analyze data. After you install Yonghong Desktop on your machine, you can directly use this tool without additional deployment. Yonghong Desktop provides end-to-end, agile, and efficient data governance, visualized data analysis, and AI-powered in-depth data analysis. Yonghong Desktop can help you analyze and visualize data. For more information about Yonghong BI, see Yonghong.
Prerequisites
- A MaxCompute project is created.
For more information, see Create a MaxCompute project.
- The AccessKey pair of your Alibaba Cloud account that is used to access the MaxCompute
project is obtained.
You can click the profile picture in the upper-right corner of the MaxCompute console and select AccessKey Management to obtain the AccessKey pair.
- Yonghong Desktop V9.2.2 that has a built-in MaxComnpute connector is installed.
For more information about how to install and start Yonghong Desktop, see Install Yonghong Desktop.
Yonghong Desktop V9.2.2 that has a built-in MaxCompute Java Database Connectivity (JDBC) driver is used in this topic.
- If the built-in MaxCompute JDBC driver of Yonghong Desktop cannot connect to the MaxCompute
project, download the package of MaxCompute JDBC driver V3.2.8 or later that includes the
jar-with-dependencies
package.MaxCompute JDBC driver V3.2.9 is used in this topic.
Step 1: Connect Yonghong BI to the MaxCompute project
Step 2: Use Yonghong BI to query and analyze data
- Query all existing tables
After the data connection is saved, Yonghong Desktop automatically loads information of all existing tables in the MaxCompute project.
- Query table schema
In the left-side navigation pane of Yonghong Desktop, click Create Data Set and select MaxCompute from the Connection drop-down list. Then, you can use custom SQL scripts to query the schema of a table on the Metadata tab and save the queried dataset.
- Query table data
In the left-side navigation pane of Yonghong Desktop, click Create Data Set and select MaxCompute from the Connection drop-down list. Then, you can use custom SQL scripts to query the data of a table on the Data Details tab and save the queried dataset.
- Visualize analysis data
In the left-side navigation pane of Yonghong Desktop, click Create Dashboard. After a report is generated, select a chart type and configure parameters to visualize data based on your business requirements.
Add a custom driver
Yonghong Desktop has a built-in MaxCompute JDBC driver. If this driver cannot connect to the MaxCompute project, you can add a custom driver by performing the following steps: