MQ to Salesforce: Account Management pattern

Use the MQ to Salesforce: Account Management pattern to update update accounts and associated contacts in Salesforce.

This pattern bridges a reliable MQ protocol and the web service interface provided by Salesforce. Without customisation the pattern supports XML messages but using customisation you can substitute your own data formats and transformations.

A diagram showing the behavior of the pattern. Applications send WebSphere MQ messages to the broker, which uses the contained data to call salesforce web service requests.

The pattern implements a message flow that provides an entry point for WebSphere MQ messages for four Salesforce operations:

The Create operations correspond to the Salesforce "upsert" operation. The operations create a new account, or contact, if none exists for the given "foreign key" or modify an existing account, or contact, record. The "foreign key" is the unique identifier in the system generating the requests.

In the case of Create Account there is an option to also create any contacts included in the incoming MQ data.

The contacts will be linked to the newly created Account.

In the case of Create Contacts the incoming data will hold the unique identifier of the associated account in the source system. This will be used to look up the account in the Salesforce system and to link the contact to that account.

This pattern does not return a response to the client application, but it does check the service response, service faults, or timeouts, and any failures are reported according to the error options that you have selected.

Main flow
Create Account subflow
Contact Upsert subflow
Create Contacts subflow
Delete Account subflow
Delete Contacts subflow
Query subflow
Delete subflow
Get Session subflow
Error subflow
Log subflow
Tasks to complete before applying the pattern
Resources for the Salesforce pattern
Parameters for the pattern
Tasks to complete after generating the pattern