Replace all "Connection names" in 'Connect In-DB' tools in a file

Hi Team,

I get alteryx files from other teams, in which they have a connection name specified in all the "connect in-db" tools inside a file. Every time i have to open them click on the tool and then change the connection name. Is there any way to replace all the "Connection name" in all the "Connect In-DB" tools inside a file in one shot? ( I have to make 30 to 40 changes per file & we cannot standardize the connection names)

Tips and Tricks

Database Connection

Accepted answers

patrick_mcauliffe

In Designer, go to Options --> Advanced Options --> Workflow Dependencies.

You can replace all at once for each named connection (ie if two tools have the same connection name, changing it here changes it for both).

All comments

patrick_mcauliffe

In Designer, go to Options --> Advanced Options --> Workflow Dependencies.

You can replace all at once for each named connection (ie if two tools have the same connection name, changing it here changes it for both).

patrick_mcauliffe

@Manojkumardid this solve your question? If so, go ahead and mark it as solved so that others can benefit from it.

Thanks, it worked perfectly

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15874

MarqueeCrew 13708

apathetichell 13703