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.