Data Connection to Alibaba Cloud MaxCompute

Version

Function Description

MaxCompute, previously referred to as ODPS, is a fast and fully hosted data warehousing solution at the GB, TB, and PB levels. It provides you with complete data import schemes and various classic distributed computing models. MaxCompute supports fast computing on a large amount of data, effectively reduces costs for enterprises, and ensures data security.

This document introduces how to connect to the MaxCompute database.

Version/Driver

Download the driver package and upload it to FineBI. For details, see the "Creating a Data Connection" section in Driver Management.

Note:

The log JAR file needs to be uploaded together with the driver package.

If you want the system to load the MaxCompute driver uploaded via the current method preferentially, the log4j-1.2.17.jar file is not required. If you want the system to load the driver uploaded via the current method only, you must include the log4j-1.2.17.jar file, as shown in the following figure.

URL description:

• <maxcompute_endpoint>: endpoint of the area where MaxCompute is located

For example, the Endpoint of East China 1 (Hangzhou) is http://service.cn-hangzhou.maxcompute.aliyun.com/api.

• <maxcompute_project_name>: project name of the MaxCompute project

For details, see Usage Notes.

Connection Information Collection

Before connecting FineBI to the database, you need to collect the following information:

• <maxcompute_endpoint>: endpoint of the area where MaxCompute is located

• <maxcompute_project_name>: project space name of the MaxCompute project

• Username  and password of the database

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, click Create, and select Data Connection, as shown in the following figure.

Note:

If you are not the admin, you can configure data connections only after the admin assigns you the permission on the data connection module. For details, see Data Connection Permission Overview.

2. Select the MaxCompute database, as shown in the following figure.

3. Select Custom from the Driver drop-down list, select the driver uploaded in the "Version/Driver" section, and enter the connection information collected in the "Connection Information Collection" section.

Click Click to Connect Database, and select the required schema after successful connection.

Note:

You can modify other advanced settings as needed. For details, see the "Advanced Settings" section in Entry-Level Data Connection Configuration.

4. Finally, click Save to save the data connection.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

Official Documentation

Official documentation of MaxCompute: MaxCompute

Official documentation of DataWorks: DataWorks

You can conduct visual management of MaxCompute using DataWorks.

MaxCompute Query Acceleration

The MaxCompute Query Acceleration (MCQA) feature of MaxCompute:

• Accelerates the execution of small- and medium-sized query jobs and reduces the time required to complete such a query job from minutes to seconds. The MCQA feature is compatible with other query features of MaxCompute.

• Supports mainstream business intelligence (BI) tools to perform ad hoc queries or BI analysis.

• Uses an independent resource pool that does not occupy quota resources. MCQA can automatically identify query jobs to reduce the load of the job queue and improve user experience.

How to enable MCQA in FineBI?

Suffix the URL in the "Version/Driver" section with &interactiveMode=true.

Note:

To use the acceleration parameter, you need to add the parameter autoSelectLimit=1,000,000,000 when the data volume exceeds the limit of one million.

For details, see MaxCompute Query Acceleration.

Method to Extract Data from a Partitioned Table

You cannot directly extract data from partitioned tables in the MaxCompute database by adding a database table in FineBI. Instead, you need to add a SQL dataset.

For example, in MaxCompute, a table named test exists with two partitions A and B. Add a SQL dataset with the query statement: select * from test where fenqu = A.