Hello, my first post so be gentle :-)
We have gone round and round trying all the various versions of the Salesforce Input/Output connectors and everytime a designer user uploads a working flow the same workflow on the server has null credentials.
I know there is encryption involved but every other connector seems to retain the user credentials so that the connector will run on a schedule. If the server admin manually configures the workflow and re-authorizes credentials it works on the server but we can't have the server admin rebuilding all the worfklows for every upload. We tried deprecated connectors and now I've resorted to using ODBC drivers but having difficulty with the standard output tool.
Anyone have any solution where the worker/designer can successfully upload stored salesforce connector credentials to server and have it run on a schedule without server admin intervention?
Thanks,
Bill
Solved! Go to Solution.
Hey @Bill_Nickolson ,
Here is an answer from Alteryx support about this issue:
The SharePoint Files connector is a Python-based connector, so it will require the following registry key to exist in both the end users machine as well as each worker node on the server.
Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx
Value Name: PythonAllowHideEncryption
Value Data: true
Once this key has been added, the user would need to reauthenticate the Salesforce tool on his workflow in Designer and republish the workflow to gallery
Best,
Fernando Vizcaino
Hi Fernando,
Just to confirm you mentioned Sharepoint but this will work with Salesforce connectors? This is a great suggestion and we'll give it a try and update others here.
Thank you for the quick response!
Hi @Bill_Nickolson ,
Yeah, for all python based connectors with authentication, it is worth trying it.
Best,
Fernando Vizcaino
This worked great! Thank you Fernando. A+++++