MaxCompute:Connect Yonghong BI to MaxCompute

Background information

Yonghong Desktop is a desktop BI tool that runs locally without additional deployment. It provides end-to-end, agile, and efficient data governance, visualized data analysis, and AI-powered in-depth data analysis. For more information, see Yonghong.

Prerequisites

Before you begin, ensure that you have:

Software:

• Yonghong Desktop V9.2.2 installed. For installation instructions, see Install Yonghong Desktop.

Connection information:

• A MaxCompute project. To create one, see Create a MaxCompute project.

• The AccessKey ID and AccessKey secret for the Alibaba Cloud account used to access the project. Get these from AccessKey Management.

• The endpoint for the region where your MaxCompute project resides. See Endpoints for a full list.

• The name of your MaxCompute project (not the DataWorks workspace name). Log on to the MaxCompute console, select the region in the top navigation bar, and go to Workspace > Projects to find it.

Step 1: Connect Yonghong Desktop to your MaxCompute project

1. Start Yonghong Desktop.

2. In the left-side navigation pane, click Create Connection.

3. Click , then select MaxCompute from the dialog box.

4. In the Database section, configure the connection parameters.

   Parameter	Description
   Select Connection	Select MaxCompute from the drop-down list.
   Driver	Select Default to use the built-in com.aliyun.odps.jdbc.OdpsDriver driver. If the default driver fails to connect, select Custom. See Add a custom driver.
   URL	The JDBC connection URL. Format: jdbc:odps:<MaxCompute_endpoint>?project=<MaxCompute_project_name>[&interactiveMode={true|false}]. Remove the angle brackets (<>) when entering values. To enable MaxCompute Query Acceleration (MCQA), append &interactiveMode=true.
   Server Login	Keep the default value Username and Password.
   User	Your AccessKey ID. Get it from AccessKey Management.
   Password	The AccessKey secret for your AccessKey ID. Get it from AccessKey Management.

   

5. Click Test Connection at the bottom of the Database section. After the test succeeds, save the connection.

   

Step 2: Query and analyze data

After saving the connection, use Yonghong Desktop to explore your MaxCompute data. For full usage details, see the Yonghong help documentation.

View all tables

Yonghong Desktop automatically loads all tables in the MaxCompute project after the connection is saved.

Query a table schema

In the left-side navigation pane, click Create Data Set and select MaxCompute from the Connection drop-down list. On the Metadata tab, use custom SQL to query a table's schema, then save the dataset.

Query table data

In the left-side navigation pane, click Create Data Set and select MaxCompute from the Connection drop-down list. On the Data Details tab, use custom SQL to query table data, then save the dataset.

Create a visualization

In the left-side navigation pane, click Create Dashboard. After a report is generated, select a chart type and configure parameters to visualize your data.

Add a custom driver

Yonghong Desktop V9.2.2 includes a built-in MaxCompute JDBC driver. If this driver fails to connect to your project, download the MaxCompute JDBC driver package (V3.2.8 or later) — choose the package that contains jar-with-dependencies. This topic uses V3.2.9.

1. Start Yonghong Desktop.

2. Click the icon in the upper-left corner to open the Driver Management dialog box. Enter a name for the driver, upload the JAR package (for example, odps-jdbc-3.2.9-jar-with-dependencies.jar), then click OK.