Change DCM connections on Mass

[paul_houghton]

I have a workflow that contains numerous connections to different tables in a single server. These connections are DCM connections, but I want to mass change them as they have moved from one user to another.

Is there any way to mass update a connection without needing to go into each individual connection?

[jrgo · Accepted solution]

I haven't tested this, but you can try updating the XML of the workflow file directly in a text editor (I'm using Notepad++). 

I believe the important value that needs to be updated is the top one, which you can find by updating one connection, save the workflow then find the "ConnectionId" for the "Node ToolID" you updated and then do a find/replace in your text editor.

The bottom one I don't think is as important... it's just the annotation added to the tool, but can be updated the same way.

Save and 🤞it works.

[paul_houghton]

This is how I made the change, but an integrated way would significantly improve. This is exactly the use case in the workflow dependencies that should address but has been missed when DCM was integrated