Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

'public' data connectoin

harend
8 - Asteroid

Here's the issue I'm facing, I have an app in a collection that about 30 people will be using on a day to day basis. Right now if I don't add them and their private studio to the permissions, they get an unable to translate alias error and they can't run the app. As I have more of the 30 people test it out, I'd prefer not to go through and add them to the collection, their user to the permissions as well as their private studio. So far that's been the only way I've seen to be able to do it. Ideally I'd like to make the data connection public or to that whole collection and avoid having to add individuals each of those three places.

 

How have people been successful in deploying apps to collections and managed the data connections?

 

3 REPLIES 3
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@harend the fastest and easiest way is to hardcode credentials instead of using an alias.

harend
8 - Asteroid

so use an OleDB connection for the MS SQL server instead of the gallery connection?

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Yes, that would be the route I would go to first.