I have a requirement where I may use different password for one data server in every week. But changing every week seems to be not a efficient way.
How to handle this? I want to automate it .
Any help on this ?
You can use one variable in declare mode in your package. Suppose password_v. Now use this in password field of your dataserver as
#password_v. It will be marked as dot but not a problem.Variable should be the 1st step in your package. Just generate a scenario and run it.Give the password at run time.
Just try it, it should work.
I believe for this reason we are using context. Your production context will point to another dataserver whose credentials is known only to dba or administrator.
Right ? So no need to bother about this.