Search code examples
oracle-databaseoracle11gdblinkoracle-data-integrator

How to get DBLink name in ODI KM


I'm using Oracle Data Integration and i need to integrate in an IKM a source DBLink.

I have a simple mapping between one source table and one target table. The source table is on another database so I need to use a DBLink. I have created the DBLink in the topology and associated to the source Data Server.

I tried to "catch" the DBLink name using <%=odiRef.getInfo("SRC_DSERV_NAME")%> but i get the target instance instead of source DBLink(instance).

Any suggestions?


Solution

  • In the meantime I've found the solution: <@=odiRef.getObjectName("R","<%=odiRef.getSrcTablesList("", "[TABLE_NAME]", "", "")%>","D")@>.