Data Connection to MaxCompute

Version

Introduction

MaxCompute, formerly referred to as Open Data Processing Service (ODPS), is a fast and fully hosted GB/TB/PB-level data warehousing solution provided by Alibaba's general computing platform. 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 Alibaba Cloud MaxCompute database.

Version/Driver

Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management.

Note:

You need to upload the Log JAR.zip together with the driver package.

URL Explanation:

• <maxcompute_endpoint>: the endpoint of the region where the MaxCompute service is located For      example, the endpoint of the extranet in East China 1 (Hangzhou) is http://service.cn-hangzhou.maxcompute.aliyun.com/api.

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

For details, see Usage Notes.

Connection Information Collection

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

• <maxcompute_endpoint> (the endpoint of the region where the MaxCompute service is located)

• <maxcompute_project_name> (the space name of the MaxCompute project)

• Username and password of the database

• Schema of the database to be connected

Connection Procedure

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New 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 Data Connection Management. For details, see Data Connection Permissions Overview.

2. Find the Alibaba Cloud MaxCompute icon, as shown in the following figure.

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

Click Click to Connect Database. If the connection is successful, select the schema, as shown in the following figure.

Note:

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

4. After successful connection, 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 by using DataWorks.

MaxCompute Query Acceleration

The MCQA feature of MaxCompute:

• Accelerates the execution of small- and medium-sized query jobs and reduces the time that is 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.

For details, see MaxCompute Query Acceleration.

How to enable MCQA in FineBI?

Suffix the URL in section "Version/Driver" 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.

How to extract data from a table with partitions in FineBI?

In MaxCompute, you cannot directly extract data from a table with partitions 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, and enter the statement: select * from test where fenqu = A for data extraction.