Promoting workflows from user desktop to server

kbs2018

Hi Alteryx community!

We have many workflows connecting to Hive as source/output. Users connect to Hive using ODBC connection. When they publish the workflows to gallery, it gets published using same ODBC connection and credentials. But we would like the workflow to utilize different login and password on server. Is there any way to accomplish this without manually editing workflow?

Thank you

Kiran

JakeS

Hi @kbs2018 

I would recommend reading this article which discusses how you can accomplish this using Windows Auth in detail (first section - Which user will the workflow run under when I publish or schedule it and how do I set up my connections to accommodate this?). This way, you can have the connection use a local users account when they are in Designer on the client machine, and use a service account on the Gallery server machine. If you require users to manually enter in credentials for the ODBC connection, you will have to manually change the credentials before uploading the workflow to the gallery.

Jake