You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2010-01-09 02:21:35

tomanizer
Guest

tomanizer said:

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.

#2 2010-01-09 02:25:51

tomanizer
Guest

tomanizer said:

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

#3 2010-01-09 02:33:38

tomanizer
Guest

tomanizer said:

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

#4 2010-01-09 02:43:46

tomanizer
Guest

tomanizer said:

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

#5 2010-06-30 12:22:11

wvaibhav
Member
17 posts

wvaibhav said:

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

Last edited by wvaibhav (2010-06-30 12:22:37)

Offline

#6 2013-02-12 08:39:35

melofon
Member
1 post

melofon said:

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.

Offline

#7 2014-10-08 15:00:50

soukaina.mountacer
Member
1 post

soukaina.mountacer said:

Re: Talend and Microsoft Analysis Services / SSAS / OLAP

how to connect microsoft analysis services with talend? 

Last edited by soukaina.mountacer (2014-10-08 15:07:49)

Offline

#8 2016-06-02 13:56:02

HalGrom
Guest

HalGrom said:

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. 

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy