title: Query Analysis Services Cubes in java without using msmdpump.dll
body: <p>I am currently tasked to build some kind of healthcheck-application, which is later to be included in a jboss environment. But first things first. I need to access 3 different types of databases: MS SQL relational, TM1 and MS SQL Analysis Servies. While the first two seem to be manageable, I have encountered a problem trying to access Analysis Services through java. Most commonly, the <code>olap4j</code> library seems to be used, but this is based on the <code>msmdpump.dll</code>, tunneling the response through the IIS. We cannot use this approach, since the IIS is not in use and we do not have system access to the Analysis Services Server.</p>
  
  <p>In short words: How to access Analysis Services in Java without using <code>msmdpump.dll</code>? We need to send simple querys in either MDX or XMLA. Both client and server are using Windows Server 2008 R2. The Analysis Services version is 2008 R2 as well. Analysis Services is provided to us as a service, we do not have access to the system itself.</p>
  
  <p>It seems to be an option to use a powershell script to access Analysis Services and to call this script through java. But I would rather avoid this approach if there is a better option.</p>
  
  <p>Thanks for any help!</p>