Integration Cloud Services (ICS)

--PaaS/IPaaS
PaaS/iPaaS
Integration platform as a service

► Integration platform as a service (iPaaS) is a set of

automated tools for connecting software applications that
are deployed in different environments. iPaaS is often used
by large business-to-business (B2B) enterprises that need to
integrate on-premises applications and data with cloud
applications and data.
► Examples:
► OIC – Oracle Integration Cloud
► Dell Boomi
► MuleSoft
► Informatica Cloud
► Snaplogic
► Jitterbit… many more.

2
3
ICS- Integration Components

4
What is ICS Integration

► Defines the flow of messages

► • Includes:
► – One Source connection (for requests sent to ICS)
► – One or more Target connections (for requests sent
from ICS)
► – Data mapping between two connections (both request
and response)

5
ICS- Integration Development
Life Cycle
► Create Connections (Leverage prebuilt connectors or configure built-in
adapters)
► Create Integrations
► Map Data (Optionally Create Lookups)
► Activate Integrations
► Monitor Integrations (Track Payload Fields/Manage Errors)

6
ICS- Integration Development
Life Cycle
► An integration always consists of a Trigger (source) and an Invoke
(target).
► A Trigger means the connection where the integration receives the
message from.
► An Invoke means the connection where the integration sends the message
to.
► These two connections are the first two objectives before creating an
integration.

7
ICS- Integration Development
Life Cycle
► For Asynchronous/one-way Operation – you only have
request mapping
► For Synchronous/two-way operation – you have request
and response mapping
► fault mapping is created when both trigger and invoke
connections define faults.

8
Adapters

► Process messages, communicate with a remote system

► • Abstract away the complexities of transports and
protocols
► – Automatic discovery of application assets
► — Business objects, services, and events
► — Support for standard and custom objects
► – Plug-and-play
► — Runs on premise and on cloud
► — Require you to only point and click to start using new
adapters
► • Are configured as part of an ICS flow
9
Configuring SOAP Adapter Properties

For Trigger Operation Properties: (Used to define an ICS entry

point for an integration)
► 1. Create and upload the WSDL.
► 2. Select the port type (interface).
► 3. Select the operation.
For Invoke Operation Properties: (Used to invoke an existing
SOAP web service)
► 1. Upload the WSDL.
► 2. Select the service (if WSDL includes multiple services).
► 3. Select the port type (interface).
► 4. Select the operation.

10
REST

► Enables you to:

► – Expose an ICS Integration as a REST service
► – Invoke an external REST application from your ICS Integration
► • Supports the following message exchange patterns:
► – Synchronous request and response patterns
► – Synchronous one-way request patterns
► • Also supports:
► – Basic authentication and OAuth
► – Cross-Origin Resource Sharing (CORS)
► – RESTful API Modeling Language (RAML) and Swagger payload
Types - Swagger is a specification for describing, producing,
consuming, and visualizing RESTful web services.

11
Configure REST Adapter
Properties
► Provide a meaningful endpoint name and description.
► • Specify a relative resource URI.
► • Select the HTTP method (GET, PUT, POST, DELETE).
► • Select attachment processing options.
► • Select the request payload file (XML or JSON based on XSD
element).
► • Configure standard and/or custom request headers:
► – Query parameters/Template parameters
► • Define the expected response payload.
► • Configure standard and/or custom response headers.
► • Configure CORS (allowed origins/allowed methods):
► – Available only in the trigger (inbound) direction
12
Integration Style/Pattern

13
 Integration Style/Pattern

Pattern Description
App Driven Create an integration that uses an event or a business object to trigger the integration. For
Orchestration 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 Create an integration that uses a schedule to trigger the integration instead of an adapter.
Orchestration 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.

14
 Integration Style/Pattern
Pattern Description

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 Create an integration in which you add a trigger adapter to publish messages to Oracle
OIC 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 Create an integration in which you add an invoke adapter to subscribe to messages
OIC 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.

15
Connections

► A connection defines the application you want to

integrate with.
► Each connection can be used for both inbound and
outbound
► Connections can be divided into four categories: SaaS
adapters, Technology adapters, Social adapters, and
on-premises adapters:

16
Connections

► SaaS Adapters - The adapters

offer a much more simplified
experience through a powerful
wizard.
► For example, the Oracle
RightNow and Salesforce
adapters support the automatic
provisioning of Business Objects
in the wizard.
► These adapters also handle
security and provide standard
error handling capabilities.

17
Connections

► Technology Adapters
► Not all applications we see on a daily basis are SaaS applications with prebuilt
adapters. Industry standards such as SOAP and REST are used by the majority of
APIs. SOAP is mostly used for system-to-system integrations, whereas the
lightweight REST protocol is used to provide access to mobile applications.

18
SOAP Adapter

► SOAP specification is used in the implementation of the

webservics.
► The SOAP protocol uses XML as the markup language for its
message format.
► SOAP itself is not a transport protocol, but relies on application
layer protocols, such as HTTP and JMS.
► Web services that are built to communicate using the SOAP
protocol use the Web Service Description Language (WSDL). This
is an XML-based interface and describes the functionality a web
service offers.

19
SOAP Adapter

► The WSDL structure consists of five building blocks; types, messages,

porttypes, bindings,and services:

20
REST Adapter

► The REST architectural style introduces certain architectural

properties such as performance, scalability, simplicity,
addressability, portability, and reliability. Because it is a style,
there are some variations going around.
► Web services or APIs that apply REST are called RESTful APIs. They
are simply a collection of URIs, HTTP-based calls that use
JavaScript Object Notation (JSON) or XML to transmit data
objects, many of which will contain relational links.

21
FTP Adapter

► Allows to read/write files from FTP in ASCII/binary

► Provides scheduling- which provides the time and
frequency of invocation
► Provides encryption for outbound files using PGP(Pretty
Good Privacy) cryptography

22
On-Premise Adapters

► Oracle Integration Cloud Service provides adapters and supporting

software to create a Hybrid Cloud solution
► The supported adapters include technology adapters, for example,
Database, File, and JMS, an adapter for Oracle E-Business Suite,
Oracle Siebel and SAP, and so on.
► Adapters do not indicate if it is for on-premises use only, or if it can
be used with an on premises endpoint. When creating a new
connection based on the adapter it will ask for an agent to assign to
the connection.

23
Social and productivity
adapters
► Integration Cloud Service supports social apps such as Facebook,
LinkedIn, and Twitter, to post a status update. The supported
productivity apps include Google, Microsoft Calendar and Mail, Google
Task, MailChimp, and SurveyMonkey; and this list is updated on a
monthly cycle:

24
Integrations

► In Oracle Integration Cloud Service, the core function is creating

integrations between applications. Integrations use the created
connections to connect to our applications.
► Integrations define how information is shared between these
applications.

25
Basic Routing - Integration

► It is is the least complex integration pattern and the

mostly commonly used one too.

26
Publish to OIC/ Subscribe to OIC

► A publish-subscribe integration, in ICS separated in two separate

integrations, implements a messaging pattern where messages
are not directly sent to a specific receiver.
► The senders of messages are called publishers and the receivers
of messages are called subscribers.

27
Orcehstration

► Multi-step Integration flow invoking applications,

integrations and processes triggered by an Application
or API

28
Lookups

► A lookup, also known as Domain Value Maps (DVM),

associates values used by one application for a specific
field to the values used by other applications for the
same field.

29
Source Code – Import/Export

► .iar – Integration Archive

► .par – Package Archive

30

Import (.iar) – Integration archive files

Source Code – Import/Export

Export/Download Source Code .iar file

31
 Import/Export - .par
(Package Archive Files)

Import .par files

32
Download .par files
Resources

► Cloud.oracle.com (For 30Day Free Trial Access to ICS and many more
other services form Oracle)
► https://docs.oracle.com/en/cloud/paas/integration-cloud-service/i
ndex.html (Oracle ICS Documentation)
► https://apex.oracle.com/ (Free Access Unlimited From Oracle)

33