In setting the authentication option for "Execute SQL" it requires the username and password to be hardcoded in.. this means that when the password is changed (we have mandated password changes), the workflow just errors as the authentication fails.
Is there any way around this limitation?
Solved! Go to Solution.
I would suggest creating a Workflow Constant with type Credential. That allows you to centrally and securely store the username/password credentials in the Workflow Constant and use it in the workflow actions where credentials are needed. This also allows you make only one update to the password should it change.