Configure Multiple Salesforce Org Connection Strings
- FuseIT OA
- Ashan Wijayawardhane (Deactivated)
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
- Configure Multiple Salesforce Org Connection Strings
- Configure the Sitecore SaveAction Template Field
- Create a New Sitecore Web Form
- Set the S4S Field Mappings