Some Variables in ODI 12c Custom KM Using odiRef.getXXX Are Not Substituted at Runtime
(Doc ID 2715813.1)
Last updated on FEBRUARY 16, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.4.0 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Symptoms
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.
To reproduce:
- 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |