topic Re: Talend and Microsoft Analysis Services / SSAS / OLAP in Talend Studio

Talend and Microsoft Analysis Services / SSAS / OLAP

_AnonymousUser — Sat, 16 Nov 2024 13:37:02 GMT

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.

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

_AnonymousUser — Sat, 09 Jan 2010 01:25:51 GMT

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

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

_AnonymousUser — Sat, 09 Jan 2010 01:33:38 GMT

* 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

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

_AnonymousUser — Sat, 09 Jan 2010 01:43:46 GMT

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:xmla erver=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");

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

Anonymous — Wed, 30 Jun 2010 12:22:11 GMT

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

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

Anonymous — Tue, 12 Feb 2013 07:39:35 GMT

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

Anonymous — Wed, 08 Oct 2014 15:00:50 GMT

how to connect microsoft analysis services with talend?

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

_AnonymousUser — Thu, 02 Jun 2016 13:56:02 GMT

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