Skip to Main Content
Forums

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!

ODI variable for password

2709933Jul 23 2018 — edited Jul 24 2018

Hi,

I need to upload the documents from my local server to client SFTP server.

But hear for every 90 days SFTP password will change, so we need to change the password in ODI SFTP utility then generate scenario and need to deploy into PROD.

we need to avoid that manual change in ODI SFTP utility.

for that, we Created a table in DB and tried using refresh variable, we are substituting the refresh variable in password area in ODI SFTP utility, using #Password_vairable_name tried using local variable also.

But i think its taking #Password_vairable_name as a password, not as a variable, execution getting fail.

Please help me how to automate this process.

Thanks in advance.

Regards,

Aravind.
This post has been answered by Pavan8u on Jul 24 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2018
Added on Jul 23 2018
#business-intelligence-applications, #data-integrator, #system-management-and-integration
14 comments
1,104 views