Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to ETL extract data from Oracle database 11.1 using Cognos Data Manager 10.1

EmilijaMar 31 2015 — edited Apr 1 2015

Hello,

I need to run the IBM Cognos Data Manager version 10.1 ETL tool to extract data from the Oracle11.1 database.

My understanding is that from the database perspective the best way would be to have a stored procedure that will provide a reference cursor to the client ETL tool.

However, running a database stored procedure from the ETL tool does not appear to be possible in this version of Data Manager.

Has someone done this before? What is the best way for this extract to be done?

Thank you,

Emilija

This post has been answered by unknown-7404 on Apr 1 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2015

Added on Mar 31 2015

#general-database-discussions

9 comments

1,597 views