Implementing Oracle Integration Cloud Service by Molken, Robert van -- Read -- Imperial Library of Trantor

Index

Implementing Oracle Integration Cloud Service

Implementing Oracle Integration Cloud Service Credits Foreword About the Authors

Acknowledgement from both the authors

About the Reviewer www.PacktPub.com

Why subscribe?

Customer Feedback Preface

What this book covers

How we have approached this book

What you need for this book

Introduction to apiary Introducing Mockable Creating an instance of Integration Cloud Service

Who this book is for Conventions Reader feedback Customer support

Downloading the example code Downloading the color images of this book Errata Piracy Questions

1. Introducing the Concepts and Terminology

Typical workflow and steps to execute Connections define our integration points

SaaS adapters

What's the difference with native APIs?

Technology adapters

SOAP adapter REST adapter

Resource examples

FTP adapter

On-premises adapters

What is the Connectivity Agent?

Architecture Guidelines Architecture Message Exchange Patterns

What is the Execution Agent?

Noticeable differences Restrictions between connectivity and execution agent

Social and productivity adapters

Integrations

Point-to-point integration Publish-subscribe integration

Topology Advantages of pub-sub

Scalability Loosely coupled

Disadvantages of pub-sub

Inflexibility of decoupling Issues with message delivery

Content-based routing

Topology Simple example architecture Advantages of content-based routing

Very efficient Sophisticated routing decisions

Disadvantages of content-based routing

Additional consumers Sequential processing

Orchestration for complex integrations

Topology Practical example Advantages of Orchestration

Loosely coupled Enables automation

Disadvantages of Orchestration

Transformation and lookups

Transformations

XQuery XSLT

XPath expressions XPath Examples XLST constructs

Lookups

Summary

2. Integrating Our First Two Applications

Getting ready Setting up apiary

Time to switch to integration cloud

Define the necessary connections

Inbound SOAP connection Outbound REST connection Troubleshooting

Integrate the two applications Map message data Completing and activating the integration Testing the Integration Invoke SOAP endpoint using SoapUI

Providing a valid WS-Security header Invoking the integration for the first time

Monitoring the instance flow

Verifying the message processed by the backend

Summary

3. Distribute Messages Using the Pub-Sub Model

Getting ready

Setting up Mockable Setting up SoapUI

Stage 1 - creating the direct connection integration

Defining the connections in ICS Testing the integration

Stage 2 - reworking to use the pub-sub approach

Defining the publication service Defining the subscription service Running the test again

Stage 3 - adding a second subscriber

Setting up a second Mockable.io service Setting up the subscriber integration Running the test with two subscribers

Enhanced techniques

Multiple sources Canonical data model pattern and normalizers

Summary

4. Integrations between SaaS Applications

Getting ready

Setting up Salesforce

Step 1 - get access to a Salesforce instance Step 2 - generate the Enterprise service definition Step 3 - obtain or reset your security token Step 4 - create workflow rule for escalated cases Step 5 - define outbound message and generate message WSDL

Setting up Twilio

Step 1 - get access to a Twilio account Step 2 - create phone number for sending messages Step 3 - add verified callers IDs Step 4 - obtain live and/or test API credentials

Define the necessary connections

Troubleshooting

Integrate the SaaS applications Map message data

Map Salesforce notifications to Twilio requests Map Twilio's response to Salesforce's case comment Map Twilio's fault to Salesforce's feed comment

Completing and activating the integration Testing the integration

Troubleshooting Next steps

Summary

5. Going Social with Twitter and Google

Tweet changes in flight schedules

Getting ready

Setting up Twitter

Step 1 - get access to a Twitter account Step 2 - register a new application Step 3 - create access token and obtain API credentials

Inbound WSDL with multiple operations

Define the necessary connections Tweet when a flight schedule has changed

Map message data

Map FlightScheduleUpdate to Twitter's request Map Twitter's response to ScheduleUpdateResult Mapping Twitter's fault to BusinessFault

Completing and activating the integration Testing the integration

Invoke cloud endpoint using SoapUI Troubleshooting

Twitter rejects duplicate messages No valid authentication token No rights to write a tweet on the timeline

Send missing person report by e-mail

Getting ready

Setting up Google

Step 1 - get access to a Google account Step 2 - register a new project and enable API Step 3 - create access token and obtain API credentials

Define the necessary connections E-mail the front desk to report a missing person

Map message data

Map MissingPersonReport to Google's sendMsg request Map Google's response to MissingPersonResult Map Twitter's fault to BusinessFault

Completing and activating the integration Testing the integration

Invoking the Cloud endpoint using SoapUI Troubleshooting

No valid client ID found Use of Gmail API is disabled in Google's API Manager Wrong scope defined for chosen operation

Summary

6. Creating Complex Transformations

Using variables to enrich messages

Preparation

Client connection

Creating the enriched mapping Setting up SoapUI and Mockable

Mockable SoapUI

Enrichment services

Preparation Creating the connector Creating the integration Testing the enriched integration

Using lookups

Creating a lookup

Alternate lookup creation

Incorporating a lookup into a mapping

How to get function documentation Executing the integration with a lookup

Summary

7. Routing and Filtering

Preparation Creating connections Creating a filtered integration

Applying a filter Setting up Mockable Testing the integration

Routing by Message Content Creating the Routing Integration

Mapping the alternate route Testing the routing

Extending the filter integration to use a REST source Creating the trigger REST connection Cloning the filter integration Changing the invoke connector

Parameters HTTP Headers and CORS Configuring the Request Reapplying mappings

Defining a multipart filter Running the REST filter service Summary

8. Publish and Subscribe with External Applications

Preparation

Overview of our Java application Configuring ready to go

OMCS connection Creating the integration

Configuring Trigger and Invoke Connecting endpoints and tracking

Testing the integration Summary

9. Managed File Transfer with Scheduling

Differences between File and FTP connectors Scenario Prerequisites Setting up FTP locations

Creating the FTP connector

Creating the FTP to FTP integration

How to describe FTP file structure Scheduling the integration

Using encryption Common FTP use cases with Orchestration Extra steps to define structure for file content Calculated filenames FTP integrations with interesting behaviors

Using FTP without a schema mapping in Orchestration Implementing the single value mapping technique

Summary

10. Advanced Orchestration with Branching and Asynchronous Flows

Getting ready Setting up Trello

Step 1 – Getting access to a Trello account Step 2 – Creating a new board and tasks list Step 3 – Obtaining a list identification Step 4 – Obtaining API credentials

Updating the apiary Flight API

Step 1 – Log in to apiary and switch the API Step 2 – Change the source of the API Blueprint

Defining the necessary connections

Checking if all connections are created

Building the orchestration

It uses a different UI and workflow From simple to more advanced actions Extracting data into simple variables Branching the integration into multiple routes

Completing and activating the integration Testing the orchestration Invoke a cloud endpoint using SoapUI Summary

11. Calling an On-Premises API

What kinds of agents exist? When can an agent help? Prerequisites and deploying an agent

Setting up and starting the VM Checking everything is ready Agent download Creating the Agent Group Installing the Connectivity Agent Installing the Execution Agent Differences between execution and connection agents Upgrading your agent Starting and stopping the Agent Troubleshooting

Agent log files The agent as a WebLogic container Just start WebLogic Sanity check the configuration

Building the integration

Preparation Creating the integration

On-premises database connection REST connection Basic Map Data integration Connecting endpoints and tracking

Testing the integration

Summary

12. Are My Integrations Running Fine, and What If They Are Not?

Core monitoring information

ICS - all is well

Dashboard

Inducing errors for integrations

Runtime health Design time metrics Looking at integrations Agents view Tracking view Errors view Advanced resolution

Things to check Examining logs Reporting incidents and downloading incidents information Where to go for information about errors

System maintenance windows Incorporating ICS monitoring into the enterprise Administration

Certificate management Changing log levels E-mail reporting

Summary

13. Where Can I Go from Here?

Import and export Import and export scenarios

Controlling change in a live environment Configuration management Common service deployment around the world Pre-built integrations Synchronizing lookup data Complex editing and using developer tooling

Exporting and importing integrations Individual export Illustrating import and export Individual import

Regeneration

Lookup export Lookup import Packaging

Package export and import

Alternate tools ICS API

Getting and using cURL

Cloud adapters software development kit Keeping up to date Summary

← Prev
Back
Next →

← Prev
Back
Next →