Split a CSV file into multiple based on a column in OIC
When I was implementing AP Invoices FBDI Integration for one of my clients, I noticed that they were providing Invoices of all Bussiness Units in a single file, But during […]
Merging two CSV files into a single file in Oracle Integration
In this article, we are going to demonstrate how to merge the content of two CSV files (that don’t have a common field) into a single CSV file in Oracle […]
Secure files PGP (Part-2-Decryption): Oracle Integration Cloud
This is the second part of transferring the secured file over SFTP in Oracle Integration Cloud. In the previous blog, we showcased how to create encrypted files using Pretty Good […]
Securing files using PGP encryption (Part-1-Encryption): OIC
Security is one of the aspect when we are dealing with Cloud platform. Specially when we are transfering files over the public SFTP from cloud paltform. OIC allows securing files […]
How to create ZIP file in Oracle Integration Cloud
Are you keen to know how to create Zip file in Oracle Integration Cloud (OIC)? Zip file creation is one of the key aspect of ERP based related integration. […]
List files from FTP reside in multiple directories: OIC
The FTP Adapter enables the integration of the File Transfer Protocol (FTP) and the Secure Shell (SSH) File Transfer Protocol (sFTP) into Oracle Integration Cloud Service. Using the FTP Adapter, […]
Integration between FTP – Sharepoint (Upload documents): Oracle Integration Cloud
In this article, we’ll show how to pull the file from the FTP location and upload to the SharePoint repository. To complete this article we should have followings: Sharepoint REST […]
Copy files from one SFTP to another in OIC
There are scenarios where we want to copy files from one SFTP location to another in Oracle Integration Cloud. In this article, I will show you how to copy files […]
Read CSV file with Delimiters other than specified in the FTP adapter: Oracle Integration Cloud
In one of my article, we showcased how to read CSV file using FTP adapter which is comma separated. Integration Cloud FTP adapter allows below delimiters file to be processed […]
Poll File from Agent server leveraging File Adapter: Integration Cloud
Oracle Integration Cloud provides a File adapter to deal with the files which reside on the local server. File adapter allows following operations on an on-premise location, using Integration Cloud connectivity […]
File vs FTP adapter in Oracle Integration Cloud
There are two inbuilt adapters offered by Oracle Integration Cloud. One is File and another FTP. Users often confused about when to use File and when to use the FTP […]
Read ZIP files in Oracle Integration Cloud
We all know the capabilities of Oracle Integration Cloud FTP adapter of reading and writing files. There are situations where the files are in the zip format and required to read […]