Author: Phil Wilkins Page 7 of 8

-- I work for Oracle, all opinions here are my own & do not necessarily reflect the views of Oracle -- Oracle Ace Director Alumni
TOGAF 9 Certified Architect
- https://blog.mp3monster.org

The book’s authors presented a brief session on the best practices at a packed Oracle Partner event. The following presentation – shows the material that was presented.

Some of these points are expressed in the book already, others are our Definitive Tips and Guides posts.

Applying configuration management and related dev practises – ICS Definitive Guide #3

By Phil Wilkins

On March 22, 2017

In Definitive Guides

Good development practises such as configuration management and naming conventions have been a topic of conversation a number of times recently for us when it comes to ICS. In this post we will look at what configuration management means to ICS and the application of naming standards.

Why Configuration Management?

So why do we need configuration management with a tool such as ICS? The question depends on what stage of the software lifecycle you are, but a few reasons:

As a developer there have been occasions where we have tried to optimise something and then decided to reverted back to the last secured state in configuration control.
Deleted something and then regretted it, whilst desktops have the concept of paper basket to recover from, not so in ICS.
If your providing packages of ICS functionality you may have different released versions – so need to keep master copies of every version available to refer to.
Sometimes we get ‘configuration drift’ – and therefore need to have a reference point to compare to. This allows us to determine the drift and if it is appropriate to reset an environment. Whilst this may sound less significant, it is enough of a problem for tools like Puppet to incorporate the ability.
Tracking what versions of integrations are running in a development vs production environment.

Using iCal in Scheduling – ICS Definitive Tip #3

By Phil Wilkins

On February 23, 2017

In Definitive Tips

In ICS Definitive Guide #2 we looked at the scheduling of integrations and mentioned the possibility of using iCal. In this tip we shall explore advanced iCal facility for defining schedules within ICS.

The iCal format is probably best known for sharing meeting events in tools such as outlook. The format is actually a standard defined by the IETF originally in 1998 (https://www.ietf.org/rfc/rfc2445.txt) and updated several times the latest being 2015 (https://tools.ietf.org/html/rfc7529). The goal of the definition has been for the purpose of driving standardisation across PIM tools (Personal Information Management) tools which includes Outlook and Thunderbird etc. It is a substantial standard the original document ran to 150 pages, but the section supported by the schweduler’s advanced option purely relates to the reoccurence definition covered by section 4.3.10 of the original RFC, and only takes five pages. If you want to know lots about iCal and the varying revisions then you may find https://icalendar.org/ helpful.

It is worth mentioning that today ICS under the hood exploits Oracle’s Enterprise Scheduler Service (ESS). ESS documentation identifies that it works to the 2445 version of the specification (see here). ESS became a 1st class citizen component with the start of the 12c middleware product stack. As a result, if you see any errors processing an iCal configuration the error codes will reference ESS does.

Using Integration Versioning – ICS Definitive Tip #2

By Phil Wilkins

On February 9, 2017

In Definitive Tips

In this Definitive Tip, we are going to look at the ability to use Versioning on Integrations to seamlessly deploy update integrations is an important requirement of any enterprise integration platform.

ICS supports the model of semantic versioning, perhaps better recognised as versioning as Major, Minor and patch. Which is best described at http://semver.org/.

This post will demo a minor and then a major version change. So we can see how change as the behaviours change between the two. A major change indicates an likely change in definition and minor one reflects logical change.

Seeing Versioning in Action

To demonstrate versioning we need an integration that is currently active. Ideally, you will have some sort of data feed or test framework, such as SoapUI or even a simple cURL script regularly triggering the integration. We need this script running to demonstrate the impact of the cutover.

Designer Content Filters – ICS Definitive Tip #1

By Phil Wilkins

On February 1, 2017

In Definitive Tips

Definitive Tips, like our Definitive Guide posts address features could not be incorporated into the book, either simply because the feature is new or simply down to the fact the new feature arrived since the book has been published. Unlike the Definitive Guide entries, the tips will always remain very short. The first tip will address content filters in the designer.

Designer Content Filters

Release 16.4.5 introduced a new filter feature to help improve the location of Integrations, Connections and other designer elements. If you visit the Integrations parts of the designer for example, you will now see additional options included in the banner as highlighted in the following screenshot:

Scheduling Orchestration Integrations – ICS Definitive Guide #2

By Phil Wilkins

On January 31, 2017

In Definitive Guides

This is the second article in the Definitive Guide series. This time we take a look at the ability to Schedule an Orchestration integration within ICS has arrived with release 16.4.5 release of ICS, To demonstrate this, we are going to reuse our FlightSitRep endpoint from the book’s Chapter 3. If you have not got the book yet – it’s a WSDL one way integration that is connected to Mockable.io.

Creating Scheduled Orchestration

From the Integrations screen we need to click on the New Integration button, and select the Orchestration pattern in the pop-up dialogue. The first thing we will see when creating an integration is the Create New Integration dialog, as shown here:

create new orchestration wizard

As you can see the dialog has a new toggle option which defaults to represent the common approach to Orchestration, that being event triggered through an event or object defined by a connection.

iPaaS and Cloud Security

By Phil Wilkins

On January 25, 2017

In ICS Useful Resources

Oracle iPaaS Security Within the Oracle iPaaS products you will encounter features that exist to help provide security or mitigate the risks of someone misusing Oracle cloud accidentally (or otherwise). These features look to mitigate security issues such as a Denial of Service (DoS) attack (e.g. flooding a web service with more calls than it can handle preventing genuine service calls for being serviced).

We thought it might be useful to pull some articles together that engage and talk about the challenges that can exist:

Consolidated References of 3rd Party Information on ICS and OIC

By Phil Wilkins

On January 4, 2017

In CollectedArticles, ICS Useful Resources

Last updated: December 28, 2021 at 1:20 am

We have consolidated all the 3rd Party references we know of regarding ICS into this single page.

As we encounter new information we will update the details, and if you encounter useful information missing from this list, please let us know (tweet @ImplementingICS with #ICS)

(Oct 18) Big batch of additional resources added to the table

3rd Party References & Resources

Title	Source	Date (YY/MM)	Subject Area
Promoting Integrations from dev to production	Oracle A Team	16/02	Config Mgmt
ICS scripts for cleaning up environments	Oracle A Team	16/06	Config Mgmt
SOA Myth Busters intro to ICS	SOA Myth Busters Blog	16/05	Overview
Cloud Adaptors introduction	Niall Commiskey (Oracle PM)	15/06	Adapters
On Premise Agent	Oracle A Team	16/11	Agent
Enhancing ICS Mappings with Java Classes	Oracle A Team	17/01	Core ICS
ICS Intro	AMIS (Oracle Partner)	15/05	Overview
Developer’s 1st Impression	AMIS (Oracle Partner)	16/03	Overview
ICS connectivity Agent	AMIS (Oracle Partner)	16/03	Adapters
ICS and Salesforce	Antonis Antoniou (Ace director)	15/12	Adapters
eBS Adapter with ICS	Oracle A Team	16/04	Adapters
ICS with Twitter	AMIS (Oracle Partner)	16/03	Adapters
ICS for offering REST versions of SOAP APIs	AMIS (Oracle Partner)	16/02	Adapters
ICS Security & Compliance	Oracle A Team	16/05	Core ICS
ICS Use case: Closed Loop Order Management	Oracle Community Blog	16/08	Core ICS
Oracle Integration Cloud Service (ICS) – How to use Upsert Operation	Shalindra Singh	15/10	Core ICS
Oracle Integration Cloud Service – How to keep all data residing in your applications in sync	esentri	16/05	Core ICS
Eloqua ICS Integration	Oracle A Team	17/01	Adapters
Understanding the Enterprise Scheduler Service in ICS	Oracle A Team	17/01	Core ICS
Teaching how to use the Integration Cloud Service Connectivity Agent	Solutions ANZ (Oracle Australia)	17/02	Agent
Using ICS to offer APIs on integrations	Solutions ANZ (Oracle Australia)	17/02	Core ICS
Integrating Sales Cloud and Service Cloud using ICS – troubleshooting issues with security configuration	Oracle A Team	17/01	Adapters
ICS Connectivity Agent – Update Credentials	Oracle A Team	17/02	Agent
Oracle ICS and Twilio: Publish-Subscribe Integration Pattern	Rubicon Red	17/02	Core ICS
Help! What Integration Solution is Best for Me?	Oracle Community	16/07	Core ICS
Oracle ICS + Twitter	S&P Solutions	16/04	Adapters
Oracle Integration Cloud Service Linkedin adapter.	Oracle Radio	16/10	Adapters
Oracle Integration Cloud Service Linkedin adapter (Spanish version)	Oracle Tech Network	16/12	Adapters
Integrate Your Applications in the Cloud	Oracle Community	16/07	Overview
Integrate Your HR System with a Talent Management System in the Cloud	Oracle Community	16/07	Adapters
Using Oracle Managed File Transfer (MFT) to Push Files to ICS for Processing	Oracle A Team	17/02	Adapters
ICS 17.1.3 – Javascript Libraries	Niall Commiskey (Oracle PM)	17/02	Core ICS
Connecting ICS and Apache Kafka via REST Proxy API	Oracle A Team	17/02	Adapters
Teaching how to use Developer Cloud Service to promote ICS Integrations into new Environments	Solutions ANZ (Oracle Australia)	17/02	config Mgmt
Custom 2-legged OAuth with Oracle Integration Cloud Service (ICS)	Solutions ANZ (Oracle Australia)	17/02	Core ICS
Integrating with Taleo Enterprise Edition using Integration Cloud Service	Oracle A Team	17/03	Adapters
Oracle Public Cloud – Invoking ICS endpoints from SOA CS – configure SSL certificate and basic authentication	AMIS (Oracle Partner)	17/03	Config Mgmt
Lifecycle management – Test 2 Production	Niall Commiskey (Oracle PM)	17/02	Config Mgmt
PCS 17.1.3 leveraging ICS	Niall Commiskey (Oracle PM)	17/04	Adapter
ICS Execution Agent	Niall Commiskey (Oracle PM)	16/01	Agent
ICS Part 1 (Spanish)	Avanttic (Spanish Partner)	17/02	Overview
ICS Part 2 (Spanish)	Avanttic (Spanish Partner)	17/03	Overview
Suggested ICS Naming standards	Gowrishankar’s Blogspot	17/02	Config Mgmt
Some ICS Best Practises (naming and eror handling)	Gowrishankar’s Blogspot	17/02	Core ICS
ICS Connectivity Agent stdout Log Rotation	Oracle A Team	17/03	Agent
Integrating with ERP Cloud using ICS	Oracle A Team	17/03	Adapters
Global Fault Handling	Niall Commiskey (Oracle PM)	17/03	Core ICS
ICS 17.1.3 Release Features	Oracle Integration Blog	17/03	Overview
ICS Command Line Tool	Oracle A Team	17/04	Config Mgmt
Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service	Solutions ANZ (Oracle Australia)	17/04	Adapters (ERP)
Comparing Oracle ICS connectors with Workday, Mule, Boomi and Azure	SOA4U (Luis Weir Ace Director)	16/08	Adapters
ICS 17.1.3 FTP adapter and File Staging	Niall Commiskey (Oracle PM)	17/03	Adapters (FTP)
Un repaso a Oracle Integration Cloud service, la nube de integración (An ICS review in Spanish)	Oracle Technet	16/10	Core ICS
Using Oracle Cloud Adaptor for ServiceNow on ICS	Shalindra Singh	17/03	Adapters (Service Now)
Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service	Solutions ANZ (Oracle Australia)	17/04	Adapters (ERP)
Teaching how to integrate Twitter with Integration Cloud Service	Solutions ANZ (Oracle Australia)	17/05	Adapters (Twitter)
Integrating with Oracle Field Service Cloud using ICS REST adapter	Oracle A Team	17/05	Adapters (Field Service)
Integrity check, content validation and encryption of files over ICS FTP adapter	Oracle A Team	17/05	Adapters (FTP)
Monitoring REST APIs	Niall Commiskey (Oracle PM)	17/05	Adapters (REST)
SOAP & REST with the Connection Agent	Niall Commiskey (Oracle PM)	17/04	Agent
REPL Based Management Utility	Niall Commiskey (Oracle PM)	17/04	Config Mgmt
Integrate Sugar CRM & Eloqua in few hours using Oracle Integration Cloud Service (ICS)	Ramanandh (Ram) Sankaralingam Digital Prime at Oracle Australia	17/06	Adapters (Eloqua)
Rest API call of Post method by passing the Query parameters as a request in Oracle Integration Cloud Service	Innovacx	17/07	Adapters (REST)
Handling multiple responses dynamically in ICS Orchestration	Innovacx	17/07	Core ICS
FAQ: Integrating E-Business Suite using Integration Cloud Service	Oracle A Team	17/07	Adapters (EBS)
Docker image for the Oracle Integration Cloud (ICS) Execution Agent	Jeroen Ninck Blok via SOA Community	17/07	Agent
Oracle Mobile Cloud Service (MCS) and Integration Cloud Service (ICS): How secure is your TLS connection?	AMIS (Oracle Partner)	17/07	Core ICS
How to write files using ICS file adapter	Ankur Jain	17/07	Adapters (File)
ICS File handling options and tips	Oracle A Team	17/08	Adapters (File)
ICS - API Platform Integration	Niall Commiskey (Oracle PM)	17/08	Adapters
ICS Map My Data lab	Niall Commiskey (Oracle PM)	17/08	Core ICS
17.2.5 New Features	Niall Commiskey (Oracle PM)	17/06	Core ICS
Management & Monitoring Enhancements	Niall Commiskey (Oracle PM)	17/06	Core ICS
ICS File handling options and tips	Oracle A Team	17/08	Adapters (file)
2 MTT Transport Layer Security in ICS and MCS	AMIS (Oracle Partner)	17/08	Core ICS
ICS SOAP Connection – Retrieve File Uploaded WSDL	Oracle A Team	17/08	Adapters (SOAP)
How to read file using ICS file adapter	Ankur Jain	17/09	Adapters (File)
CS On-Premise Monitor – Agent Ping	Oracle A Team	08/17	Agent
Consuming HCM atom feeds in ICS	Oracle A Team	09/17	Adapters (HCM)
Test driven SOA: Tool kit for comprehensive automated test coverage	The Middle Tier	09/17	Testing
Exception handling(Global Fault Handler) in Oracle ICS	Ankur Jain	10/17	Core ICS
Read large CSV file in Integration Cloud Service	Ankur Jain	10/17	Adapters (File)
Uploading SSL certificate in Oracle Integration Cloud	Ankur Jain	10/17	Core ICS
Last Run Date and Time in Oracle ICS (Integration Cloud Service)	Ankur Jain	10/17	Core ICS
ICS Best Practices : Before going live and post go-live	Oracle A Team	10/17	Config Mgmt
Microsoft Calendar Adapter in Oracle Integration Cloud Service (ICS)	Ankur Jain	10/17	Adapters (MS Calendar)
Convert UTC Date & time to another timezone in Oracle Integration Cloud Service(ICS)	Ankur Jain	10/17	Core ICS
Bind query parameter in database adapter in Oracle Integration Cloud Service	Ankur Jain	11/17	Adapters (DB)
Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 1	Oracle A Team	12/17	Core
Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 2	Oracle A Team	12/17	Core
OIC Trial - adding Integration Insight	Niall Commiskey (Oracle PM)	12/17	OIC Insight
Oracle Integration Cloud Public Page	Niall Commiskey (Oracle PM)	12/17	OIC
NetSuite Adapter in action	Niall Commiskey (Oracle PM)	12/17	Adapters (Netsuite)
Oracle Integration Cloud (OIC) - the cloud platform for Integration and Automation	Niall Commiskey (Oracle PM)	11/17	OIC
File Upload Process in Integration Cloud Services REST API	Ankur Jain	12/17	Adapters (File)
Conditional Mapping in Oracle ICS	Ankur Jain	12/17	Core
Adding WAIT functionality to an ICS/OIC orchestration	Niall Commiskey (Oracle PM)	01/18	Core
How do I test my integration on Oracle Integration Cloud Service	Kevin King	01/18	Core
Using Oracle Integration Cloud and Twilio to send SMS with REST	Kollin Brandenburg	03/18	Adapters (Twilio)
ICS Maven Plugin	Kevin King	03/18	Tools
Custom function in ICS to extend transformation capabilities	Ankur Jain	02/18	Core
Database polling in Oracle Integration Cloud Service	Ankur Jain	11/17	Adapters (DB)
ICS / OIC development guidelines	Niall Commiskey (Oracle PM)	03/18	Tools
Oracle Integration Cloud (OIC) and Robotic Process Automation (RPA)	Niall Commiskey (Oracle PM)	02/18	RPA
OIC Quickstart and User Creation	Niall Commiskey (Oracle PM)	02/18	Tools
Oracle ICS/OIC Prebuilt integrations	Niall Commiskey (Oracle PM)	01/18	Integrations
Adding WAIT functionality to an ICS/OIC orchestration	Niall Commiskey (Oracle PM)	01/18	Core
NetSuite Adapter in action OIC - NetSuite example enriched	Niall Commiskey (Oracle PM)	12/17	Adapters (Netsuite)
OIC and ICS File based integrations for Oracle HCM Cloud using UCM webservices	Shreenidhi Raghuram - Oracle A Team	02/18	Adapters (HCM)
Extending analytics for Integration cloud using Elastic stack.	Mani Krishnan (Oracle A Team)	03/18	Tools
NetSuite Integration Series: Part 1: Using User Event Scripts for real time integration using Integration Cloud	Naveen Nahata (Oracle A Team)	02/18	Adapters (Netsuite)
Oracle Integration Cloud Service for EPM Part 1 Part 2, Part 3	Vijay Kurian	02/18	Adapters (EPM)
Introducing Jarvis Pizzeria	Jarvis Pizzeria Team	08/17	PCS
AVIO Releases an ICS Maven Plugin	Avio	03/18	Tools
Oracle ICS - Advanced XSLT Mapping in JDeveloper	Avio	04/18	Tools
How to install the Oracle Integration Cloud on premises connectivity agent	AMIS	04/18	Agent
Fitter email Message of a Folder using Microsoft Email adapter in Integration Cloud Service	Ankur Jain	04/18	Adaptors (MS Exchange)
Integration instance tracing in OIC	Niall Commisky	04/18	Core
Customer Managed Cloud Patching	Jan Kettenis	03/18	Core
Selecting Maintainence Dates	Oracle Support	04/18	Core
Oracle University - Free Training Videos	Oracle University	04/18	Core
Dynamic Process, Conditions and Scope	Jan Kettenis	05/18	Core
New Data Mapper	Jan Kettenis	04/18	Core
TYerraform OIC Deployment	Red Thunder	03/18	Tools
Installing Connectivity Agent 18.1.3	AMIS	04/18	Agent
Visual Builder connecting to Autonomous OIC	Niall Commisky	06/18	Visual Builder
Autonomous OIC - The Value Add	Niall Commisky	05/18	Core
Eloqua Connectivity	Niall Commisky	05/18	Adaptors (Eloqua)
Instance Tracibng in OIC	Niall Commisky	04/18	Core
Securely Connect to REST APIs from Oracle Integration Cloud	Anuj Kaushal (Oracle)	10/18	Adaptors (REST)
How to invoke an Integration From another Integration in OIC without creating a connection	Arif Rafique (Oracle)	10/18	Core
A simple guide to use nested scope in orchestration	Arif Rafique (Oracle)	10/18	Core
Timezone functionality in OIC Schedules	Arya Sanyal (Oracle)	10/18	Core
API-Key Based Authentication: Quickly and Easily	Anuj Kaushal (Oracle)	10/18	Adaptors
Scaling Oracle Integration Cloud	Antony Reynolds (Oracle)	08/18	Core
How to enable and use Tracing in less than 5 min	Muthu Palanisamy (Oracle)	09/18	Core
How to use Litmus to create OIC Integration unit tests automatically and run them to catch regressions	Muthu Palanisamy (Oracle)	09/18	Litmus aka Asserter
Enabling the Future Today - Feature Flags in Oracle Integration Cloud	Antony Reynolds (Oracle)	09/18	Core
Using a Library in OIC	Harish Vinayachandran (Oracle)	09/18	Core
Integration Cloud – File Handling Primer	Shreenidhi Raghuram (Oracle A-Team)	06/18	Core
Introduction to Cloud Application Integration	Arijit Chakraborty	06/18	Core
Some Tips for Working with Visual Builder UI Components in Oracle Integration Cloud	Siming Mu (A-Team Oracle)	06/18	Visual Builder
ICS to OIC Migration	Abhay Kumar (A-Team Oracle)	07/18	Core
Agent Group Existance Check Failed, Recheck ICS Username, ICS Password and Proxy Username, Proxy Password or Contact Customer Support	Ankur Jain	06/18	Agents
Oracle Autonomous Integration Cloud (AIC): Read ZIP files using FTP adapter and load data into on-premise application	Ankur Jain	10/18	Adaptor (FTP)
Salesforce integration in Autonomous Integration Cloud (AIC)	Ankur Jain	10/18	Adaptor (Salesforce)
Oracle Integration Cloud Service Agent	Ankur Jain	10/18	Agent
CRUD Operation in Oracle Integration Cloud	Ankur Jain	09/18	Core
Provisioning the Oracle Integration Cloud (OIC) Instance	Ankur Jain	08/18	Core
Date Time by adding / subtracting n number of days / hours / minutes in ICS	Ankur Jain	08/18	Core
Leverage Microsoft Email Adapter to send email using Oracle Integration Cloud (OIC)	Ankur Jain	08/18	Adaptors (MS Exchange)
CASDK-0007 Unable to establish a secure connection to oracleebs.com. SSL protocol related exception occurred	Ankur Jain	07/18	Adaptors
OIC 18.4.1 New Features	Niall Commiskey (Oracle PM)	10/18	Core
OIC --> File Transfer Pattern ala MFT pass by reference	Niall Commiskey (Oracle PM)	10/18	Adaptor (MFT)
VB CS / Process Integration - Surfacing the Task Payload in VB CS	Niall Commiskey (Oracle PM)	09/18	Visual Builder / PCS
Building your First VBCS Application	John Ceccarelli (Oracle)	05/18	Visual Builder
OIC integration with Fusion HCM & the efficacy of BI reports & HCM REST APIs	Niall Commiskey (Oracle PM)	08/18	Adaptors (HCM)
OIC Insight REST API	Niall Commiskey (Oracle PM)	08/18	Insights
OIC Integration 101 Part IV - Error Notification	Niall Commiskey (Oracle PM)	08/18	Core
OIC Integration 101 Part II --> Orchestrations and Monitoring	Niall Commiskey (Oracle PM)	08/18	Core
Decisions in OIC (Process)	Niall Commiskey (Oracle PM)	07/18	PCS
SSI invoking OIC	Niall Commiskey (Oracle PM)	07/18	Adaptors (SSI)
New JET based OIC Mapper	Niall Commiskey (Oracle PM)	07/18	Core
Autonomous OIC --> Process REST API	Niall Commiskey (Oracle PM)	06/18	Core
VB CS --> Integration Connectivity with Autonomous Integration Cloud	Niall Commiskey (Oracle PM)	06/18	Visual Builder
Uncovering Booking Fraud with Oracle Process Cloud Service (PCS) and Decision Model Notation (DMN)	Arun Pareek (Rubicon Red)	05/18	PCS
Patient Health Monitoring with Oracle IoTCS and PCS	Arun Pareek (Rubicon Red)	04/18	PCS
Teaching How to Provision Oracle Integration Cloud (OIC) with Cloud Stack and Terraform	Carlos Rodriguez Iturria (Red Thunder - Oracle)	07/18	Provisioning
PeopleSoft Integration using Oracle Integration Cloud	Jin Park (Red Thunder - Oracle)	07/18	Adaptors (PeopleSoft)
Building iOS Mobile App on Oracle Autonomous Visual Builder Cloud Service (VBCS)	vijaykumaryenne (Red Thunder Oracle)	08/18	Visual Builder
Embed Process Automation into Oracle Service Cloud	Serene Tan (Red Thunder - Oracle)	05/18	PCS
Migration from Oracle BPM to Oracle Autonomous Integration Cloud — Streamlining Process Automation in the Cloud	Andre Boaventura - Oracle	06/18	Insights
Upgrade on premise ICS agent	Ankur Jain	12/18	Agent
Change connection in the Integrations: Oracle Integration Cloud	Ankur Jain	12/18	Connector
Poll File from Agent server leveraging File Adapter: Integration Cloud	Ankur Jain	12/18	Adaptor (File)
Implement Pagination in REST Service: Integration Cloud	Ankur Jain	12/18	Adaptor (REST)
#674 OIC DB Adapter for Oracle Database 18c	Niall Commiskey (Oracle PM)	12/18	Adaptor (Oracle DB)
#673 - OIC Integrations - re-submittable errors	Niall Commiskey (Oracle PM)	12/18	Core
#672 OIC 18.4.5 New Features - Process	Niall Commiskey (Oracle PM)	12/18	All
#671 OIC 18.4.5 New Features - UI Path RPA adapter	Niall Commiskey (Oracle PM)	12/18	Adaptor (RPA, UIPath)
How to migrate from ICS to OIC? - Using Internal Storage	Muthu Palanisamy Sr Director Software Development Oracle	10/18	ICS
Rename or Delete a Swimlane Role	Jan Kennenis	01/19	Process
VB CS leveraging Integrations - required configuration	Niall Commiskey (Oracle PM)	03/19	App
Subscribing to Fusion ERP Events	Niall Commiskey (Oracle PM)	02/19	Adaptor (ERP)
Oracle Field Service OIC adapter support	Niall Commiskey (Oracle PM)	02/19	Adaptor (Field Service)
Oracle Asserter - Regression testing in Oracle Integration (OIC)	Niall Commiskey (Oracle PM)	02/19	Core
HCM Integration & HCM adapter in depth	Niall Commiskey (Oracle PM)	01/19	Adaptor (HCM)
Consume HCM Atom Feeds in Oracle Integration	Niall Commiskey (Oracle PM)	01/19	Adaptor (HCM)
Integrations - re-submittable errors	Niall Commiskey (Oracle PM)	12/18	Core
How to use Pick action in OIC Orchestration	Sumeet Singh (Oracle Tech)	03/19	Core
Integrating Oracle Integration Cloud Integration with UIPath	Siming Mu (Oracle A-Team)	03/19	Adaptor (RPA, UIPath)
OIC Integration with Logistics Cloud – Things to Know and Best Practices	Shreenidhi Raghuram (Oracle A-Team)	02/19	Adaptor (Logistics Cloud)
Cloud Integration Patterns Using Oracle PaaS	Abhay Kumar (Oracle A-Team)	01/19	Core
Fetch Email attachments using Microsoft Email adapter in Oracle Integration Cloud	Ankur Jain	03/19	Adaptor (MS Exchange)
Gmail adapter in Oracle integration cloud	Ankur Jain	03/19	Adaptor (GMail)
Oracle Integration Cloud REST API to get the Integration Statistics	Ankur Jain	03/19	Adaptor (REST)
The Power of Process Automation: The Linchpin to Digitization and AI Adoption	Daryl Eicher	03/19	RPA
Dive Deep into Wells Fargo’s Best Practices for Cloud ERP Integration	Daryl Eicher	04/19	Core
Integration: Heart of the Digital Economy - Podcast Series	Vika Mlonchina	03/19	Core
OIC makes integration easy with ODI	Red Thunder	03/19	Core
Oracle Service Cloud to Eloqua – Bulk Opportunity Import using Service Cloud ROQL and OIC	Red Thunder	04/19	Adaptors (Eloqua, Service Cloud)
OIC Integration with Netsuite - initial setup and basic troubleshooting	Niall Commiskey (Oracle PM)	05/19	Adaptors (Netsuite)
OIC Taleo EE (OTAC) - Create Requisition	Niall Commiskey (Oracle PM)	05/19	Adaptors (Taleo)
Oracle Process Cloud - linking to a process instance	Niall Commiskey (Oracle PM)	05/19	Core
Syncing Customers/Contacts from your CRM to Netsuite	Niall Commiskey (Oracle PM)	05/19	Adaptors (Netsuite)
OIC Integration with Netsuite - initial setup and basic troubleshooting	Niall Commiskey (Oracle PM)	05/19	Adaptors (Netsuite)
OIC REST API for Connectivity Agent DR	Niall Commiskey (Oracle PM)	05/19	Agent
Oracle Integration now with Automation Anywhere (RPA) adapter	Niall Commiskey (Oracle PM)	04/19	Adaptors / RPA
Creating/changing Integration Artifacts via the OIC REST API	Niall Commiskey (Oracle PM)	04/19	API
BOT Orchestra by Oracle Integration	Nicolas Damonte	04/19	Adaptors / RPA / RPO
ntegration between FTP - Sharepoint (Upload documents): Oracle Integration Cloud	Ankur Jain	05/19	Adaptors (FTP/Sharepoint)
OAuth Custom Three Legged Security Policy in REST Connection: Oracle Integration Cloud	Ankur Jain	05/19	Security
Access Sharepoint online REST APIs	Ankur Jain	05/19	Adaptors (REST/Sharepoint)
OAuth Custom Two Legged Security Policy in REST connection: Oracle Integration Cloud	Ankur Jain	05/19	Security
Copy files from one SFTP to another SFTP: Oracle Integration Cloud Services	Ankur Jain	05/19	Adaptors (FTP)
HTTP error responses in REST API: Oracle Integration Cloud	Ankur Jain	05/19	Adaptors (REST)
Change date time format in Oracle Integration Cloud	Ankur Jain	04/19	Core
Download CSV file from REST service Response Content: Oracle Integration Cloud	Ankur Jain	04/19	Adaptors (REST)

ICS Useful 3rd Party Resources

Oracle Document Reference Links…

Resource	Description - Link
Adapter Certification	Oracle Adapter Certification Matrix
ICS Cloud Documentation Home	ICS Cloud Latest Edition Documentation
Oracle Online Learning	OLL - YouTube ICS Training Playlist
Eloqua ICS Connectivity (Eloqua Help Center)	Eloqua Cloud Herlp Centre
All A-Team ICS Posts	http://www.ateam-oracle.com/category/cloud/paas/paas-ics/
Oracle Integration Blog	Blog covering all Oracle's Integration offerings
OIC Analyst Report	OIC analyst Report

Tools That May Help …

Tool	Link
Online WSDL pretty print/viewer	https://www.wsdl-analyzer.com/online-wsdl-viewer
Web Services Directory	http://www.webservicex.net/New/
Apiary (Swagger / Open API & API Blueprint designer)	https://apiary.io/
Mockable - Endpoint Mocking	https://www.mockable.io/

ICS Connection Agent on Windows?

By Phil Wilkins

On October 17, 2016

In General Integration

We have seen the question a number of times (such as here) regarding whether or not the ICS Connection agent or (Execurtion) Worker Agent can run on Windows. Presently when establishing an agent ICS provides a Bash shell executable (BSX) file.

We’ve not heard any suggestion this is likely to change – but when you consider that the Agent is essentially a WebLogic server with parts of ICS incorporated into it. You can see that from a production perspective, demand for Windows support isn’t going to be huge.

That said, when researching, testing, developing and testing a lot of people do use a Windows platform. So being able to use the agent is attractive. So what options are available for a Windows environment?

Oracle Messaging Cloud Service (OMCS) on Trial

By Phil Wilkins

On October 4, 2016

In General Integration

This post provides a fairly detailed introduction to registering and creating a trial instance of Oracle Messaging Cloud Service. We have written this as in our book Introducing Oracle Integration Cloud Service (ICS) we use Oracle Messaging Cloud Service(OMCS) in chapter 8 to illustrate message based integration outside of ICS. Whist we describe the process for OMCS, the mechanics are similar for a number of the iPaaS offerings from Oracle including ICS, PCS but not SOA CS as this is a far more complex product and the fee charging structure is rather different.

In the screenshots of the process that follows, we have blurred out key credentials, this is purely for personal security reasons.

The first step is to create the trial of OMCS, to do this you need an Oracle account. This can be done from the main Oracle site. If you already have an account with Oracle Technology Network (OTN) or Oracle community then you are already sorted as Oracle operates a single sign on.

Understanding Integration Cloud and how to get the most out of your implementation

Author: Phil Wilkins Page 7 of 8

Short Best Practices Presentation for Oracle Partner Event

Applying configuration management and related dev practises – ICS Definitive Guide #3

Why Configuration Management?

Using iCal in Scheduling – ICS Definitive Tip #3

Using Integration Versioning – ICS Definitive Tip #2

Seeing Versioning in Action

Designer Content Filters – ICS Definitive Tip #1

Scheduling Orchestration Integrations – ICS Definitive Guide #2

Creating Scheduled Orchestration

iPaaS and Cloud Security

ICS Connection Agent on Windows?