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

    ODI LKM using DB Link




      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: