Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

 

Introduction:

One of the challenges for any Salesforce and SAP PI/PO integration project is getting data from Salesforce back to SAP in reliable and secured way. Salesforce provides different ways like Streaming API, Queries using SOAP API or APEX callouts. This blog covers one specific option: Outbound Messaging.

Outbound Messaging:

Using Outbound messaging, you can define fields within Salesforce for which a notification will be sent to SAP PI/PO when values of these fields are changed. Outbound messaging is part of a workflow rule defined in Salesforce for a specific object.

One important feature of Outboundmessaging is that it guarantees delivery of messages that are not older than 24 hrs. This means that if for some reasons the PI/PO system is temporal inaccessible, Salesforce will retry to deliver the data at later time. However, keep in mind that the data may be out of order when arriving to the PI/PO system.

Example of Outbound Messaging:

We will use the Opportunity object as an example on how to setup Outbound messaging on Salesforce side and how to use the Advantco SFDC adapter to listen for messages from Salesforce.

1. Salesforce – Create a new workflow rule

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

2. Salesforce – Define a new Outbound message

Create a new Workflow rule for the Opportunity object.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

Create an outbound message and assign it to the workflow rule.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

Workflow with Outbound message action activated.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

3. Salesforce – Download WSDL

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

4. SAP PI/PO – Import WSDL and generate the PI/PO OBM Web service deployment file.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

A web service deployment file is created based the Salesforce Outbound message WSDL file.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

5. SAP PI/PO – Deploy and Configure OBM Web service

Deploy and configure the Web service object to listen for incoming notifications from Salesforce.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

6. SAP PI/PO – Import WSDL into ESR to generate message structure

Import the Outbound message WSDL from Salesforce into the ESR to define the source message structure.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

7. SAP PI/PO – Create sender SFDC channel and create OBM mapping

Create new sender SFDC channel of type Salesforce OBM.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

Mapping object Opportunity to the sender OBM channel.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

8. SAP PI/PO – Complete Configuration Scenario

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

9. Salesforce – Update Outbound message endpoint

Copy the endpoint of the Web service OpportunityNotificationPort.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

Goto the Outbound Message screen and update the endpoint with the correct endpoint from the PI system.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

10. Salesforce – Test Opportunity update

Create a new Opportunity object to trigger an outbound message.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

11. SAP PI/PO – Check incoming message from Salesforce.

Channel monitor: new message coming into the OBM sender channel

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

Payload of the Outbound message as received by PI.

Data integration with Salesforce and SAP PI/PO using Outbound Messaging.

Summary:

Outbound Messaging is a very powerful feature to get almost real-time information from Salesforce to SAP. The Advantco SFDC adapter supports this method of data replication with minimal configuration efforts and without the need to implement specific JAVA codes.

 

https://store.sap.com/sap/cpa/ui/resources/store/html/SolutionDetails.html?pid=0000013830&catID=&pcntry=US&sap-language=EN&_cp_id=id-1428076572209-0

 

 

Please reach out to our sales team at sales@advantco.com if you have any questions.