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

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

Search IDOC based on data

There could have been times specially in production support, when one was needed to search and find particular idoc. We might know the values contained in the fields of the segments but not sure of the idoc . This document will provide step-by-step guide on how to search IDOC based on data.

SAP has provided standard TCode – we10 to search IDOC based on content of any segment/field.

Read More

Sort by key in SAP PI

This blog will provide step-by-step guide on how to sort by key in SAP PI. Sometime we get the requirement where incoming data is not properly sorted and data need to be in proper order while sending to target system.

I have listed 2 option here which can be used in SAP PI depending on requirement and structure.

Read More

SAP UI5 Tutorial Part 1 : How to Setup SAPUI5 Development Environment

This blog will provide step by step guide for How to Setup SAPUI5 Development Environment.

Follow below steps.

Java Installation

Java Development Kit is the package for developers, which includes complete runtime tools for developing, debugging and monitoring the Java Applications. You can download the latest Java version from the following site Java Download

  • Run the installer once the download is complete.

For Mac – This is an automatic installation and the paths are setup no need for any separate settings.

For Windows – You need to set your Path in the Environment Variables.

Read More

File to IDOC Scenario in SAP PI 7.31 (AEX- Java Only)

This blog will provide the details steps involved in File to IDOC scenario in SAP PI 7.31 (Process Orchestration JAVA Only Environment)

Prerequisites:

  1. Connection Details to be available in SLDAPICUST for PI
  2. Update the SLD Data of ECC ABAP System.

Enterprise Service Repository:

All the Steps are same as any PI Version (7.0, 7.1, 7.11 etc  ABAP + Java environment). There are no changes in this.

  1. Create a Message Interface for File Interface (Outbound).
  2. Import the IDOC from ECC for Receiver Interface.
  3. Message Mapping and Interface Mapping to be done for Source and Target Message.

Read More

How to Test AS2 Adapter in SAP PI

When I was developing scenario using AS2 adapter I didn’t have idea on how to Test AS2 Adapter in SAP PI. Then I come across a very good open source tool Mendelson AS2 software which can be used for End-to End testing of AS2 Adapter in SAP PI.

Mendelson AS2 software: is available free download in below link, http://sourceforge.net/project/showfiles.php?group_id=163866 It does not require local admin rights  to install (runs with Java).

Read More