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 setting up workflows related to roughly 50 Salesforce objects going to their own SQL Server tables (potentially many in each workflow). As of now I need to enter the Salesforce user id and password roughly 50 times each and then reenter much of the information (including object and field selections) when I move the workflow between test and production. Also I might need redo this is if I need to use a non-expiring password.
How can I fix this so that the Salesforce id, environment (sandbox vs. production) and password are stored only once and the password is stored encrypted?
You could save the workflow as an analytic application and use a pair text entry interface tools (one for username entry and the other for password entry) along with the action tools to update each Salesforce tool with the correct information each time you run the workflow.