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?
@harend the fastest and easiest way is to hardcode credentials instead of using an alias.
so use an OleDB connection for the MS SQL server instead of the gallery connection?
Yes, that would be the route I would go to first.