Pass gallery login and password via input data tool to gallery data connection

[Samuel_To]

Assume users using AD login/ password to access gallery. 

And they are using individual AD account to login database with different access right.

Now, if we want to use individual account in the gallery data connection.

We need to get the user password and create many data connections in gallery 

If input data tool can pass the gallery login/password when user try to use gallery data connection to connect the database. 

We only need to setup one data connection but have individual access control.

For example, user A and B have different role in a oracle database. 

Even they use the same gallery data connection, they will access different table/view. 

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

[SeanAdams]

Hey @Samuel_To 

Part of the challenge with data connections is that they have to be able to run un-attended (i.e. when there is no-one sitting in front of the computer - scheduled to run at midnight etc) - and for that you need to have credentials for the DB that don't depend on the user being in-front of their PC.

We have done something like you suggested where we needed users to identify with the DB - we build an analytical app that asked them for username & pwd, and then passed this on to the database.

All that being said - given that the Alteryx server has your kerberos token - it may be useful to be able to pass this through to the DB for authentication if the user IS working interactively but not sure how that would work if there's a mix of scheduled & interactive usage.