Analytics Software

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!

Issues accessing synonyms in ODI

745723Jan 11 2010 — edited Jan 12 2010

Hi,

I am having issues accessing synonyms in ODI. We have created private synonyms in our user space pointing to the views which rest on another user space. I am able to query the database(oracle) to see the synonym(see data and count) but I do not see the synonym listed in ODI for me to reverse it.

I am using standard RKM and not RKM Oracle. I can view all the public tables and views in the selective reverse tab but not the ones declared private. Is there any specific way of getting synonyms into ODI i.e., do I need to use another RKM?

Thanks,
Akshata

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2010

Added on Jan 11 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

2 comments

1,517 views