Book Image

Implementing Oracle Integration Cloud Service

Book Image

Implementing Oracle Integration Cloud Service

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
Table of Contents (21 chapters)
Implementing Oracle Integration Cloud Service
Credits
Foreword
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Building the integration


With an agent deployed, having addressed the reasons for having an agent, we can explore our scenario. As mentioned in the introduction in this chapter, we are going to demonstrate the detection of additions or changes to Airport data within an on-premises database by a connection agent. The database records that are detected as having been changed by the agent are then sent to the core ICS server running in the Oracle cloud to pass through the integration and be transmitted to the target. This reflects the sort of scenarios you could find when perhaps needing to integrate an on-premises E-Business Suite (EBS) that uses the idea of open tables as its interface. EBS, like many enterprise solutions, will offer an interface by exposing a view of its data that the outside world can interact with.

When we detect the data change on the on-premises database, the record will be retrieved and concatenated into a string that is sent to a Mockable REST endpoint. This second...