Analytics Software

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 Interface error: ORA-02019 Connection description for remote database not found

SambuuMay 6 2020 — edited May 8 2020

Hello everyone i created simple interface on ODI 12c

Here's my mapping overview:

I'm using Oracle Incremental Update KM

ALMS_MEMBERS is my local data warehouse

PROFILES is remote database table.

When i run my interface giving me this error: ORA-02019 Connection description for remote database not found

I've created manually database link on my remote database,

Unfortunately, ODI deletes my created database link everytime execute interface.

I tested my connection, test result is successful.

How to resolve this issue?

Thank you.

This post has been answered by XavierGrosfils on May 7 2020

Jump to Answer

Added on May 6 2020

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

2,966 views