Bind query parameter in database adapter in Oracle Integration Cloud Service
In this blog, we will show you how to use bind parameter in SQL query when use Oracle Database adapter. Bind parameters are required to get the result based on the […]
- Ankur Jain
- 19
- 8705
- November 5, 2017
Convert UTC Date & time to another timezone in Oracle Integration Cloud Service(ICS)
Oracle Integration Cloud provides date and time in UTC (Coordinated Universal Time) format. So some time is required to change the UTC to another timezone as per the requirement. Oracle […]
- Ankur Jain
- 4
- 4560
- November 5, 2017
Microsoft Contact Adapter in Oracle Integration Cloud Service (ICS)
Oracle ICS provided Microsoft Contact adapter that allows us to create an integration with a Microsoft Contact application. Microsoft Contact Adapter in an Oracle Integration Cloud Service enables us to transfer […]
Microsoft Calendar Adapter in Oracle Integration Cloud Service (ICS)
Oracle ICS provided Microsoft Calendar adapter that allows us to create an integration with a Microsoft Calendar application.Microsoft Calendar Adapter in an Oracle Integration Cloud Service enables us to organize events […]
- Ankur Jain
- 3
- 1096
- October 29, 2017
Microsoft Email Adapter in Oracle Integration Cloud Service (ICS)
Oracle ICS provided Microsoft Email adapter that allows us to create an integration with a Microsoft Email application. Microsoft Email Adapter in an Oracle Integration Cloud Service enables us to […]
- Ankur Jain
- 18
- 2675
- October 29, 2017
Convert Excel Exponential number in java
When we write the number in excel, it automatically converts in the exponential format and then try to get the values in Java using Apache POI API, it comes in […]
- Ankur Jain
- 2
- 3800
- October 24, 2017
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 […]
- Ankur Jain
- 2
- 1858
- October 24, 2017
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 […]
- Ankur Jain
- 3
- 1793
- October 23, 2017
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
- 4091
- 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
- 2618
- 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
- 2565
- 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 […]