Updating multiple data connections.

[lillyt2006]

Hi

I have more than 10 connections (same database but different table) in a workflow.  Is there a way to update all 10+ connections at once?

I am doing this often especially when moving code from DEV to QA and then QA to PRD.  

Thanks

[DavidSkaife]

Hi @lillyt2006 

One quick way is using the Workflow Dependencies setting - go to Options-Advanced Options-Workflow Dependencies

You can update the filepaths etc from here far quicker than going into each tool, just by clicking edit next to the location.

[dana_mcdonough]

Hi @lillyt2006 : Here is a great article on how to utilize constants to define your environment. I think this method will help you. Take a look and let me know what you think.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Moving-from-Dev-to-Prod/ta-p/158825 

[KSowers]

One creative approach that I've done in the past was to create the connection from within a macro. This has allowed me previously to change the table name within my connect in one location and have it reflected across the 10 different macros/Connections. I'll attach just a fake scenario of what this would look like. If you change the Text input tool in the macro to an input tool with the DB connection, you should be able to get it to work. Let me know if this doesn't make sense or you need more help/information. 

[lillyt2006]

When I update the connection to a Gallery connection, the dependency column comes up with a total different name.  

[lillyt2006]

I have version 2019.  I could not open the workflow

"This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx."

[DavidSkaife]

Hi @lillyt2006 

If you click the edit button to the left, you will get a window like this:

Select the folder icon i've highlighted in yellow and you will get another screen that you can follow through to Saved Data Connections, Your Company Gallery in order to switch to a new connection

[Christina_H]

It might depend on the connection, but I've made changes like this with a simple find and replace.