Hi
I see that some of the ODI tools (such as the SAP tools) have an -ENCODED_PASSWORD option.
I was wondering if this is possible with other ODI tools such as OdiFtpGet, OdiFtpPut, OdiFTP and their sFT/SCP equivalents?
The reason for this is that I don't want to include clear-text passwords in my ODI routines or variables.
Often I have my variable values stored within a database table since this allows me to easily migrate compiled scenarios between our Dev / Test / Preprod / Prod environments and update the values without the need to recompile. If storing passwords in a variable values table in the database then this is an even stronger reason to be storing them in encoded form rather than clear-text.
I'm fine using ODI's included encode.sh script to generate encoded passwords ... I just now want to be able to use them within my application.
I have tried creating a task with the command below, but obviously it appears that -ENCODED_PASSWORD is an invalid parameter (at least in ODI 12.2.1).
OdiFtpGet "-HOST=#MYPROJECT.FTP_SERVER" "-USER=#MYPROJECT.FTP_USER" "-ENCODED_PASSWORD=#MYPROJECT.FTP_PASSWORD_ENCODED" "-PASSIVE_MODE=YES"
Any advice or recommendations are welcome.
Cheers
Andrew Mercer