Skip to Main Content
Forums

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

Timo Hahn

User, tell us your exact JDev version, please!
I don't understand what you try to do. Anyway, you can create a transient attribute in the VO and overwrite the getter method for it. In the overwritten getter you access the bundle and return the string.

Timo

1 - 1

Post Details

Added on Apr 16 2019
#data-integration
2 comments
1,014 views