9. Managed File Transfer with Scheduling | 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

Calculated filenames

We can also configure the integration to name the file or target folder based on the integration payload. Within a mapping view, you will be able to see an entry called OutboundFTPHeaderType, within this are elements called fileName and directory. By manipulating these values, we can dynamically set the filename and location of the output.

For example, if we are going to set the filename to be the test Id followed by the actual Id element from the source and set to be a .txt file, we can get a result such as Id9001.txt for a file. To do this we need to concatenate the literal values with Id element from the source. Click on the value filename on the target side of the tree to access the Build Mappings screen. Once in the Mapping screen, we need to drop the concat function onto the statement side of the editor (concat can be found by navigating the left menu to Mapping Components | Functions | String).

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