Some Variables in ODI 12c custom KM using odiRef.getXXX are not Substituted at Runtime
(Doc ID 2715813.1)
Last updated on OCTOBER 07, 2020
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
A customized Oracle Data Integrator (ODI) Knowledge Module (KM) has steps using "odiRef.get", ie"<%=odiRef.getInfo("SRC_DSERV_NAME")%>. The data server is configured to point to a global variable. When executing a mapping, the variable from odiRef.getInfo("SRC_DSERV_NAME") is not substituted, while other variables are generally correctly replaced.
- Create a Data Server that uses a global Variable in the "Instance / dblink (Data Server)" field, and another global Variable in the URL field (append to "jdbc:oracle:thin:")
- Create a custom Integration Knowledge Module (IKM), which implements the following code in any of its tasks:
- Create an Integration Interface that loads data from / to a Datastore on that Data Server.
Upon executing, the Mapping will show substitution of #GLOBAL.<VARIABLE_NAME_FOR_JDBC_URL> variable, but not of the one used in the "Instance / dblink (Data Server)" field
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document