Can BODS pull data from IBM Cognos TM1

dataservices job design
1

Hi All,

I have one requirement, How can we pull the data from IBM COGNOS TM1 in BODS?. I don’t see direct option to connect Cognos TM1 system in BODS. Are there any possible ways to do this requirement in BODS. Kindly suggest/explain me the ways or process to acheive this requirement in SAP BODS.

Appreciate your help!!

Thanks & Regards,
Sudheer Reddy

Sudheer Kodimi (BOB member since 2013-03-29)

2

Yes… Is there an odbc connector or data connect driver for this?

BODS should be able to get to the data via an available ODBC.

ww55d (BOB member since 2011-06-14)

3

I think you might struggle with ODBC as, according to this page ( http://en.wikipedia.org/wiki/Comparison_of_OLAP_Servers ) TM1 doesn’t support SQL. However, it does seem to support XML so you might be able to use that to extract the data.

Nemesis :australia: (BOB member since 2004-06-09)