About yeeloon-khoo

yeeloon-khoo

Hello CPI Integrators, This blog post focus on SAP CPI JDBC UPSERT operation, below videos show example on how to perform single upsert and bulk upsert, Direct SQL and stored procedure approach, and Splitter looping and Stored procedure XML Bulk Ups...

yeeloon-khoo

Dear experts,I'm referring concept from these 2 blogs to do Concur BPM and zipped SAE file processing.Here my progress so far:1) Start2) REST call to initiated SAE job3) Loop REST call until job status completed4) REST call get response zipped file w...

UDF Basic Building Block

Update 29-Apr-2015: Added 2 examples for get values based on another field that matched condition string.Update 27-Apr-2015: Added 7 examples for Handle leading and trailing zero and space trimming and padding, 2 example for Context handling.Update 2...

yeeloon-khoo

Introduction In PI B2B add-on, there are one set of ESR design objects called B2B Mapping Kit. Under namespace MappingFunctions have a set of function libraries. I personally find that these set of function libraries are very useful to handle var...

yeeloon-khoo

This post show a simple example of connection from source iFlow to BPM, call an Operation Mapping in BPM, then send output to target iFlow.The flow : a. Sender (BC_S1) send a text file contain message FirstNameLastName via sender file adapter to firs...

yeeloon-khoo

hi all, i found a workaround to load the metadata to OData V2 adapter:1) Open the $metadata in browser 1st, then save it as local file.https://services.odata.org/V2/Northwind/Northwind.svc/$metadataName it as any filename end with .edmx (example: Nor...

yeeloon-khoo

Hi Chaitanya, You looking for dynamically create table and columns based on input xml? Don't think this is possible, since example here those table and columns are fixed and already pre-defined, but just insert or update rows only.

yeeloon-khoo

Hi Marcelo, Not done in SAP Hana db/stored prodecure before, yes, syntax and way to handle xml is different between mssql and hana db. Tried check a bit, below might be relevant to apply same concept: Create local temp table in hana db: http:/...

yeeloon-khoo

Hi Daniel, I had added Figaf SAP CPI course as one of SAP CPI learning resource in this LinkedIn article about SAP CPI concepts and SAP CPI learning steps. Hope this is ok for you 

yeeloon-khoo

Hi Eng Swee, i had added this e-bite ebook by you and Vadim Klimov, as one of SAP CPI learning resource in this LinkedIn article about SAP CPI concepts and SAP CPI learning steps. Hope this is ok for you 

User Statistics

User Activity

SAP CPI - JDBC Adapter - Upsert Single & Bulk using Direct SQL, Splitter and Stored Procedure with XML Payload without Looping

Unable to unzip Concur REST calll zipped SAE file

UDF Basic Building Block

B2B UDFNodePool Explained in Easy Example

Step by Step Simple iFlow to BPM to iFlow and Calling Operation Mapping in BPM

Re: Invalid or missing namespace for 'Schema'

Re: SAP CPI - JDBC Adapter - Upsert Single & Bulk using Direct SQL, Splitter and Stored Procedure with XML Payload without Looping

Re: SAP CPI - JDBC Adapter - Upsert Single & Bulk using Direct SQL, Splitter and Stored Procedure with XML Payload without Looping

Re: Steps to learn SAP CPI, what you must know before your first project

Re: Learn to Develop Groovy Scripts for SAP CPI with Our New SAP PRESS E-Bite