Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Bulk Updates From Local to Gallery Connections

Brian_Stoffel
8 - Asteroid

We have about 150+ workflows that have multiple local data connections. Our group is moving to server and we need to update our data connections from local to gallery.

 

Is there an easy way of bulk updating our connections from local to gallery? Is there a macro or something built?

 

We have at most 10-20 different data connections but we have 150+ workflows that use these data connections. It seems pretty repetitive to open each workflow and update each "Input Data" tool (or whatever) from a local connection to a gallery connection.

 

 

I found this helpful article from a couple of years ago, but we have to repeat the process a few hundred times. https://community.alteryx.com/t5/Alteryx-Server/Managing-Data-Connections-Between-Server-Scheduler-a...

 

 

I posted this question to the server forum but it might more sense to be posted in the Designer forum. https://community.alteryx.com/t5/Alteryx-Server/Bulk-Updates-From-Local-to-Gallery-Connections/m-p/6...

2 REPLIES 2
CristianoJ
Alteryx
Alteryx

@Brian_Stoffel ,

Unfortunately,  it is still not possible to mass update the Data Connections (from local to Gallery connection) on existing workflows

JTMorris
6 - Meteoroid

Hi @Brian_Stoffel ,

 

I would recommend checking out the Workflow Admin Manager (WAM). It allows users to simplify Alteryx administration by providing comprehensive Alteryx audit reporting, the ability to mass change anything related to your workflows, and the ability to track and lock your workflows. It is really helpful for finding and/or replacing data sources, filters, formulas, etc. to many workflows; update multiple workflows when file paths, connection names, or business logic changes; ensure production version integrity; revert to prior versions of a tracked model; identify duplicate workflows; switch all workflows to relative paths to ensure workflows work across teams; and perform audit reporting to provide details related to workflow that can be shared with anyone. More info can be accessed at the link below.

 

https://gallery.alteryx.com/#!app/Workflow-Admin-Manager-for-Alteryx-by-Capitalize-Analytics/5fb3ff2...