IDG News Service >

Java developers get OLAP API

o Paul Krill
12.04.2011 kl 11:08 | InfoWorld (US)

The olap4j API can access multiple servers, including Mondrian OLAP, Pentaho BI Server, and Microsoft SQL Server Analysis Services


Pentaho is releasing on Tuesday olap4j 1.0, which provides an open source API for Java developers to access multiple OLAP (Online Analytical Processing) servers in business intelligence applications.

With the API, developers gain a single API for accessing the Mondrian OLAP server and Pentaho BI Server. Other servers supported include Microsoft SQL Server Analysis Services 2005 and 2008, SAP BW, and Jedox Palo. Oracle's Essbase server may be supported at some point as well.

[ The Eclipse Foundation for open source tooling is rekindling its Java ties this year. | Keep up with the latest developer news with InfoWorld's Developer World newsletter. | Follow Paul Krill on Twitter. ]

Pentaho likens olap4j to the  JDBC (Java Database Connectivity) API, except it is for business intelligence. "The API is designed to be as much like JDBC as possible," said Julian Hyde, chief architect at Pentaho and founder of Mondrian and olap4j. Java developers experienced with database programming will find the API familiar, according to Pentaho.

In development since 2006, olap4j 1.0 enables developers to use a standard API instead of having to use each OLAP vendor's API. Without this API, a developer building a sales analysis visualization component, for example, would have to individually choose an OLAP server to access at the back end. Olap4j works with Mondrian and XMLA (XML for Analysis) drivers, which communicate with analytic databases. Other participants in developing olap4j 1.0 include SQL Power Group, Jedox, Matrix CPM Solutions, Saiku, and Aschauer.

A user of olap4j found that it worked as a way to connect to different data sources. "Olap4j looked like the best way we could find to provide access to the largest number of multidimensional data sources," said Jonathan Fuerth. He said he had used the technology when working at business intelligence and data migration software company SQL Power. The API, however, proved "a bit awkward" in its extension of JDBC, Fuerth said. Olap4j extended JDBC to multidimensional databases, he said.

This article, "Java developers get OLAP API," was originally published at Follow the latest developments in business technology news and get a digest of the key stories each day in the InfoWorld Daily newsletter. For the latest developments in business technology news, follow on Twitter.

Read more about application development in InfoWorld's Application Development Channel.

Keywords: Software  
Latest news from IDG News Service

Copyright 2009 IDG Magazines Norge AS. All rights reserved

Postboks 9090 Grønland - 0133 OSLO / Telefon 22053000

Ansvarlig redaktør Henning Meese / Utviklingsansvarlig Ulf Helland / Salgsdirektør Tore Harald Pettersen