Disable ability to saved login info when connecting to database from dynamic input tool

Question

My team uses shared workflows that everyone has access too and a frequent problem we have is when someone tries to run a workflow with incorrect login details for the database we are using in the dynamic input selection ( i.e. another users login ID and password is saved and when someone else runs the work flow with out changing , then the other user gets locked out of their computer due to the other user trying to run the work flow with their login details).

Is there a way to prevent the login info being saved to the workflow? I.e. when someone opens the workflow , they have to login every time.  I know one solution would be saving the workflow to that users desktop after update login details but curious if there are any other ideas to prevent this from happening.

Thanks!

apathetichell · Answer

As @geraldo notes - just use IN-DB - and mandate a group wide naming convention for the database. Users will store credentials in their ODBC 64 on their specific machines and the In-DB will adjust based upon the specific user/machine it's run on.

geraldo · Answer

@amlrcd

the ideal is to create a connection with the same DNS (ALIAS) on the local machine and Server through the Alteryx option

Options-> Advanced Optionsn-> Manage Data Connections or Manage In-Db Connections
and use the Saved Data Source option
AKA:

Or disable item 9 of dynamic input