Implementing Oracle Integration Cloud Service电子书

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