Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Salesforce Connectors - wiped credentials when uploading to Server

Bill_Nickolson
5 - Atom

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 

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

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

Bill_Nickolson
5 - Atom

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! 

fmvizcaino
17 - Castor
17 - Castor

Hi @Bill_Nickolson ,

 

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

 

Best,

Fernando Vizcaino

Bill_Nickolson
5 - Atom

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