Dynamic update Input tool connection password?

[BosKev]

Hi All,

There's a database we pull from often to create various workflows in my work but our company policy mandates passwords change every 3 months or so. Its becoming clear this is becoming an annoyance as more workflows are created  connecting to this database having to refresh the logon passwords each time.

Is there a solution on how to dynamically update passwords within the input connection, I can keep the password update consistent i.e. change number each period but how do I pass this through onto the input tool? Thanks.

[mbarone]

Not a perfect solution, but here's what I do (we too have a connection that forces a PW change every 90 days - nothing we can do about it - they won't create a generic account/login for it).

Not sure what you're experience level is, but a lot of info here, so I'm keeping it high-level.  Let me know how much detail  you may want.

First, I create a YXWZ that prompts me for the new PW.  I enter it and it writes it to a YXDB.  So I always have a YXDB out there with the correct PW.

For my module that uses the connection, I have it as a batch YXMC, with no macro output tool (just whatever output was there originally), just a control parameter input that updates the PW in the input tool.  I have a simple YXMD with the YXDB that contains the PW connecting to the YXMC, feeding in that PW.  And then the YXMD is the module that gets scheduled.  In other words, the "real" module that's doing the thing I need (extracting from the database) will always use the PW that's stored in the YXDB.  And I have about 10 such modules.  So I only ever have to change the PW in that one YXDB, and nowhere else.  

Then, I have a module scheduled every AM that pings the database by searching for one record.  If it fails, I'm notified, and I know it's time to update my PW, then run the YXWZ to update the YXDB that all my modules reference.

A lot there to digest.  Let me know if you have any questions.