One more interesting blog and sharing the knowledge and experience with you, about integration of SAP CPI and SQL JDBC to use batch mode and stored procedure. Maybe comes in your mind the question, why needs stored procedure ? If yes I will tell you later… I’m not going to explain deep the concept of....

For your migration project from SAP PI/PO to Integration Suite you can use the Figaf Tool to test your migration for free to allow you to run your migration project easier. This is our migration edition. Why should you be testing your migrations When moving between two platforms, there can be differences in how mappings, UDF....

Setting up connectivity between SAP S/4HANA Application and SAP PO application is a complex task with multiple steps to consider. As a BASIS or PO consultant it is important to understand how we can configure a S/4HANA server to interact with SAP PO/PI. This blog will provide information on how you can configure a S/4HANA....

In this blog, we will see how you can use postman, to test the SAP CPI mappings. You can use this approach for testing your groovy/xslt mapping as well if you find it useful. SAP CPI mapping simulation lacks more functionality where as SAP PO has better one. In SAP CPI there is no way....

Imagine you firstly installed PI 7.3 with ICo and wondered how it’s pretty simple to configure integrations. Moreover, you were using the same ideas and toolset as it was introduced to XI 2.0: 3D-addressing (party|system|iface) SPROXY and interface reusing in both PI & ABAP Enterprise Services Builder and mappings/context objects/etc from design-time Integration Builder with....

I recently investigated an issue in our PO system and learnt few useful things. I thought it will be useful for others to share it here: Issue In our PO system, every morning, we will open NetWeaver Administrator and go to “Message Monitor”. There we could see messages in Error and Successful status. When clicking....

SAP CPI (Cloud Platform Integration) and SAP PO/PI (Process Orchestration/Process Integration) are both integration platforms that help organizations streamline their business processes by integrating different systems, applications, and data sources. While both platforms offer similar functionalities, they have some distinct advantages that make them suitable for different use cases. Here are some reasons why you....

Recently, we had a requirement to generate the digital signature of payment file using PKCS#1 algorithm and push the signed file from SAP to Bank Server. Let us see the steps involved for this process in both PO and CI. RSA Key Pair Generation Before that, let’s walkthrough the key generation procedure. We need to....

As part of our software maintenance for PO JMS adaptor, we were upgrading the IBM MQ JMS jars from 8.0.0.2 to 9.3.2.0. i.e., com.ibm.mq.allclient.jar needs to be updated. After the upgrade, though message processing was successful, we were getting below errors while starting and stopping channels. Could not start communication channel due to an internal error Could....

After a long time without writing here I decided to take a few minutes to share some code that I recently used in a project and that I couldn’t find here in the community. Basically, the code I’m going to share has a simple and highly requested functionality in some projects, cleaning JSON messages, removing....

Test-driven development is a concept in the software development practice, where software development is closely tracked by repeatedly executing tests. In its pure form tests must even exist before the software itself. In this blog post, I’m going to show you step by step how Process Integration Test can bring you one step towards test-driven development....

Entre 08/02/2023 e 09/02/2023, a SEFAZ-SP fez algumas alterações de segurança nos webservices de NF-e do ambiente de Homologação. Infelizmente estas mudanças não foram publicadas pela SEFAZ-SP, e desde então nossos ambientes GRC NF-e não têm conseguido se conectar aos serviços para que possamos executar testes, impactando diversos projetos relacionados à NF-e aqui na empresa.....

While doing integration with some soap/rest receiver through SAP PI/PO, they may ask to do RSA signature and Base64 encoding for some of the fields. The soap/rest receiver should provide the private key to the sender.  When they receive any message with RSA signature by a private key, they will use their own public key....

inspired by the blog post “Useful XSLT mapping functions in SAP XI/PI“, I want to provide some more snippets. Hint: In general Java function calls are often not required anymore with XSLT 2.0, but makes life easier for some SAP PO capabilites, like DynamicConfiguration or AuditLog-Access. Prerequisite for xslt 2.0: You must have implemented the....

This blog is going to help in troubleshooting Versioning and Transport issues, along with few Best -Practices and the steps required to collect the information useful for root cause analysis at SAP side.   We can categorise the VNT issues into two : Database inconsistency issues while performing the actions like, Export/Import Create/Save/Activate/Delete Connectivity/Configuration issues....

ChatGPT is a language model developed by OpenAI. It is designed to understand natural language, generate human-like responses to a wide range of questions, and carry out various language-related tasks. It has been trained on a large corpus of text data and can understand a broad range of topics. Its purpose is to assist users....

During the implementation of OAuth 2.0 JWT Grant flow in SAP PI REST, I learnt lot of ins and outs about it and I hope through this blog you will have better insights into what to expect when configuring JWT Authentication for APIs which require it. There is another blog about DocuSign JWT Authentication for....

In today’s digital age, data security is of utmost importance, and securing data during transmission over the internet is critical. PKCS 7 Signer and Base64 Encoder are two technologies that are widely used to ensure data security during transmission. This blog will discuss both PKCS 7 Signer and Base64 Encoder, including what they are, how....

Dear SAP-community, The start of a new year is the best time to fuel your brain with SAP integration knowledge! Picture Credit: DALL·E 2   To get an extensive overview of various SAP integration technologies, I highly recommend reading “SAP Interface Management Guide” by Adam Kiwon (me), Mark Lehmann, Manuel Männle, Martin Tieves which is available in German and English. You will learn about....

B2BIC NRO is generally used in EDI scenarios where the requirement is to send document numbers to customers in series which is not possible in the case of IDocs because IDocs are not created in sequence per customer. Generally in B2B transactions, the flow is most likely IDoc to EDI via AS2/SFTP, etc. Where customers....

With NetWeaver 7.50 SP25, SAP PO/PI REST adapter provides support for OAuth 2.0 authentication on Sender side based on RFC 6749 “The OAuth 2.0 Authorization Framework” (https://www.rfc-editor.org/rfc/rfc6749 ).  This allows REST clients which support OAuth 2.0 Client Credentials grants flow to authenticate and access REST resources provided by the SAP PO/PI REST Adapter. This blog post....

As per new feature in CPI, we can create Message Mapping as Artifact and deploy before using in any integration flow.  There are already few blogs , where you can see how to create Message Mapping as Artifact and the limitations. SAP Cloud Integration – Message Mapping as Artifact | SAP Blogs In this blog,....

Why migrate ESR proxies? In order to work with ABAP proxies with SAP Process Orchestration we only had to define them in ESR and generate with transaction SPROXY on the SAP Backend system. If we are in a process of migrating from SAP Process Orchestration to SAP Integration Suite we need to consider that working....

Here is my experience of converting Microsoft Excel file to CSV file in SAP Process Orchestration. Open source Apache POI library is used to read MS Excel files. Maven pom.xml file <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.mycompany</groupId> <artifactId>JavaMapping_ExcelToCSV</artifactId> <version>1.0</version> <packaging>jar</packaging> <dependencies> <dependency> <groupId>manual</groupId> <artifactId>SAPPO</artifactId><!--Include com.sap.aii.mapping.api jar file.--> <version>1.0</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>5.2.2</version>....

PIPO OAuth Logs with XPI Inspector Recently, Microsoft has decided to postpone disabling Basic Authentication in Exchange Online for those customers still actively using it until the second half of 2021. In the meantime, Microsoft will continue to disable Basic Authentication for newly created tenants by default.  Starting in October 2020 they will also start to disable....

Business requirement: 1. Pull files from source folder (FTP or SFTP) folder and push it specific Azure-Blob-Storage folder location. 2. Read/Pull files from Azure-Blob-Storage folder locations Technique-01: Using PI/PO interface (FILE/SFTP TO FILE | Asynchronous) where Java Mapping is been used to push the files/Content into Azure-Blob-Storage location. Here, The Sender File or SFTP Adapter....

SAP SuccessFactors announced some time back the sunset of HTTP Basic Authentication for API calls. The sunset, which was planned for 2H 2022, was postponed until further notice. Nevertheless, SAP Process Orchestration SFSF adapter was enhanced to support OAuth 2.0 with SAML Bearer Assertion flow for OData API and SFAPI (see SAP Note 3111868 for more information).....

it is time to revisit the integration patterns surrounding your SAP systems. Knowledge about them reduces the friction during integration projects and proper application tremendously increases robustness of your interfaces. Question of the day: Do my patterns change when moving from SAP Process Orchestration (PO) or Process Integration (PI) to cloud native? Find out more on the next section👉🏿....

Recently I have worked in JMS(MQ) to Proxy scenario, in which I was facing special characters issue. Basically all umlaut chars such as ä,ö,ü are not displayed correct. I was not using any mapping as this is a pass through scenario.     When I download the file into my local machine and open with....

This blog explains how to delay the message processing when api call fails. This does not provide all detailed steps to consume celonis apis. Rather it discusses one part of the scenario.   Requirement This is a SFTP to REST(Celonis) scenario. Celonis has shared APIs for posting data from SAP PO. One restriction is SAP....

Ariba is one of the SAP products which is used in my organization (Oil & Gas Industry) as part of the Demand to Deliver (D2D) domain. A new module Ariba Guided Buying (AGB) was introduced and we need master data to be updated on Ariba portal as part of requirement. CIG is being used to....

This blog describes the use of CamelFilename header while zipping the files using Zip function  in SAP Cloud Integration ,Build number 6.27.9 ! When using zip function in sap cloud integration make sure to set the header CamelFileName  before the Zip function.Also  CamelFileName header should not be set explicitly in FileName parameter in SFTP Receiver Adapter. [ If set Dynamic....

As a Basis Administrator, many of the times we get requests from the developers to deploy EAR (Enterprise Archive) files in the SAP system.   These files can be deployed via many available tools provided by SAP and one of them is deploy via the telnet administrator tool.   Just for the reference to consultant,....

The company uses email authentication of staff to Linked Learning using Azure. There was a requirement to use the User ID (BizX ID) to update the course completion status from linkedin Learning into company LMS. So I had built interface to integrate LinkedIn Learning with LMS , do the necessary field mappings from Linkedin EmailID....

In my previous blog post, I have demonstrated how we can reset SAP password by just sending an email. But there were questions raised by many readers regarding UI, so today I will be explaining how we can beautify the user input. Our tool has now evolved to a semi-bot, you send an email and....

When we are doing HR or Bank related integration here main factor is data secure, so one of way is encrypt data using PGP keys. In this tutorial I am going to explore How to generate PGP Keys using Kleopatra Software How to Encrypt data using PGP Public key in SAP CPI How to Decrypt....

Generally for file based integration, SAP Process Orchestration File Adapter or SFTP Adapter is used to poll the data files from the file system or FTP/SFTP servers. But in some file integration scenario, the web server (Nginx, Apache, IIS etc.) is to be used instead of FTP/SFTP server in case that the FTP/SFTP server is....

SAP Integration Suiteは次世代のハイブリッドの連携基盤として、Cloud-to-Cloud、Cloud-to-Ground、Ground-to-CloudとGround-to-Groundなど連携シナリオを全面的にサポートしています。 SAP Cloud Integrationで開発したIntegration Flowは、以下の３種類のRuntimeにデプロイして、実行することが可能です。 ①. Integration Suite メインな実行環境として、Cloud-to-Cloud、Cloud-to-Ground、Ground-to-CloudとGround-to-Groundシナリオで利用可能 ②. Cloud Integration Content Runtime SAP Process Orchestration 7.5上に動かすCloud Integraionの実行環境として提供され、 Ground-to-CloudとGround-to-Groundシナリオで利用可能 ③. Hybrid Deployment Option オンプレミス上のスタンドアロンの実行環境であり、Ground-to-CloudとGround-to-Groundシナリオは利用可能。2022年Q4にBeta版がリリースされる予定です。(最新のリリース予定はSAP Road Mapをご参考ください。) 本ブログは、②.Cloud Integration Content Runtime on Process Orchestrationの機能概要について、ご紹介します。 利用環境 Cloud Integration Content Runtime on Process Orchestrationは、SAP NetWeaver 7.5 SPS05以降で提供されるコンポーネントであり、以下のインストレーションタイプがサポートされています。 Advanced Adapter Engine Advanced Adapter Engine Extended SAP....

Logical prerequisites You have a SOAP to RFC Synchronous scenario and want to use SOAPUI for testing purposes. During testing procedure you receive a error from SAP PO. Something like this: <SOAP:Fault>          <faultcode>SOAP:Server</faultcode>          <faultstring>Server Error</faultstring>          <detail>             <s:SystemError xmlns:s=”http://sap.com/xi/WebService/xi2.0″>....

This is my first blog where I would like to share my experience on how to connect with SFDC via REST adapter using SFDC bulk API concept. (without BPM) When to use Bulk API? Bulk API is based on REST and is optimized for loading or deleting large sets of data. We can query, insert,....

You are at Mapping Guidelines (MAG) When you map a source group node to a target group node. And then map a source leaf node to the same target group node. It automatically creates a “conditional mapping”. What is this feature? Let’s have a look at it. As defined on the help page: Group node: A....

We’ve recently had a requirement to set base64 PDF to PDF attachment in message mapping. When looking online for an existing UDF to set PDF attachment in message mapping, most UDF’s found were using JAVA mapping or were created for other requirements (for example changing PDF filename when using sender file adapter). This UDF is....

In this blog post you can learn, which configuration is required if you want to protect objects, which are generated during integration flow deployment. Imagine following situation. As a rule you configure your PI using integration flows and made your changes in the Integration Designer. When an integration flow is deployed an integrated configuration and,....

Introduction: This Blog will guide you how to define multiple receiver and Xpath routing condition in SAP PI/PO. Requirement: To send the data from a single source system to multiple target systems. Steps: This can be done by validating the input data from the payload (identifier to route the messages to respective target). First you....

EDIFACT messages require a total segment count in the segment UNT. X12 messages require the same information in segment SE data element 96. In SAP Process Integration/Orchestration(PI/PO) this requirement was handled by mapping the constant $B2B_SEG_COUNTER to the relevant field. SAP Cloud Integration doesn’t have this feature yet, but we can create a Groovy script that replicates exactly the same behavior.....

Hi All, In this blog you will learn about how to configure alerts in NWA What is an alert? An alert is a notification that there is a failure/error in system and action needs to be taken to resolve that failure/error. We can configure alerts through Integration builder as well as SAP NWA. I observed....