The following three areas must be defined:
Based on the integration processes required, the data objects and fields that are to be linked with one another must be determined. Example: The account name in Salesforce is to be linked with the SAP account name.
Data that can be exchanged, and frequently is in practice, includes:
One direction only for each data field or both directions?
On the basis of the objects and data defined above, one of the following conceptual integration approaches can be selected as required:
The physical exchange of data between the systems is the most frequent approach to integration. Example: A company account is to exist and be displayed both in Salesforce and in the ERP system. Usually a periodic exchange of data is sufficient, although not every object needs to be exchanged with the same frequency.
An SAP function is opened from Salesforce to obtain data in real time. A typical example is a credit check request during an order process.
With this approach, no data is exchanged between the system, but extracts from SAP are simply displayed within the Salesforce user interface. For example, a list of pending orders can be displayed.
Based on the complexity of the requirements, the technical approach should be chosen at the last stage. In this context, we make a distinction between two basic concepts that are frequently chosen:
The «Extract / Transform / Load» approach is based on lists that are generated either manually or automatically from one system, converted to a different form as required, and subsequently imported into the other system. As this form of integration usually involves a manual component, the approach is not suitable for a large number of connections or for frequent exchange. Despite these limitations, the approach is widely used because it is often adequate and the cost of implementation is also clear.
To combine two systems, either a third-party product can be used or a point-to-point integration can be selected:
This is typically an Enterprise Service Bus or a piece of middleware that can read and process data from both systems and write it to the other system. The business logic is mapped in this tool; little has to be changed in the systems to be integrated. There are dozens of products in the Salesforce environment that can be used for this.
As the name suggests, data is sent directly from one system to the other in this approach. The business logic is often implemented with the «calling» system. With direct integration, one system calls up the other system directly via a network/the Internet. For example, Salesforce opens a web service (SOAP) via HTTP request to place an order in SAP. If a common data transport protocol is not available, the conversion can be handled by a proxy system. For example, a Salesforce data retrieval is converted by a proxy into an RFC/BAPI call in SAP.
PARX has experience and references relating to all approaches to technical integration.