Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Encoded Password in OdiFTPGet tool

Andrew MercerOct 3 2017 — edited Oct 17 2017

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2017
Added on Oct 3 2017
4 comments
953 views