6. Creating Complex Transformations | Implementing Oracle Integration Cloud Service

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Implementing Oracle Integration Cloud Service

By : Robert van Molken

4.3 (4)

Implementing Oracle Integration Cloud Service

4.3 (4)

By: Robert van Molken

Overview of this book

Discover how to use ICS to solve your integration needs with this Oracle Cloud book. Written by Oracle ACE Robert and ACE Associate Phil, you?ll learn how to deliver business value using ICS. ? The only guide to Integration Cloud Service on the market ? A comprehensive guide to building successful integrations on ICS ? Features practical examples and handy tools

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Introducing the Concepts and Terminology

1. Introducing the Concepts and Terminology

Typical workflow and steps to execute

Connections define our integration points

Integrations

Transformation and lookups

Summary

2. Integrating Our First Two Applications

2. Integrating Our First Two Applications

Getting ready

Setting up apiary

Define the necessary connections

Integrate the two applications

Map message data

Completing and activating the integration

Testing the Integration

Invoke SOAP endpoint using SoapUI

Monitoring the instance flow

Summary

3. Distribute Messages Using the Pub-Sub Model

3. Distribute Messages Using the Pub-Sub Model

Getting ready

Stage 1 - creating the direct connection integration

Stage 2 - reworking to use the pub-sub approach

Stage 3 - adding a second subscriber

Enhanced techniques

Summary

4. Integrations between SaaS Applications

4. Integrations between SaaS Applications

Getting ready

Define the necessary connections

Integrate the SaaS applications

Map message data

Completing and activating the integration

Testing the integration

Summary

5. Going Social with Twitter and Google

5. Going Social with Twitter and Google

Tweet changes in flight schedules

Send missing person report by e-mail

Summary

6. Creating Complex Transformations

6. Creating Complex Transformations

Using variables to enrich messages

Enrichment services

Using lookups

Incorporating a lookup into a mapping

Summary

7. Routing and Filtering

7. Routing and Filtering

Preparation

Creating connections

Creating a filtered integration

Routing by Message Content

Creating the Routing Integration

Extending the filter integration to use a REST source

Creating the trigger REST connection

Cloning the filter integration

Changing the invoke connector

Defining a multipart filter

Running the REST filter service

Summary

8. Publish and Subscribe with External Applications

8. Publish and Subscribe with External Applications

Preparation

OMCS connection

Creating the integration

Testing the integration

Summary

9. Managed File Transfer with Scheduling

9. Managed File Transfer with Scheduling

Differences between File and FTP connectors

Scenario

Prerequisites

Setting up FTP locations

Creating the FTP to FTP integration

Using encryption

Common FTP use cases with Orchestration

Extra steps to define structure for file content

Calculated filenames

FTP integrations with interesting behaviors

Summary

10. Advanced Orchestration with Branching and Asynchronous Flows

10. Advanced Orchestration with Branching and Asynchronous Flows

Getting ready

Setting up Trello

Updating the apiary Flight API

Defining the necessary connections

Building the orchestration

Completing and activating the integration

Testing the orchestration

Invoke a cloud endpoint using SoapUI

Summary

11. Calling an On-Premises API

11. Calling an On-Premises API

What kinds of agents exist?

When can an agent help?

Prerequisites and deploying an agent

Building the integration

Summary

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

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

Core monitoring information

Dashboard

Runtime health

Design time metrics

Looking at integrations

Agents view

Tracking view

Errors view

Advanced resolution

System maintenance windows

Incorporating ICS monitoring into the enterprise

Administration

Summary

13. Where Can I Go from Here?

13. Where Can I Go from Here?

Import and export

Import and export scenarios

Exporting and importing integrations

Individual export

Illustrating import and export

Individual import

Lookup export

Lookup import

Packaging

Alternate tools

ICS API

Cloud adapters software development kit

Keeping up to date

Summary

Using lookups

Lookups provide a means to map a value used in one system to how that value is presented in another. For example, our flight data may refer to BA, but if we wanted to incorporate the details into an e-mail, we may want to refer to British Airways. Sometimes, these lookups are referred to as Domain Value Mappings (as the mapping is from one the value represented in one domain or application to another); this is something of a hangover from one of Oracle's other integration products (SOA Suite and Service Bus). The lookup scenario we will be implementing can be shown as follows:

As with the previous enrichment integration, we are going to shortcut the development process by using the Clone option, but this time cloning integration FlightStatusEnquiry_Ch6_1. Complete the clone dialog with the following details:

Property	Description
Integration name	`FlightStatusEnquiry_Ch6_2`
Identifier	This will be proposed based on the integration name and there is no need to change...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Implementing Oracle Integration Cloud Service

Search

Your notes and bookmarks