XML to JSON conversion in REST adapter SAP PI

This blog will explain how to handle XML to JSON conversion in REST adapter. Here we will cover enhanced REST adapter settings to handle array – repeated segments.

How REST Adapter converts

REST adapter uses 3rd party Jettison library for JSON processing tasks. It is used for conversion of XML to JSON & vice-versa and sometime it does not correlate or take into consideration payload field properties as defined in a corresponding message type, but has its own optimization and type derivation mechanisms that are based on nature of the value of a processed XML document’s element rather than XSD schema of a processed message.

As a result, sometime conversion are not correct especially in case of XML element as an array.

Read More

Adapter Series: JDBC Adapter in SAP PI 7.4/7.5

JDBC scenario’s in SAP PI are most common and in this blog, we will talk about how to configure Sender and Receiver JDBC Adapter in SAP PI.

The JDBC adapter enables you to connect database systems to the Integration Server. The adapter converts database content to XML messages and vice-versa.

You can read database content with any SQL statement and even stored procedures.

Read More

SAP Ariba Integration Using SAP PI 7.5

 

This blog will provide step by step guide on SAP Ariba Integration using SAP PI 7.5. In this case Ariba is on cloud so it will be integrated with on premises SAP ERP system.

SAP Ariba can be integrated through the following methods

  • File-based integration
  • Web services
  • Direct connectivity
  • Mediated connectivity

In this blog we will cover Web service based integration of Ariba Cloud using SAP PI 7.5 (Single Stack). The Web services is provide for real-time integration of the Ariba Procurement Solution with SAP ERP using SAP Process Integration.

Read More

Enable sync scenario response payload in SAP PI 7.4 (Java Only)

This article will provide steps on how to enable sync scenario response payload in SAP PI. By default, synchronous scenario logging and staging is disabled to avoid consumption of resources.

But in case of errors in response mapping and for debugging we might need to understand data coming in response messages.

Two options are available to enable sync scenario response payload

  1. Global setting: this will enable staging of payload for all interfaces
  2. Local setting: this has more advantages as this can be handled from ICO and is very specific to the interface.

Read More

Synchronous timeout exceeded error in sap pi

A lot of time working on the synchronous scenario we see timeout exceeded error in sap pi.

Usually, to overcome this error we need to set the Java parameter in NWA but after SAP PI 7.31 we have the option of setting timeout parameter on the channel itself. This remains specific to that interface which has more advantages of not touching timeout parameter in global settings which affects all interfaces. It is very simple now to set the parameter in adapter module if we get synchronous timeout exceeded error in sap pi.

Read More

Alert configuration in sap pi 7.4/7.5 single stack

This blog will walk you through the process of configuring alerts in SAP PI single stack. The new alerting system differs from the old way of configuring it by using ALRTCATDEF tcodes. This seems simpler and quick to me, and the fact that we can now set alerts based on interfaces gives us more flexibility and usability, so let’s get started on the alert configuration in sap pi single stack.

Overview of the Alert Process in SAP PI:

Discover the power of proper alert configuration in SAP PI single stack. Whenever a message error occurs in PI, an error status is recorded. The Alert Engine then evaluates the error information or alert events from the PI runtime and checks for matching Alert Rules and configurations to determine if an alert should be generated. Proper configuration of alerts can greatly influence the generation of alerts. Join me as I guide you through the process of configuring alerts in SAP PI single stack.

Read More

messages stuck in delivering status SAP PI

SAP PI messages overview sometime shows messages stuck in delivering status but actual status might be wrong.

Messages on the Adapter Engine are stuck in a wrong status in the Message Overview or the counter shows a number that is different from the actual number of XI/PI messages on the database. E.g. the page shows some messages that are in a scheduled status.

Read More

REST Adapter scenario in SAP PI – JSON/XML

This blog will provide a step-by-step guide on how to configure the sender REST adapter scenario in SAP PI. This document will help the PI developer/consultant who will like to learn about the Sender REST adapter configuration.

I will explain this by creating a simple asynchronous scenario REST –> PI –> File. usually, REST will be used for sync scenario but to provide

Usually, REST will be used for sync scenarios but to provide a basic understanding of how to configure REST adapter I am using Async.

In case you are interested in sync scenario here is a step by step guide Sync Scenario using REST adapter in SAP PI

REST Adapter scenario in SAP PI

Rest enabled application will send JSON format to SAP PI which will be converted into XML using REST Adapter.

Read More

User defined message search in SAP PI 7.31/7.4/7.5 (Java Only)

This blog will provide steps by step guide on how to configure user defined message search in SAP PI (Java only installation)

As of PI 7.3 we have a new way to configure and use content based message search in SAP PI and this article will explain the steps how to configure User define search.

For steps on how to configure payload based search in SAP PI dual stack follow the link below

Payload based search in SAP PI

Read More