Shared connection Strings

[d1miller99]

In the Alteryx Server platform(or gallery), connections can be established in the admin section of Gallery, enabling all authorized users to utilize them. Is it possible to replicate this functionality in Alteryx Designer without relying on Gallery or Server? Can connections be centrally created for universal access, ensuring that workflows retain intact connections for any user who accesses them?

[cjaneczko]

Setup the Connection string as an Alias and have each user create that Alias in their DCM settings. 

https://knowledge.alteryx.com/index/s/article/Database-Connections-Creating-an-alias-and-the-advanta...

[d1miller99]

Yes we had done that before gallery, but that would require each user to input the connection information  (host, service name, ect) Gallery was nice because as long as you had proper permissions you could sync up the connections needed. Without gallery, you cannot. I guess i was hoping for a master "alias" that everyone could have access to. 

[Krishnasn]

To simplify and standardize the best way to connect to different databases in different environments.

For example,

There are 3 environments -

DEV (Designer + Gallery + Dev Source database)

STG (Designer + Gallery + Stage Source database)

PROD (Designer + Gallery + Prod Source database)

I only want to have a common name as "SOURCEDB" as the connection name in all the workflows and all the environments.

When developers create a workflow with the connections to "SOURCEDB" and the workflow is migrated to STG or PROD then "SOURCEDB" would mean respective Databases/Schemas i.e Stg Source Database and Prod Source Database. There is NO NEED to change anything inside the workflow but just setup the pointers for what SOURCEDB means pertaining to that specific environment.

Is the below process feasible in Alteryx Designer/Server setup?