• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 717
  • Last Modified:

Query MS Analysis Services 2005 from Java

How can i query Microsoft Analysis Services using MDX from inside a Java application?  Where can i find a library that will allow me to connect and query (preferrably for free)?
0
dave4dl
Asked:
dave4dl
  • 2
1 Solution
 
Dejan PažinCommented:

Mondrian implements MDX, maybe you could use that:

http://sourceforge.net/projects/mondrian/
0
 
dave4dlAuthor Commented:
Mondrian is an OLAP database (analogous to Analysis Services itself).  I need to connect to an existing Analysis Services database (in a Java program).
0
 
Dejan PažinCommented:

MDX is a proposed standard language and Mondiran has implemented it by specifications (plus added some of its own functions). Read more here:

http://mondrian.pentaho.org/documentation/mdx.php

In other words: Mondrian contains  the library you need. You dont need the whole Mondrian, you only need the MDX implementation.

I couldnt find any other free mdx implementation in java.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now