Dynamic Connection Strings

[kayogunbo]

Dear Experts,

I need your expertise on this. I am tasked with creating some workflows that will dump its data into a database once the processing is done. However, switching from the Dev DB to the Production DB is usually a pain and i had a situation in which i didn't change a connection string correctly and the data was going into the wrong DB.

Now, i am refactoring the workflows and i would like a situation whereby i can change from a DEV to PROD with a click of a button. So i have created a spreadsheet saved on SharePoint that can help with with that and imported it successfully in Alteryx.

However, my issue is how do i use the derived connection string in my output. A sample workflow will go a long way in understanding how this will work and i will port it to my project.

Many thanks in advance!

[ArtApa]

Hi @kayogunbo - If I understood you correctly there are multiple ways of how you can achieve a desired outcome:

 - You can build a macro.

 - You can leverage DCM: https://help.alteryx.com/20221/designer/dcm-designer

 - However, to my mind the most simple way would be to use containers as per below:
 

Output to DEV:

Output to PROD:

[kayogunbo]

Thanks @ArtApa . Just seeing this. For the life of me.. I didnt get a notification that someone responded to my thread.

Concerning the solution provided. I have several outputs going into the DBs and using this approach means i have to create multiple containers and if for any reason, the server location change in the future then i will have to manually replace all of these strings in multiple places.

Just my thoughts!