OIC Webinar

1
Integrate Applications without Any Coding Using
Oracle Integration Cloud

• June 29, 2021

• Prepared by

• NexInfo Team

2
NexInfo Introduction
Founded in 1999 22 years of excellence
NexInfo Solutions Inc. (NexInfo) a leading
consulting company, a premier Oracle partner with
extensive consulting experience helping small,
medium and large organizations. Uses a blend of
Business Process and Software Consulting Services
to help achieve Operational Excellence.

• Deep domain expertise in
• Enterprise Resource Planning
• Product Lifecycle Management
• Supply Chain
• Integrated Business Planning
• Customer Experience
• Planning Budgeting
• Human Capital Management
• Predictive Data Analytics
• Security

NexInfo helps businesses with digital
transformation system integration
We build tailored solutions to meet your business
goals!
3
Presenter Info
Rahul Phatak
Oracle ERP And Cloud Practice Lead
20 years of industry experience and specialize
in Business transformation, Process and Solution
Design, Program Management, Change
Management Extensive experience in Enterprise
Resource Planning (Finance and Supply Chain),
Human Capital Management (HCM). Oracle
Certified Specialist with experience in leading
ERP transformation engagements, EBS upgrade
projects, recommending industry best practices
implementing Business Optimization initiatives
for Enterprise Customers across industry domain.
4
Presenter Info
Venkateshwari J
Oracle ERP And Cloud Technical Lead
14 years of Industry experience and specialized
as Technical consultant in ERP applications like
Oracle eBusiness Suite and Fusion
Application. Extensive experience in Enterprise
Resource Planning (Finance and Supply Chain),
Human Capital Management (HCM). Oracle
Certified Integration Specialist with rich
experience in Integration, Reports and Analytics,
customization and Data migration
5
Integrate Applications without Any Coding Using
Oracle Integration Cloud
6
Integration Trend 1

• Embrace Automation
• Reduce human effort
• Improve the quality and value of the data you
  work with

7
Integration Trend 2

• Spatial Data
• Real Time Data
• Augmented Reality

8
Integration Trend 3
9
Integration Trend 4
10
Integration Trend 5
11
Overview of Oracle Integration Cloud
What it Does

• Integrate and Automate Applications across clouds
  and on-premises
• Unified offering App Integration , Process
  Automation

Common Use cases

• Order-to-cash, employee on-boarding, GL- Invoice
  synchronization, Scheduling orchestration/File
  Handling, EDI file transfer etc.

Key Features

• Low code designer for LOB /Apps IT to develop
  integration flows intelligent process
  automation.
• Prebuilt Recipes rich library of adapters for
  Oracle and 3rd party apps.
• Integration in sight collects real-time metrics
  to offer rich analytics
• Secure on-premises integration using lightweight
  Agent
• .

Benefits

• Faster Integration Automation of applications
• Increased business agility

12
Overview of Oracle Integration Cloud
13
Overview of Oracle Integration Cloud
SaaS On-premises Integration
Create the connections that you
want to share data with. Then set up integration,
Which uses the connection you created and defines
how data is shared between your applications.
Business Process Automation

Automate your Business using process application
develop, test, publish and activate. Repeat
whenever changes are needed.
Visual Application Development

Quickly create and publish custom web and
mobile applications using a visual development
tool. Build the pages in your application using
components that you place on a canvas and
integrate with other services. No setup and no
coding required.
Real-Time Analytics and Monitoring

Create a data model, where data can be
extracted from business process and stored.
Further, these extracted data can be processed
and presented as meaningful business metrics.
14
Oracle Integration
15
Oracle Integration

• SaaS to SaaS Integration
• Business case All sales orders created in SCM
  application is synchronized with CX application.

Oracle Integration Cloud
CX Cloud
ERP Cloud
Incidents
OIC
Sales Orders

• Automate real-time Integration.
• Streamline business process by integrating across
  multiple business systems.

16
Oracle Integration

• SaaS-to-On-Premises Integration
• Business case Update of opportunities in
  salesforce propagated to on-premises Order
  management.
• The feature enables you to create integrations
  and exchange messages between on-premises
  applications and Oracle Integration Cloud Service.

17
OIC Integration Components
Use adapters to connect to source and target
systems and then extract data from the source
systems, mediate the semantics and technical
differences and publish the data to the target.
Leverage Oracle Public cloud services for storage
and messaging services.
18
On-Premises Integration
On-Premises OIC Connectivity Agent
Connectivity agents are the agents that help you
create integrations between on-premises
applications and Oracle Integration Cloud (OIC)
Service.
1
Connectivity Agents are required for Oracle
Integration Cloud to communicate or exchange
messages with on-premise applications like
Database, E-Business Suite, etc.
2
19
Integration development and Management workflow
Define connections Identify the Integration
application and configure the connection for the
application.
Step 1
Step 2
Create Integration by dragging these connections
to the designer.
Step 3
Create mapping between the application using
Graphical mapper.
Step 4
Monitor the integration performance using
monitoring dashboard.
20
Prebuilt Integration

• Prebuilt Integrations helps users accelerate
  their integration projects.
• The types of prebuilt integrations are
• Oracle-Created Integration
• Integration that you or other users created

21
Oracle-Created Prebuilt Integrations

• Creating Point and click integrations using OIC

22
Customizing Prebuilt Integration
Step 1
Import the package of Prebuilt Integration
Customize the Integration based on your need by
giving metadata such as Name and Version, minimum
Apps Versions, Readme URL, and so on., until its
final ready for publishing to all other users.
Step 2
Step 3
Integration Packages can be created to migrate
the integration from one instance to other
instance.
Step 4
Activate the Integration.
23
Creating New Integration

• Integration includes at the least a trigger
  (Source) connection (for request sent to oracle
  integration) and invoke (target) connection and
  field mapping between those two connections.

One source (trigger role)connection for requests
sent to OIC
One or more Target (invoke role) connections for
requests sent from OIC
Data mapping between two connections (both
request and response)
24
Integration Styles
25
Integration Styles
26
Integration Development and Management work flow
27
OIC Adapter
Process messages, communicate with 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
Require you to only point and click to start
using new adapters.
Are configured as part of an ICS flow.
28
Available OIC Adapters

• Over 60 adapters are preinstalled in your OIC
  environment.
• Oracle Cloud SaaS Applications
• Third-Party Cloud SaaS Applications
• On-Premises Enterprise Applications
• Social/Productivity Applications
• Generic Technology Adapters
• Databases
• FTP/File Servers
• REST
• SOAP

29
Defining Connection and Security Properties

• OIC Connections Review

30
OIC Integration Workflow

• OIC Connections Review

31
Sample OIC Adapters and features
Oracle Service Cloud

Oracle Service cloud Adapter enables you to
invoke operations, execute SQL queries or
download business objects as files in Oracle
Service cloud applications.
Oracle ERP Cloud

Oracle ERP cloud Adapter allows client to
retrieve information about all public Fusion
Application services endpoints available for that
Instance.
Oracle HCM Cloud

Oracle HCM cloud Adapter enables you to invoke
operations extract bulk data or subscribe to
updates, send files to HCM cloud.
Oracle ATP/ATW Databases

Oracle ATP ATW cloud Adapter enables
to execute SQL queries or stored procedures in
oracle ATP Oracle AWD databases.
32
Sample OIC Adapters and features
FTP Adapter
Oracle FTP Adapter
enables the Integration of the file transfer
protocol(FTP) and secure shell(SSH) file transfer
Protocol (sFTP) into OIC.OIC can retrieve files
for processing or can upload files and message to
a directory on a remote FTP server.
SOAP Adapter
The SOAP Adapter
can consume and external SOAP API in an
Integration in OIC. The Message received from OIC
can be passed as payload to an external SOAP
endpoint by the SOAP Adapter. Any response
received from the endpoint can be sent to the
next action in the integration for further
processing.
REST Adapter
The REST Adapter
can consume any external REST API by configuring
a REST Adapter connection as an invoke.
33
OIC 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
34
Data Mapping Integration
A Visual mapper enables you to define data
mapping between different data structures by
using drag and drop.
Automatically populate target data structures
with information pulled from one or more source
data structures.
Transformation is supposed between XML and XML.
35
Data Mapping Integration
36
Monitoring and Managing Errors in Integration
Can review the information about the completed
run instances and the time for next run.
We can submit, Pause and play to restart the
schedule.
Can view the Errors of Integration, Errors of
Connection and Error Recovery Jobs.
Setting Logging Levels and access Log files.
37
EDI Integration
38
B2B Integration

• B2B for Oracle Integration provides for the
  secure and reliable exchange of business
  documents between Oracle Integration and a
  trading partner.
• B2B works in Orchestrated integration through EDI
  translate action. EDI Translate action supports
  EDI X12 document standard for configuration.

• Select the B2B message direction for this B2B
  action
• Inbound The B2B message is sent from the trading
  partner to the host trading partner.
• Outbound The B2B message is sent from the host
  trading partner.

39
Action Menu for EDI process
Inbound Fetch Message Fetches a B2B business message from the persistence store, given a message identifier. Translate Translates an inbound EDI message to an Oracle Integration message. Mark As Error Marks a B2B business message with a failed processing status.
Outbound Translate Translates an Oracle Integration message to an outbound EDI message. Mark As Error Marks a B2B business message with a failed processing status.
40
EDI Inbound Integration

• Inbound The B2B message is sent from the trading
  partner to the host trading partner.
• Steps to create Inbound EDI Integration
• Create Payload as Inbound a Translate type.
• Create translate type with the below details
• Document standard
• Document Version
• Document type
• Document Definition
• EDI Character Encoding
• Final step to map to receive the EDI

41
EDI Inbound Integration
42
EDI Outbound Integration

• Outbound The B2B message is sent from the host
  trading partner.
• Steps to create Inbound EDI Integration
• Create an output XML Document.
• Create REST trigger with XML Payload
• Create EDI Translate with below details
• Document standard
• Document Version
• Document type
• Document Definition
• EDI Character Encoding
• Create Mapping

43
EDI Outbound Integration
44
EDI Outbound Integration
45
Real-Time Analytics
46
Real-Time Analytics for Business Owners and
Executives
Key Features

• Business monitoring of Integration cloud
  applications and heterogeneous cloud and
  on-premises environments
• Define Business Milestones and Metrics from your
  browser with no coding
• Identify problems when they happen
• Facilitate business to IT Communication

Benefits

• Real-time visibility into the business.
• Puts business owner in control
• Provides early warnings to prevent business
  failure
• No costly development engagement

47
Real- Time Analytics and Monitoring
Oracle Integration Insight
Oracle Integration Insight is tool used to
perform analytics on Oracle Integrations
Applications.
Business metrics in real time is analyzed using
Integration Insight, which includes steps of -
Collecting - Storing - Visualizing - Reporting
For collecting and sorting data, Integration
Insights provides features to create a data
model, where data can be extracted from business
process and stored. Further, these extracted data
can be processed and presented as meaningful
business metrics
48
Recap

• Recent Trends
• Overview of OIC
• OIC Components
• Pre-Build Integrations and Customizing Pre-Build
  Integrations.
• Steps in Creating New Integration
• Connection, Mapping, and Monitoring Integration
• EDI Integration
• Real -Time Analytics and Monitoring

49
Contact Us
50
Thank You
Questions
51
(No Transcript)