Tuesday, November 26, 2019

Oracle Integration Cloud (OIC) - Introduction

  • Oracle Integration Cloud (OIC) and Integration Cloud Service (ICS) are iPaaS offerings from Oracle. 
  • ICS was released back in 2015 has now been superseded by OIC. Customers on ICS can choose to be on ICS or migrate to OIC to take advantage of new features and services built into OIC.
  • It offers a user-friendly web-based interface enabling 'Integrators' to quickly perform some basic mapping and integration between (cloud) applications. with a growing number of available cloud applications(not only from oracle), customers face the challenge of keeping these solutions in sync, a challenge in which Oracle ICS can help us out.
  • Data Exchange between Cloud and On-Premise or 3rd Party applications.
  • The product comes with over 60 adapters.These adapters cover Oracle and non-Oracle SAAS and On-Premise apps as well as technology adapters such as SOAP and REST.
Benefits of using OIC:
  • A unified platform to automate processes
  • Integrate and create applications
  • Analyze results
  • Use Pre-build integrations or design your own integrations
  • No coding required
  • Interactive dashboard for real time insight of process flows
  • Monitor errors and take corrective actions
  • Minimize human error by automating the flows.
OIC in relation to Oracle SOACS:

Oracle SOA offers the SOA Suite as a cloud Service(SOACS) for solving the same integration issues as OIC does.SO why  also offer OIC?
  • Oracle ICS is positioned for the 'LOB Developer'(Line of Business Developer). The developer who actually functionally knows the application's being integrated. 
  • The developer who does not necessarily understand SOAP/REST/XML and other integration related technologies but does understand the underlying business entities, and which ones should be integrated between applications. 

Services available in Oracle Integration cloud:

Create and Manage Integrations(Integrations)  >> ICS / OIC
Launch the design-time environment for integrations. Create and activate integrations, as well as their connections and orchestrations. work with look ups, packages, agents, and  adapters.

Build Automated Process Applications(Process Biulder) >> PCS
Launch the design-time environment for process applications. Create process applications from scratch or by using quick start apps. Model processes in the process editor, and create web forms and decisions. Perform design-time administration such as playing, testing and deploying applications.

Develop Web & Mobile Applications(Visual Builder) >> VBCS
Create and publish web and mobile applications.

Use cases:
All cases created in Salesforce are being synchronized with ServiceNow as incidents.

SAAS to On-Premise:

Update of opportunities in Salesforce propagated to on-premise Order Management.

Aspects of OIC Integrations:

  • Connections define information about the instances of each configuration you are integrating. 
  • OIC includes a set of predefined adapters, which are the types of applications on which you can base your connections such as Oracle Sales Cloud, Oracle Right Now and others.
  • A connection is defined as any endpoint(Source or target) that is implemented within  an integration flow. These connections are based on  defined adapters.Adapters allows for easy connectivity to applications. insulating  the developer from complexities  that can occur when  interacting  with an application. 
  • OIC includes different kind of adapters like Oracle adapters, Non Oracle adapters, Technology specific adapters and social networking adapters etc.

  • Integrations are the main ingredient of a oracle integration cloud. An integration includes at least a trigger(source) connection (for requests sent to Oracle Integration Cloud) and invoke (target) connection (for requests sent from OIC to the target) and fields mapping between those two connections.
  • Integrations are processes that utilize connections to implement a business process. Using drag and drop capabilities, an integration can easily be defined. The functions defined within the VETO(validate, Enrich, transform and operation) integration design pattern are available for implementation.
Prebuild Integrations:
Apart from developing your own integrations in Oracle ICS, one can also leverage integrations build by others.


  • Use lookups in your integrations to create reusable tables that map the different terms used to describe the same item across your applications.
  • A bit like DVMs in SOA Suite, can cross-reference values of the same attribute/element when mapping from one system to another.

Packages allow for grouping of integrations,providing the abilities to import and export packages between environments.

Agents are used to connecting to On-premise applications, For example, if you are using On-premise systems like ERP/SAP and also using Oracle OIC in the same implementation, you would have to use an agent to connect to the OIC application. Two types of ageents arw available:
  1. Connectivity agent
  2. Execution agent
Libraries is a file or a collection of multiple files bundled in a JAR containing JavaScript functions. Library is used within an Integration and is executed by a JavaScript engine on the server as a part of integration flow.
Use an adapter to connect to an application in your integration. Oracle adapters are ready to use and pre-built block of code for the specific technology. 

Basic Integration flow:

Integration Workflow

Integration patterns or styles:

App Driven Orchestration
Create an integration that uses an event or a business object to trigger the integration. For example, you create an integration with an Oracle RightNow Adapter as a trigger and an Oracle Engagement Cloud Adapter as an invoke. The Oracle RightNow Adapter subscribes to an event from the Oracle RightNow application to trigger the integration.
Orchestration integrations include features such as the following:

  • Switch activities to create multiple routing expressions.
  • For-each activities for looping over repeating elements.
  • Assign activities for assigning values to scalar variables.
  • Ad-hoc mappings on switch branches.
  • Callback activities (to end a process and respond back to the sender) and end activities (to end a process without responding back to the sender) in asynchronous integrations.

Scheduled Orchestration
Create an integration that uses a schedule to trigger the integration instead of an adapter. For example, you add an initial invoke adapter to read a trigger file and a second FTP adapter to download the file for further processing. After designing this integration, you schedule when to run it.
File Transfer
Create an integration to move files across a network.
Basic Routing
Create an integration with a blank trigger and invoke in which to add your own adapters. You can also create a single routing expression and request and response enrichments, as needed. You cannot create multiple routing expressions. If your integration requires this feature, create an orchestrated integration.
Publish to OIC
Create an integration in which you add a trigger adapter to publish messages to Oracle Integration through a predefined Oracle Integration Messaging invoke. No configuration of the invoke subscriber is required.The publisher and subscribers participating in this integration pattern can be activated and deactivated independently of each other.
Subscribe to OIC
Create an integration in which you add an invoke adapter to subscribe to messages from Oracle Integration through an Oracle Integration Messaging trigger. You are prompted to select the publisher to which to subscribe. You must have already created a publisher to which to subscribe. The publisher does not need to be active, but must already be completely configured.

Any business identifiers defined on fields in the published integration are copied to the subscriber. Any changes made to the published integration’s business identifiers after copying are not reflected in the subscriber. The publisher and subscribers participating in this integration pattern can be activated and deactivated independently of each other.


A Visual Mapper is provided that enables you to map fields between applications with different data structures by dragging source fields onto target fields.

OICS dashboard displays information about the current sate of all running integrations, successful messages ratio, connections etc.

Check all Oracle Services:


Register for oracle cloud:


With Oracle subscription:
  • 30 days free trial having $300free credits.
  • Access to  a wide range of Oracle cloud services for 30 days including database, analytics compute and container engine for kubernates
  • up to eight instances across all available services.
  • up to 5 TB of storage,
  • Autonomous transaction processing or autonomous data warehouse 2 database total each with 1OCPU and 20 GB storage.
  • 2 block volumes 100 GB total, 10 GB object storage 10 GB Archive storage,

1 comment:

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...