Skip to Main Content

Cloud Platform

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!

ODI LKM using DB Link

KashSiddApr 16 2019 — edited Apr 16 2019

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

Comments

Processing

Post Details

Added on Apr 16 2019
2 comments
1,011 views