Course Highlights
  • Develop end-to-end real-world CPI interfaces
  • CPI connectivity, routing, design, mapping technique/example
  • Various CPI steps and their usage together with hands-on examples
  • For more detail please see course description
Curriculum

3 Topics
Setup CPI Trial Account with Basic Authentication
Add Role Integration_Provisioner if Get Error: Looks like you do not have access
How Long will CPI Trial Account Last and How to Renew Extend Forever

2 Topics
Install Java SDK 8 Groovy Lib CPI Lib and IntelliJ IDEA
Configure IntelliJ IDEA for Local Groovy Script Development and Unit Test

3 Topics
Say Hello using Body
Say Hello using Header and Property
Say Hello using XPath

4 Topics
Get Northwind Customers using HTTP Adapter
Get Northwind Customers using OData Adapter and Comparison with HTTP Adapter
Post to Create Northwind Product using HTTP Adapter (JSON and XML)
Post to Create Northwind Product and Supplier using OData Adapter

2 Topics
Call Calculator Web Service using SOAP Adapter
SoapUI Call to CPI then Call to Calculator Web Service

4 Topics
Convert JSON To XML
Convert XML to JSON
Convert CSV to XML
Convert XML to CSV

2 Topics
Router - Go to Different Routes based on Condition
Router - Go to Different Routes based on Condition then Back to Single Route

5 Topics
Multicast - Same Message Go to Multiple Routes
Multicast - Same Message Go to Multiple Routes then Join Gather Back All Message
Multicast - Change from Sequential Multicast to Parallel Multicast
Multicast - Same Message Go to Multiple Routes Manually Without Multicast
Multicast - Example Call 4 Webservices in Parallel and Gather Result Back

6 Topics
Splitter - Example 1 - Iterating Splitter using XPath
Splitter - Example 2 - General Splitter using XPath
Splitter - Example 3 - General Splitter using XPath and Nested Splitter
Splitter - Example 4 - XPath with Namespace
Splitter - Example 5 - Splitter with Line Break
Splitter - Example 6 - Splitter with Token

8 Topics
Groovy Mapping - Get Set Header Property & Body using CPI Web IDE
Groovy Mapping - Get Set Header Property & Body using IntelliJ IDEA
Groovy Mapping - Map IDOC to Flat XML and Tree XML
Groovy Mapping - Map IDOC to Flat JSON and Tree JSON
Groovy Mapping - Map JSON Tree to IDOC
Groovy Mapping - Map IDOC and JSON Tree to CSV using SuperCSV Library
Groovy Mapping - Convert CSV to Flat XML for Both Known and Dynamic CSV Fields
Groovy Mapping - Map to Northwind Raw OData Batch Payload

9 Topics
Create First Simple Message Mapping and using Standard Functions
Simplify If Else Condition using FixValues Conversion
Create and Perform Value Mapping Lookup Conversion
useOneAsMany Explained in Easy Example
Troubleshoot useOneAsMany Errors & Handle Null Missing Data using mapWithDefault
Multiple IDOC to XML Tree by Select Field using ifSWithoutElse & formatByExample
Multiple IDOC with 3 Level Depth to XML Flat using useOneAsMany
collapseContext and formatByExample to Map Flat XML to 3 Level Depth IDOC
How to Download Upload Copy Rename and Reference Message Mapping in iFlow

4 Topics
Handle Binary Files using Base64 Encoder and Base64 Decoder
Zip and Unzip Single File and Set Filename inside Zip
Zip Splitter to Split Multiple Files inside Zip then Send Files to SFTP Server
Zipping Multiple Files to Single Zip using Gather with Zip Aggregation

4 Topics
Looping Get All Northwind Products using OData V2 Adapter
Looping Get All Northwind Products using OData V2 Adapter & Looping Process Call
Looping Get All Northwind Products using OData V4 Adapter
Looping Get All Northwind Products using HTTP Adapter

3 Topics
Enrich Source XML with Lookup XML using Content Enricher and OData Adapter
Enrich Source XML with Lookup JSON using Content Enricher and ProcessDirect
Enrich Source JSON with Lookup JSON using Groovy Mapping

4 Topics
Define Exception Subprocess and Get Exception Message & Stack Trace
Get HTTP & OData Response & SOAP SoapFault Response Body and Build Alert Body
Reuse Same Logic in Exception Subprocess for Multiple Local Integration Process
Different Ideas to Handle Exception of SAP CPI

5 Topics
Understand Usage of Public Key and Private Key in PGP Encryption and Signing
Create OpenPGP Private Key & Public Key using Gpg4win then Import to SAP CPI
SAP CPI PGP Encrypt and Sign then Partner PGP Decrypt and Verify
Partner PGP Encrypt and Sign then SAP CPI PGP Decrypt and Verify
Tips to Troubleshoot & Workaround for OpenPGP and GnuPG Compatibility Issue

6 Topics
Read Write Northwind Last Processed Order Id using Local Variable
Read Write Global Variable using Postman
Write All Northwind New Order Id to DataStore DS_OrderNew
Get Single Entry from DataStore DS_OrderNew & Write to DS_OrderProcessed
Read Multiple Entry from DataStore DS_OrderNew using Get Operation and Splitter
Read Multiple Entry from DataStore DS_OrderNew using Select Operation

8 Topics
Setup On-Premise SFTP Server with Username and Password
Setup SAP Cloud Connector connect to SAP CPI and On-Premise SFTP Server
Connect SAP CPI to On-Premise SFTP Server using CPI Public OpenSSH Key
Move File From Source SFTP Folder and Send to Target SFTP Folder
How to Archive Processed File in SFTP with Timestamp using Sender SFTP Adapter
How to Move SFTP Source Files with Sub-Directories to Target & Flatten File Name
Pickup SFTP Source Files based on File Name Pattern & Write to Different Folder
Get SFTP File using Poll Enrich Step and Keep File for Next Process Again

9 Topics
Setup Own Free Local Microsoft SQL Server and Link to SAP Cloud Connector
Configure CPI JDBC Driver & Data Source and Select Records From Database Table
SELECT using Direct SQL and XML SQL and SQL_QUERY with Parameters
INSERT using Direct SQL and XML SQL and SQL_DML with Parameters
UPDATE using Direct SQL and XML SQL and SQL_DML with Parameters
DELETE using Direct SQL and XML SQL and SQL_DML with Parameters
UPSERT Single & Bulk using Stored Procedure with XML Payload and Temp Table
Performance for Upsert Each Row using Splitter vs Upsert using XML Bulk Upsert
How to Use Same JDBC Data Source Multiple Times in Same IFlow

7 Topics
Setup Local Free Solace PubSub+ Event Broker and Link to SAP Cloud Connector
Quick Intro on PubSub+ Services Clients Queues & Basic Authentication
Quick Intro on Topics and Topic Subscriptions
CPI Send Message to Event Broker using Queue and Topic
CPI Consume Message from Event Broker by Queue
Retry Mechanism in AMQP Sender Adapter and DMQ (Dead Message Queue)
Retry Message from (RetryParkingWaiting DMQ) with Delayed Delivery

  Write a Review

Beginners: Learn SAP CPI with Hands On & Practical Examples

Go to Paid Course