This discussion is archived
3 Replies Latest reply: Nov 10, 2012 12:36 AM by tina.wang RSS

Passing ODI variable as data store password: not working

662451 Newbie
Currently Being Moderated
Hello,

we are trying to pass an ODI variable as a password for the connection to an oracle data server.

In the forum we found this thread:
Passing value to ODI Variable for password

We created an entry in the property tab with 'password' as key and #GLOBAL.varpwd as value, but it is not working giving the following error:
ORA-01017: invalid username/password; logon denied

If in the value field we write the password (unencrypted) everything works fine.

Anyone please can help?

Regards,
Stefania

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points