Datastore - Dynamic password

[Former Member]

Hi,

We are deploying dataservices and in QA environment, the target database password changes once in 2 weeks. We dont want to update the password to the datastore everytime as it requires manual intervention and also some of the jobs may fail till the time we update the password.

Is there a way my datastore can have dynamic passwords and read them on the fly. I mean from a text file or so.

Appreciate for your help.

Thanks

[Former Member]

Hi Adam,

I couldn't find till now to pass a password via the command line or file to the Datastore, If have the same issue with running ftp with the parameters from the datastore. I tried to retrieve the ftp password from the datastore however it failed to work, because the password are encrypted stored.

The only way is to change the password manually every time it changes.

[Former Member]

I have posted a possible way of doing this using al_engine for datastore password

http://www.forumtopics.com/busobj/viewtopic.php?t=150341

I need to check if you could do the same for other properties, you can try that, check the ATL of the Datastore and see what is the tag name of the FTP password and try adding that also in the input XML and see if it works