Hey All, hoping you might be able to provide some guidance or perhaps more of a sanity check here. 😁
We have a use case where each individual user will need to run an Alteryx Workflow from the Gallery with their own Username and Password. The DB they are connecting to has row level security, so we need to have a way to ensure we only return back what their permissioned to see. DCM seems like it should solve this problem where each user can store their credentials on the server and call it in that workflow.
However, I'm running into the error "Selected Connection is not available. Set one up to use the tool." Based on what I read here, It seems the solution would be to share the connection with the other user, but wouldn't that also mean that the second user is running the workflow with the first users credentials?
My ideal state would be that User A creates a workflow with a DCM ODBC connection to our DB and they are able to save this out on a gallery for others to run. Using the new DCM Connection Interface tool, allow users B-Z to replace A's connection with their own. So when User B runs the published workflow, they are querying the DB as User B, User C as User C etc. Is what I am hoping for possible?
Thanks for reading!