CODEWITHSUNDEEP
javaolapolap4j
Horcrux7
Horcrux7

Reputation: 24447

Are there any JOLAP or Olap4j driver available?

Are there any driver available for JOLAP or Olap4j to access existing OLAP services? I think on OLAP services like Oracle, MS SQL, etc.

We want start a OLAP project with Java? With which of the both API should we start?

Upvotes: 1

Views: 1402

Answers (2)

Ihor Kaharlichenko
Ihor Kaharlichenko

Reputation: 6260

There's an xmla client library by icCube: http://www.iccube.com/products/contributions/xmla-client-library, though I haven't tried it myself.

Upvotes: 1

Julian Hyde
Julian Hyde

Reputation: 1354

olap4j is the perfect Java API for this type of project. It is designed to do for OLAP what JDBC does for relational databases. It allows you to write an application against a server-neutral API, and then run that application against various servers without code changes. Also, the API is easy to learn because it uses the same concepts as JDBC.

Using the XMLA olap4j driver (included with the olap4j distro) you can connect to any OLAP database which has an XMLA driver -- and most of them do. It has been tested against Microsoft SQL Server Analysis Services, SAP BW, and Mondrian, and others. It should work against Oracle's XMLA provider [ http://www.oracle.com/us/corporate/press/173668 ] but I have not tried it.

See www.olap4j.org for more information.

Julian Hyde (olap4j project founder)

Upvotes: 3

Related Questions