Skip to Main Content
Forums

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!

How to prevent ODI from creating a DBLINK on source

Ralph HMar 15 2018 — edited Mar 20 2018

I have a source to target ODI Mapping (Oracle source to Oracle target)

On the source I grant select privilege to a view that is in a different physical schema than the user that ODI connects as. 

When I run the mapping in simulation I see a create database link which fails due to permissions.  I don't want ODI to create a db link, how to I change this ?

Target Command:

create database link MDM_APPS connect to XX_ODI identified by <@=odiRef.getInfo("SRC_PASS") @> using 'MDMDEV_PRIM'

    

                                              

|             

                Target Command:             

            

create database link MDM_APPS connect to XXSW_ODI identified by <@=odiRef.getInfo("SRC_PASS") @> using 'SWMDMDEV_PRIM'       

           |
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2018
Added on Mar 15 2018
#business-intelligence-applications, #data-integrator, #system-management-and-integration
5 comments
534 views