Limitations in Using Variables in the PASS / PASSWORD Parameters of ODI 12c Tools when Exporting / Importing Between Environments
(Doc ID 2470588.1)
Last updated on AUGUST 31, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 and laterOracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Symptoms
In an Oracle Data Integrator (ODI) 12c Package, the "-PASS" parameter for the OdiSQLUnload Utility takes the encoded value from a Variable previously defined in the Package.
For example:
- Case 1.
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! |
In this Document
Symptoms |
Cause |
Solution |
Solution 1. Use the ODI substitution method directly in the PASS / PASSWORD field |
Solution 2. Construct an ODI Variable that will take the encoded content from a file |
References |