Experts -
I recently found this post: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Database-Connections-Creating-an-alias-and-the-advantages-of/ta-p/15836 which has solved the issue of updating passwords in every data connection in every workflow when the pw changes, via updating connection aliases.
However, I am still stuck on updating the credentials in every workflow in the Gallery when the pw changes. Is there a similar sort of "alias" workaround that can be used to solve this problem?
Thanks!
The last comment in that Knowledge Base articles mentions
if you are using a gallery and trying to utilize the Gallery Connections, it's a bit different. Your Gallery Admin would need to set those up and then give you access to them.
Sounds like @Treyson has some experience there.
Wonder if @TonyM can add to the Knowledge Base article...
Sorry for the miscommunication. The Gallery-level data Connections are one thing, I am talking about the credentials used to run a workflow via schedule (should have mentioned that before).
So let's say I have 50 workflows scheduled in the Gallery and my pw changes every 2 months. Currently I need to go into every schedule and manually update the password. That's 300 updates per year.....not catastrophic, but the time could definitely be better utilized.
Is there a better way to do this?
@TonyM are you familiar with this? Are the credentials getting hard coded or something at the time of publication?
