We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
80,259 News Articles

Java developers get OLAP API

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 InfoWorld.com. 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 InfoWorld.com on Twitter.

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

IDG UK Sites

LG G4 Note UK release date and specification rumours: Samsung Galaxy Note 5 killer could be the LG 3......

IDG UK Sites

In defence of BlackBerrys

IDG UK Sites

Why we should reserve judgement on Apple ditching Helvetica in OS X/iOS for the Apple Watch's San...

IDG UK Sites

Retina 3.3GHz iMac 27in preview: Apple cuts £400 of price of Retina iMac with new model