Forum Stats

  • 3,734,269 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

ODI LKM using DB Link

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

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

Answers

Sign In or Register to comment.