2 Replies Latest reply on Apr 16, 2019 5:02 PM by KashSidd

    ODI LKM using DB Link

    KashSidd

      Hi,

       

      I have the following Data Servers

       

      Source: Oracle DB

      Target: Oracle DB (This has the DB Link going to the Source)

       

      I have been trying out the following LKMs but not being successful:

       

      LKM Oracle to Oracle (DBLink)

      LKM Oracle to Oracle Pull (DBLink)

      LKM Oracle to Oracle Push (DBLink)

       

      Which one should I use and which Data Server should I add the DB Link to?

       

      BTW, it works when I use LKM SQL to Oracle but takes very long to load the data into the Target table.

       

      ODI Version: 12.2.1.2.6