Allow user to Provide User Credential for Gallery Connection

I am using a Dynamic Input tool in my workflow which does not allow to use file based connection. Because I need to process huge volume of data everyday in the off hour business, I decided to upload it to the gallery and schedule the nightly execution. Here's a scenario that I am trying to resolve, no luck so far.

My Gallery Admin created a SQL Server DB connection and shared with my studio. It was initially defaulted to "WIndows Authentication". When I try to upload the workflow, it fails because my ID does not have access to database (ERROR: Login Failed for user domain\userid). There is a generic user id which is used to access the database. I asked the Admin to default the connection to "SQL Authentication". When I refreshed connection on my Designer and tried uploading the workflow to gallery, it failed again. This time it was taking some default user from gallery which runs all the workflows on the gallery.

Is there a way that user is prompted to provide user credential? Or is there something different that I should do?

Gallery

Server

Database Connection

Accepted answers

wwatson

I think you can put whatever credentials you want into the Server IN_DB connection, the connection name just has to be the same as you used in designer.

The workflow will only exist in the Private Studio you save it to on server and could be shared in a collection.

All comments

wwatson

What we did with an Oracle database was to have the user set up an IN-DB connection with a specific connection name and their own credentials in their Designer application.

We gave the Server User access to the same database and set up the same IN-DB connection name on server using the server user's credentials.

When the user runs the workflow it uses their user credentials behind the IN-DB connection name on their designer application, when the server runs the workflow it uses the server's credentials behind the IN_DB connection name on Server.

It might be worth investigating this option.

rituraj963

Thank you wwatson, The same suggestion was given to me by my admin. Since our data is very sensitive, so we did not want to give database access to the service account that runs the workflows on the server. I will check with my admin if our service account to access database can be hosted on the gallery as another service account to run workflows on the server.

I have always used In-DB input tools to where i used file based connection.

wwatson

I think you can put whatever credentials you want into the Server IN_DB connection, the connection name just has to be the same as you used in designer.

The workflow will only exist in the Private Studio you save it to on server and could be shared in a collection.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703