(Almost) Universal Java API

Not related to a specific OLAP tool. (Includes forum policies and rules).
Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 5874
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia

(Almost) Universal Java API

Post by Alan Kirk » Wed Apr 13, 2011 5:48 am

This interesting little titbit came through the news feed today:
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.
Of course how well a kinda-sorta universal API would be able to leverage the strengths of each platform (or in some cases, work at all) is another matter.
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.
Hmm, who's missing there?

Of course, attempting to bring TM1 into that fold would be an interesting exercise. Even moreso if they were to try to implement anything that's MDX-driven given our distinctly "regional" flavour of it.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
jim wood
Site Admin
Posts: 3656
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA

Re: (Almost) Universal Java API

Post by jim wood » Wed Apr 13, 2011 2:27 pm

Is this an open source project?? The reson I ask is that Jedox are there and they mention Oracle. I'm not sure what big blues position on open source is???
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply