SAP PI v/s SAP BODS
What is SAP PI:-
SAP PI provides technical infrastructure for XML based message exchange to enable the integration of business processes.
It is an Integration technology & platform
- For integrating SAP systems with Non-SAP systems.
- For integrating A2A & B2B applications.
- For synchronous & asynchronous exchange of messages.
- For cross component Business Process Management.
What is SAP BODS:-
Data Service is the primary tool to extract, transform & load data from one or more source systems into one or more target systems.
Data Services can access data from a wide variety of applications and file sources and can consume almost every type of data—structured, semi-structured, and unstructured—from those sources.
Types of Integration:-
There are different ways of integrating business applications.
- Service Integration
- Message Integration
- Business Process Integration
- Data Integration
Different approaches to handle the integration types.
- Service Integration.
- ® Establishment of a service –oriented architecture.
- Message Integration & Business Process Integration.
- ® Enterprise Application Integration or B2B integration.
- Data Integration.
- ® Extract, Transform & Load utilities.
Service oriented Architecture
- All functionality is published as a services in platform independent manner.
- Services can be consumed by other applications.
Enterprise Application Integration.
- Process of linking different applications within a single organization together in order to simplify and automate business processes to the greatest extent possible.
Extract Transform & Load
- Extracting data from different sources.
- Transforming it to fit the operational & analytical needs.
- Loading it into end targets.
Out of these SOA & EAI can be managed by SAP PI & ETL can be managed by BODS.
There is overlap between SAP PI & BODS about the functionalities they offer.
Deciding factors about the choice between the PI & BODS are
- Technical & functional capabilities of both
- Organizational environment
- The type of integration to be done.
- Technical environment(hardware size)
- Other factors.
Process Integration v/s Data Services
We will discuss the capabilities in detail
- If large no of messages are per second with less or medium amt of data need to be delivered then SAP PI is the very good choice.
- If the data volumes are very large & frequency of data to be transferred is less than SAP BODS is the choice.
Suppose the requirement is that the data is sent to a business partner twice a month & the file size is 4 GB. Then in such a case sending the data to BODS is good option.
- Scheduled / Batch Based:-
Data services processing is typically scheduled. You can schedule the Batch jobs in BODS or specifically run it. Pi jobs can also be scheduled but generally they are not scheduled.
- Event / Trigger Based:-
BODS has the capability to receive events via web services or other means & process these events.
PI is typically triggered by incoming data.
- Real Time(synchronous/ asynchronous):-
Data latency for DS is larger( minutes rather than seconds).
PI offers mechanisms for real-time synchronous transactions.
- Data has to be moved from the database to BW system once in a week or once in a day then BODS is the goods option.
- File has to be picked from the sender system after every 10minutes then SAP PI is the good option.
Data Processing Level:-
- PI is used to exchange messages between systems while data service is used to exchange data set.
- Both data services & PI do well in applying basic transformations. Basic functions required for transformations are available on both the platforms. eg. String functions, mathematical functions etc are found in both.
- Data service has much fore functionalities related to data cleansing activity. eg. Validate, Table Comparison, Map_operations etc.
Business Process Management:-
- Pi provides full workflow capabilities. System centric & Human centric workflows are possible in PI.
- Data service focus on system centric workflows only. In DS workflows are simple deals with process sequencing & error handling.
- Data service doesn’t support guaranteed delivery.
- PI supports guaranteed delivery with 2 options, Exactly One(EO) &Exactly Once In Order(EOIO).
- Asynchronous messaging (EO & EOIO) is based on WS standard.
- Both PI & BODS are capable of handling connectivity between SAP & non-SAP systems.
- File Handling, SAP Applications(RFC, IDOCs, Proxy), Legacy protocols(JMS), Databases.
- Database handling is the core functionality of BODS. It is able to extract tables in the complex manner.
- For EDI connectivity according industry standards PI is most suitable as EDI adapters are available in SAP PI.
- PI is positioned as a SOA middleware. It is the basis of SOA. You can create a web service from the interfaces used in PI.
- In PI you can publish your web services in service registry which is based on UDDI 3.0, where you can search, manage & consume the web services.
- BODS acts as service provider or consumer, but doesn’t offer further SOA functionality.
- The cost of using SAP PI as an integration tool is based on the overall processed message volume expressed in GB/month. SAP PI is free to use for integration between SAP to SAP systems.
- In BODS with one application we can cover multiple data management processes so it lowers TCO.
- So for SAP to SAP integration SAP PI is most suitable.
- And for data migration, cleansing & validation of data from source to target system BODS is most suitable.
Type of Integration:-
- For Service, Enterprise Application Integration & Business-Business(B2B) integration SAP PI is the best choice.
- For Data integration SAP BODS is the best choice.
- If user need to know the details about the number of materials created in an working unit then creating the web service for this purpose & consuming it across anywhere is the right choice & for this SAP Pi is the best option.
- Data service is the best option for data integration with SAP Netweaver BW, SAP HANA & entire Business Objects BI Platform. Data Services is the preferred tool for loading non-SAP data into SAP HANA. In fact, the data integration capabilities of Data Services are included with SAP HANA. Additionally, SAP is making major improvements for a seamless user interface between Data Services and SAP HANA.
- SAP delivers prepackaged integration content, which is created based on the SAP SOA design methodology. This business content includes global data types, service interfaces, and mapping definitions. IT professionals can use this predelivered content from SAP to jump-start their SOA implementations in SAP PI.
- Third party adapters are also available in SAP PI to meet particular industry standards.eg. EDI adapters by Seeburger
- In BODS all generation & data quality processes are developed & managed in a single interface i.e.” Data Service Designer”.
- In PI creation of Design & Configuration objects are separated in “Integration Repository” & “Integration Directory” respectively.
As we have seen the overlap between SAP PI & BODS we came to know that both are important tools & depending upon the business requirement, cost, available resources, connectivity options & data volume one would choose SAP PI or SAP BODS for their integration requirement.