Page 1 of 1

Oracle ODBC set to Cognos TM1

Posted: Fri Jun 22, 2018 2:25 pm
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

Re: Oracle ODBC set to Cognos TM1

Posted: Fri Jun 22, 2018 4:10 pm
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.

Re: Oracle ODBC set to Cognos TM1

Posted: Fri Jun 22, 2018 5:58 pm
by jim wood
Moved to the correct forum