Update Credentials in Gallery

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!

Best Practices

Accepted answers

Treyson

Hey @Bonediggler!

I have always made it a priority to create a service account and schedule/run all jobs through that account. That way there are no passwords to manage. If your password lives in the connection sting you should be able to update the connection string on the galley connections (formerly called aliases) and that will pass to the scheduled jobs. There are also some problems I have been having recently in this area. I would love to chat with you about this. If you want to DM me some contact info and hours you are free I think maybe we are just getting mixed up on our semantics.

All comments

ChrisTX

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...

Bonediggler

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?

ChrisTX

So you're talking about updating *database* passwords within each workflow?

I'm guessing you've seen these posts:

wrap your module in a macro: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Update-the-user-name-and-password-frequently-using-Macros/m-p/40389

Running with a service account: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Running-Alteryx-Flow-with-a-service-account/m-p/324520

Dynamic Connection String: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Connection-String/m-p/80820

We're just starting to work with the server, so we haven't run into common issues like this. Maybe consider a PM to @Treyson or a tweet @TreysonMarks ?

Bonediggler

Nope. Gallery -> Schedules -> Edit Schedule -> Edit Credentials -> Schedule As (Username & Password)

Whenever my Windows password changes I need to go into every schedule and change the password there. Is there a way to streamline this?

Treyson

Bonediggler

I think that's the answer I was looking for. Unfortunately I am not the one with rights to create a service account so I will pass this along to the server admins. I'll definitely be in touch if we are still stuck.

Thanks!

Treyson

@TonyM are you familiar with this? Are the credentials getting hard coded or something at the time of publication?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703