Forum Stats

  • 3,734,269 Users
  • 2,246,935 Discussions


ODI LKM using DB Link

KashSidd Member Posts: 73
edited Apr 16, 2019 3:33PM in Data Integration


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:


Sign In or Register to comment.