3 Replies Latest reply: Nov 10, 2012 2:36 AM by Tina.Wang-Oracle RSS

    Passing ODI variable as data store password: not working

    Stefania
      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