One Star

Talend and Microsoft Analysis Services / SSAS / OLAP

I would urgently some need connectivity to Microsoft OLAP SSAS.
e.g. specify and MDX and retrieve the rows just as they are returned by Microsoft SQL Management Studio.
Can this be done? I have not seen any java connectivity to SSAS.
7 REPLIES
One Star

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

it could be based on the simba sdk
http://www.simba.com/olap-sdk.htm
but it's not open source
One Star

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

* Olap4j is an open Java API for OLAP - http://www.olap4j.org
* REX is a open source client that provides this functionality - http://sourceforge.net/projects/whex
* J-Integra for COM is another provider for this
One Star

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

from http://blog.devdonkey.org/?tag=ssas
Connect Microsoft SQL Server from olap4j
Thursday, May 21st, 2009
Browsing my Google Analytics statistics, I realized there is a lot of people out there that are searching for ways to connect Microsoft SQL Server with olap4j.
Here is a nice example.
// We must use the XMLA driver.
Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
// This code is for Java 5. With Java 6, you can directly
// unwrap the underlying connection with the .unwrap() call.
OlapConnection connection =
(OlapConnection) DriverManager.getConnection(
// This is the SQL Server service end point.
"jdbc:xmlaSmiley Frustratederver=http://example.com/olap/msmdpump.dll"
// Tells the XMLA driver to use a SOAP request cache layer.
// We will use an in-memory static cache.
+ ";Cache=org.olap4j.driver.xmla.cache.XmlaOlap4jNamedMemoryCache"
// Sets the cache name to use. This allows cross-connection
// cache sharing. Don't give the driver a cache name and it
// disables sharing.
+ ";Cache.Name=MyNiftyConnection"
// Some cache performance tweaks.
// Look at the javadoc for details.
+ ";Cache.Mode=LFU;Cache.Timeout=600;Cache.Size=100",
// XMLA is over HTTP, so BASIC authentication is used.
"username",
"password" );
// We can execute a query. MDX of course.
CellSet set = connection.createStatement().executeOlapQuery(
"SELECT {} ON COLUMNS FROM CUBE");
One Star

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

Hi,
I have created a talend job to connect SSAS cube from Talend. I have imported olap4j.jar file and added the java code in the post using tjava component. It gives me error file not found for the said dll file. I already have the dll file inside sql server olap folder.
Please let me know how to resolve this.
Thanks
Vaibhav
One Star

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

Are there any news in this field? I need a conectivity for IBM Cognos TM1, it would be good to use talend exept of Cognos TM1 TurboIntegrator. XMLA could be a solution.

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

how to connect microsoft analysis services with talend? 
One Star

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

Can you let me know if this has been resolved, I am currently having the same issue.