SAP PI/PO - Config JDBC Receiver

 








Popular posts from this blog

SAP CPI - Loop Process Call with SuccessFactor (oData V2)

Image
This example will show you how to fetch data from SuccessFactor (oData V2 Message Protocal) with a specific page size. For example, if your data has 10,000 total records and each record consists of 20 child nodes (the result size is around 10MB), you can fetch data by 500 records per request by using Loop Process Call. # My integration process consists of 1. Content Modifier " Initial Data " which I declare property "fetchData". 2. Loop Process Call " Loop Fetch Data " which calls Local Integration Process " Fetch Data From SF ". 3. Groovy Script which writes data from property "fetchData" in an attachment format. This example will focus on step 2 - Loop Process Call & Local Integration Process. # Local Integration Process "Fetch Data from SF".  How does it work? 1. Use Request Reply to call SuccessFactor to get data 500 records per request. 2. Use Groovy Script to get some fields and return in XML format. 3. Use XML to CS...
Read more

SAP Cloud Platform Integration - Splitter

Image
  This example will show you how to use General Splitter to divide a big XML message into several small messages. The main process we need to focus on is the local integration process, "Split XML", which has a General Splitter inside and ends with Gather to combine a result of each split message (after the process) together. # General Splitter 1.  Expression Type: I use XPath  because the results from the SuccessFactor are an XML. 2. XPath Expression: XPath of the node that marks each split the message (Including root node) 3. Grouping: The number of records in the 1 split message 4. Streaming: Enable this if you want to start splitting before the entire big message is loaded into memory. The system will first divide the message into chunks and starts splitting the chunks into split messages. This is only relevant if the splitter is the first step after the step that fetches data – otherwise, the content would have already loaded in memory. # Gather After you proces...
Read more

C# - MD5 in BASE64

public String encriptStringByMD5(String input) {      String output;      //The encoder class used to convert strPlainText to an array of bytes      Encoding enc = Encoding.GetEncoding("windows-874");      //Create an instance of the MD5CryptoServiceProvider class      MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();      //Call ComputeHash, passing in the plain-text string as an array of bytes      //The return value is the encrypted value, as an array of bytes      Byte[] hashedDataBytes = md5Hasher.ComputeHash(enc.GetBytes(input));      output = Convert.ToBase64String(hashedDataBytes,0,hashedDataBytes.Length );      //output = BitConverter.ToString(hashedDataBytes);      return o...
Read more