topic Re: Bulk Updates From Local to Gallery Connections in Alteryx Server Discussions

Bulk Updates From Local to Gallery Connections

Brian_Stoffel — Wed, 29 Jul 2020 16:20:41 GMT

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-and-Local/ta-p/135108

Re: Bulk Updates From Local to Gallery Connections

CristianoJ — Tue, 04 Aug 2020 21:08:48 GMT

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

Re: Bulk Updates From Local to Gallery Connections

JTMorris — Thu, 07 Jan 2021 18:28:58 GMT

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