Category: Adapter

Send a payload as an attachment in SAP PI

Editor Leave a comment

This article will explain how to use the receiver mail adapter to send a payload as an attachment in SAP PI.

There could be several scenarios where we need to use mail with attachments in sap pi. Some of the cases are as follows:

  1. Sending files over email scenario.
  2. As an alert – If data in the file is missing send the file to the concerned team for correction and re-trigger.

Let’s consider the alerting example.

Business scenario: If an incoming XML file is missing data, PI must route that file as an attachment and send an email to the appropriate teams for correction.

This can be accomplished through Java mapping, which I believe is a cleaner approach, but for the purposes of this blog, I will use UDFs because not all PI consultants are Java savvy.

The focus of this blog will be on the mail adapter and how to send a payload as an attachment. For more on the mail adapter scenario check the blog SOAP To Mail Scenario in SAP CPI

Read More

SFTP Adapter in SAP CPI

Editor Leave a comment

This article will walk you through the entire process of configuring the SFTP adapter in SAP CPI. In this blog, we will go over Sender and Receiver SFTP configuration in SAP CPI.

Let us illustrate this with a simple scenario:
Pick the file from SFTP and place it in the SFTP folder.

SFTP adapter in SAP CPI

Read More

Dynamic File Name in SAP CPI

Editor 1 Comment

This blog will explain how to configure dynamic file name in SAP CPI. This can be used for the sap cpi FTP/SFTP receiver adapter.

Refer to the blog to learn about basic SFTP adapter configuration in SAP CPI.

We are all aware of how Dynamic Configuration works in SAP PI.  This blog post will show how to achieve dynamic configuration in receiver SFTP adapter in SAP Integration Suite (aka CPI).

Let’s take a look at a simple requirement: set the target filename dynamically based on a key field in the incoming message.

Read More

SOAP Adapter in SAP PI

Editor Leave a comment

In this blog, we will discuss the configuration of the SOAP Adapter in SAP PI. The SOAP adapter enables communication with PI/PO via web services.

This article will cover the configuration of the SOAP sender and SOAP receiver adapter.

SOAP Sender Adapter Configuration

You can create web services within SAP PI/PO and consume them in external applications. In this case, you will need to configure the sender SOAP adapter.

Read More

Error Handling in REST Adapter – SAP PI

Editor Leave a comment

This blog will show how to do error handling in REST Adapter. The REST adapter supports Custom Error Handling when used as Sender or receiver.

You can use a custom error handling to define how the adapter will react to certain error codes with custom result messages. Besides, you can create error conditions based on the content of the message data.

In this example when PI will have a mapping error, it will send the custom message as a response to the user. This is simple error handling but it should be good to understand the mechanism.

Read More

REST Adapter with Multiple Operations in SAP PI

Editor 2 Comments

This blog will show how to use REST Adapter with Multiple operations in SAP PI. Here we will expose the API with multiple operations for which REST sender will be used.

Flow:

REST Adapter with Multiple Operation Flow

As shown in flow diagram PI will expose the REST API with 2 operation addition & subtraction.

I will recommend going through the Sync/Async scenario using the REST adapter before starting into multiple operation configurations using the REST adapter. That will provide a good REST adapter background.

Async Scenario using REST Adapter Scenario in SAP PI

Sync Scenario using REST adapter in SAP PI

Read More

Sync Scenario using REST adapter in SAP PI – Part II

Editor Leave a comment

This blog is a continuation of the sync scenario using the REST adapter in SAP PI. Here we will cover the configuration steps for JSON format.

In case you want to read about XML format here is a link to 1st part of this blog Sync Scenario using REST adapter in SAP PI – Part I

Scenario :

REST adapter can be used for consuming a REST service or exposing a REST service in PI. This blog will cover only exposing of REST service for which Sender REST Adapter will be used.

Flow:

REST<–> SAP PI<–>SOAP ( calculator service)

It will be a synchronous scenario where the request will send to PI and response will be received based on the operation (Add, Sub, Divide or multiple).

To keep it simple we will only work with add operation, for multiple operation check this guide REST Adapter with Multiple Operations in SAP PI

In case you are looking for Async example here is a step by step guide REST Adapter scenario in SAP PI – JSON/XML

Read More

Sender REST Adapter Scenario in SAP PI – Part I

Editor Leave a comment

This blog will cover the step-by-step guide on how to create the Sender REST Adapter Scenario in SAP PI. It will cover all the configuration steps of the sender REST adapter.

Scenario :

REST adapter can be used for consuming a REST service or exposing a REST service in PI. This blog will cover only exposing of REST service for which Sender REST Adapter will be used.

Flow:

REST<–> SAP PI<–>SOAP ( calculator service)

It will be a synchronous scenario where the request will send to PI and response will be received based on the operation (Add, Sub, Divide or multiple).

To keep everything simple in this blog I will cover only Add operation and next blogs I will show how to use multiple operations in the REST adapter.

In case you are looking for Async example here is a step by step guide REST Adapter scenario in SAP PI – JSON/XML

Read More

Adapter Series: JDBC Adapter in SAP PI 7.4/7.5

Editor Leave a comment

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