Salesforce Connectors - wiped credentials when uploading to Server

Question

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

fmvizcaino · Accepted Answer

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.

* Type regedit in Windows Start Menu 
* Browse to the folder location: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx 
* Right click and select New > String Value

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

fmvizcaino · Accepted Answer

Hi @Bill_Nickolson ,

Yeah, for all python based connectors with authentication, it is worth trying it.

Best,

Fernando Vizcaino

Bill_Nickolson · Accepted Answer

This worked great! Thank you Fernando. A+++++