Locking Oracle Database

[S2N]

I have to change my Oracle database passwords every 90 days.  After I change it, when I open a workflow with more than 3 queries the login fails and my database access gets locked and I have to have IT unlock it.  Is there a way to prevent the workflow from trying to login to a database on open?

[cjaneczko]

Are you using DCM to connect to the Oracle DB? You can update the password in your credentials before you open the workflow. Then when the workflow is opened it will already have the updated password and shouldnt trigger the lockout.

Its located under File > Manage Connections > Credentials.

[S2N]

Thank you for the reply.  I had the credentials setup, but for some reason my connection string was "AKA" + database name and it changed to "dcm:" + database name, so I was having to re-do the queries.  I ended up taking them out one at a time to fix.  It would only error on the dynamic inputs and not the regular input tool.  Thanks again for the reply.