Oracle ODBC set to Cognos TM1

Post Reply
NAGAMANIKANTA PALURU
Posts: 1
Joined: Fri Jan 05, 2018 1:03 pm
OLAP Product: ORACLE 11G
Version: 10.2.2
Excel Version: 10

Oracle ODBC set to Cognos TM1

Post by NAGAMANIKANTA PALURU »

Hi ,

Can you please help me how to give connection from "ORACLE database to CONGOS TM1".
If you have any documents can you please share it me.

Regards
Manikanta
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Oracle ODBC set to Cognos TM1

Post by tomok »

So, you want to extract data from TM1 into Oracle using ODBC? You can't. TM1 does not expose it's data via ODBC. You can extract data from a TM1 cube using ODBO. Your best bet to get data from TM1 to Oracle is to push it from the TM1 side using the TurboIntegrator tool. You can execute SQL commands from there, like INSERT, etc.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Oracle ODBC set to Cognos TM1

Post by jim wood »

Moved to the correct forum
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply