This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.
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.