Tuesday, March 6, 2012

Access SSAS 2005 Data from Java

I have a C# ASP.NET 2.0 application that is using ADOMD to access my cube data in SSAS and it works very well.

I have another project in Java and would like to integrate SSAS cube data. Is this possible? I know Microsoft makes SQL Server drivers for Java. Is there anything like ADOMD for Java? If not, is there a OLAP type tool that is similar to SSAS that is Java friendly?

I know Java and Microsoft are usually competing and incompatible technologies. Please don't tell me to switch or turn this into a political thread.

Any tips are greatly appreciated.

Thanks in advance!use XMLA. there are plenty of opensource solutions and examples it about.|||

Here are links to two good open source tools which use Java to access Analysis Services through XMLA:

1. JPivot http://jpivot.sourceforge.net/

2. REX http://sourceforge.net/projects/whex/

No comments:

Post a Comment