Posts

Showing posts from December, 2020

Replace Existing Connection with New Connection in OIC Integration

Replace Existing Connection with New Connection in OIC Integration :   News :   😇 This article published in  October 2020 Edition of Oracle PaaS Partner Community Newsletter New update in OIC allow us to repl...

Replace Existing Connection with New Connection in OIC Integration

Replace Existing Connection with New Connection in OIC Integration :   News :   😇 This article published in  October 2020 Edition of Oracle PaaS Partner Community Newsletter New update in OIC allow us to repl...

Replace Existing Connection with New Connection in OIC Integration

Replace Existing Connection with New Connection in OIC Integration :   News :   😇 This article published in  October 2020 Edition of Oracle PaaS Partner Community Newsletter New update in OIC allow us to repl...

Send a asymmetric/heterogeneous file to sFTP in OIC

Image
How to send a asymmetric/heterogeneous file into sFTP in OIC? In this post I have explained how to write a asymmetric or heterogeneous file to sFTP in OIC. Heterogeneous file means the file contains different columns in header, body and footer sections. e.g. Steps overview -  Create the file stage write for each type of row in the file one by one in append the existing file mode. Use a broken sample file for each type of row in the file i.e. one file each for each section of the records in the file. Finally use the file reference from the final stage write file to send the entire file to the required sFTP location. # Hands On Practice : Use Case : Lets develop a simple schedule orchestration integration to write a heterogeneous file in a sFTP location. Step1: Create a scheduled orchestration vis HeterogeneousFileWrite. Step 2:  Add a stage write activity with the first type of record i.e. header record in the sample file and map the desired values. Step 3: Add second stage wr...