Configure Multiple Salesforce Org Connection Strings

Owned by FuseIT OA
Last updated: Apr 10, 2018

The S4S WFFM Module can be configured to be able to submit data to multiple Salesforce Orgs on a form-by-form basis. Currently, this is only available for S4S with Sitecore 8.1. The multiple S4S connection strings are configured in the App_Config/ConnectionStrings.config file. By default, you need to configure the S4SConnString and S4SConnStringUI. You can then add more S4S connection strings with unique names that must follow the pattern:

S4S:user id=<user_name>;password=<user_password>
S4S:user id=<user_name>;password=<user_password><user_security_token>
S4S:user id=<user_name>;password=<user_password>;token=<user_security_token>
S4S:user id=<user_name>;password=<user_password>;environment=<binding_environment>

An example of a Sitecore website that connects to multiple Salesforce orgs:

<!-- the 'primary' connection strings -->
<add name="S4SConnString" connectionString="S4S:user id=myuser@fuseit.com;password=mypassword;environment=DeveloperEdition" />
<add name="S4SConnStringUI" connectionString="S4S:user id=myuser@fuseit.com;password=mypassword;environment=DeveloperEdition" />


<!-- additional connection strings -->
<add name="S4SConnStringOtherOrg" connectionString="S4S:user id=other@fuseit.com;password=otherpassword;environment=DeveloperEdition" />
<add name="S4SConnStringAnotherOrg" connectionString="S4S:user id=another@fuseit.com;password=anotherpassword;environment=DeveloperEdition" />

You can add user friendly names to display in the UI for the above connections strings as app setting in S4SMappings.config as follows.

<setting name="S4SConnString" value="Default Org"/>
<setting name="S4SConnStringOtherOrg" value="Other Org"/>
<setting name="S4SConnStringAnotherOrg" value="Another Org"/>

"name" refers to the actual connection string name and "value" refers to the display connection string name.

S4SMappings.confg can be found in the App_Config\Modules\S4S\ folder.

The S4S Mapping Wizard and Bulk Analytics Updater will automatically process the extra connection strings.

Next Step

Configure the Sitecore SaveAction Template Field

Steps