How to Read Excel Files in Java using Apache POI
In this blog, we will show you how to read excel file using Apache POI (Poor Obfuscation Implementation) library which is very popular amongst the available library. Apache POI library Apache […]
Move Oracle ICS integration from one instance to another
This is very important and useful blog for those who wants to move integration from one ICS instance to another ICS instance. Following are the typical use cases when it […]
Uploading SSL certificate in Oracle Integration Cloud Serive
Certificates are used to validate outbound SSL connections. If we make an SSL connection in which the root certificate does not exist in Oracle Integration Cloud Service, an exception is […]
- Ankur Jain
- 8
- 1660
- October 23, 2017
Last Run Date and Time in Oracle ICS (Integration Cloud Service)
Sometimes it is required to get last run date and time of the scheduled integration to avoid the duplicate processing of data. This is possible in the Scheduled Integration type. […]
- Ankur Jain
- 4
- 1179
- October 20, 2017
Exception handling(Global Fault Handler) in Oracle ICS
Oracle Integration Cloud Service provides “Global Fault Handler” to catch faults in orchestrated integration and perform actions.We can add global fault handling to orchestrated integrations. This functionality enables us to […]
- Ankur Jain
- 12
- 1221
- October 9, 2017
Java Regular Expression
Some useful java function that may help me in the java project Convert List of integer into any literal separated string public static String joinList(List<Integer> list, String literal) { return […]
Read large CSV file in Integration Cloud Service
I was trying to achieve one use case in which we are required to read large CSV file from FTP which is more than 1 MB. We was using FTP […]
- Ankur Jain
- 10
- 1012
- October 3, 2017
Export and Import Oracle Integration Cloud Service Components
How to move Integration from one ICS instance to another ? This is general question and can come in mind of every single person who is working with Oracle ICS. […]
Reading file from remote server using SFTP connection
Below is the program that shows how to read file from SFTP server using java JSch API is widely used for connecting a SFTP using Java. Download JScp library from […]
Import CSV file to create Lookup Oracle Integration Cloud Service (ICS)
In the previous two blogs, I have described the ICS Lookup and how to create Lookup. Oracle Integration Cloud Service Lookups User Lookup in Oracle Integration Cloud Service Let’s […]
HTTP Basic Auth VS WS-Security username token authentication
HTTP Basic Authentication and WS-Security username token authentication both are different authentication mechanism and independent to each other. Let’s go in depth and see how both the mechanism differs HTTP […]
SOAP adapter in Oracle Integration Cloud
Simple Object Access Protocol(SOAP) adapter in one of the powerful adapter provided by Oracle Integration Cloud Service(ICS). The SOAP adapter can consume any external SOAP API in an ICS. Service […]