Change DCM connections on Mass

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?

Connectors

Database Connection

Accepted answers

jrgo

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.

All comments

jrgo

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++).

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

wiseVijay

Just found that there is a DCM migration tool which is super useful. It is under Options - > DCM Migration Tool in Alteryx Designer

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703