Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Implementing Oracle Integration Cloud Service
Implementing Oracle Integration Cloud Service

Implementing Oracle Integration Cloud Service: Click here to enter text.

eBook
€24.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents Preview book icon Preview Book

Implementing Oracle Integration Cloud Service

Chapter 2. Integrating Our First Two Applications

In the previous chapter we looked at the components that make up an integration; and introduced the concepts surrounding the different types of connections and integration patterns. This book we will demonstrate the different kinds of use cases that can be implemented with Oracle Integration Cloud Service.

In this chapter we will create our first integration, and experience the first practical use of Integration Cloud Service, which will be illustrated by integrating two systems together. It explains, using a step-by-step approach, the actions of creating an integration.

As we mentioned in the preface, to make our use cases available to everyone we will use services that are free-to-play and do not cost us an extra investment in terms of money. The integration we are going to build in this chapter, does not use live APIs offered on websites, such as FlightAware (https://flightaware.com) and UrTheCast (https://urthecast.com), but...

Getting ready

Before we build our first integration, let's get acquainted with the APIs we are going to use in this first service. As shown in the preceding diagram our inbound call is a SOAP request and therefore we need a WSDL definition which defines the inbound API. Our outbound call is a REST request to a service we host on apiary (https://apiary.io) and uses the API Blueprint standard (https://apiblueprint.org) to define the REST API.

Let's start with the inbound or source definition as shown in the following screenshot. The WSDL has one operation which uses an input, output, and a fault message:

Getting ready

The messages reference an XSD which defines the structure for our input, output, and fault message is as follows:

Getting ready

The WSDL is available in the downloads as ICSBook-Ch2-FlightAirlines-Source.WSDL.

As you can see the WSDL contains one synchronous operation called AllAirlines, which uses elements from the embedded XML schema for the input, output, and fault message. In Chapter 1,Introducing...

Setting up apiary

Before we start creating the integration, let's set up our backend REST API with the tools needed to receive and mock our web service calls. With Apiary we can design and mock our APIs without writing a single line of code. Upon visiting apiary.io (https://apiary.io), we are welcomed with direct access to sign up for the service. If you have a GitHub account you can sign up just by logging in, but you also have the option to sign up using a Twitter account or your existing account.

Once signed up and signed in to Apiary we can create our new API by picking the default name, which is the same as your username, or choose a different one as shown in the following screenshot:

Setting up apiary

After choosing a name you will see the main editor where we can build our API. For a quick start, apiary supplies a demo API. You can look at this to get a feeling of the syntax that is used and get familiar with the UI.

Replace the contents of the editor with the ICS Flights API. The API Blueprint...

Define the necessary connections

Because creating connections is one of the core components of an integration, we can easily navigate to the designer portal and start creating connections.

On the home page, click the Create link of the Connection tile:

Define the necessary connections

The Connections page will load; this lists all created connections, and a modal dialog automatically opens on top of the list. This pop-up shows all the adapter types we can create. As we explained in Chapter 1,Introducing the Concepts and Terminology, there are a few types of adapters. For our first integration we define two technology adapter connections: An inbound SOAP connection and an outbound REST connection.

Inbound SOAP connection

In the pop-up we can scroll down the list and find the SOAP adapter, but the modal dialog also includes a search field. Just search on SOAPand the list will show the adapters matching the search criteria as shown in the following screenshot:

Inbound SOAP connection

Tip

Find your adapter by searching on the name or change the appearance...

Integrate the two applications

Now that we have created two connections, we can integrate our applications by creating the integration. From the Connections page of the developer portal, we can navigate to the Integrations page, to create our first integration by clicking the Integrations link in the menu at the left side of the page, as shown in the following screenshot:

Integrate the two applications

Let's click the New Integration button. We are presented with a pop-up that gives us multiple patterns to create an integration as shown in the next screenshot. We discussed these integration patterns in Chapter 1, Introducing the Concepts and Terminology:

Integrate the two applications

Select the Basic Map Data pattern for our first point-to-point integration. Before we can setup any integration, every creation starts with choosing a name, version, package name, and an optional description as shown in the following screenshot:

Integrate the two applications

Create the integration with the details given in the following table:

Property

Description

Integration Name...

Map message data

Now that we finished the initial integration between our two applications it is time to map the incoming SOAP request message to the REST outbound message. The same goes for mapping the REST response message to the SOAP outbound message.

Currently our integrations looks as follows:

Map message data

Mappings can be created or imported (from local disk) by clicking on the icon in the center of the integration. From top to bottom we will define the request, response, and fault mapping. First click on the request mapping and then on the plus sign, to create a new mapping. We are presented with a feature full mapping UI which has all capabilities that XSLT supports. In this chapter, we will not go into detail about all these capabilities, but we will touch base on them during later chapters.

The default view shows us the source message on the left and the target message on the right. The nodes to map depend on the selected adapters. Our target message doesn't have any leaf nodes, but we...

Getting ready


Before we build our first integration, let's get acquainted with the APIs we are going to use in this first service. As shown in the preceding diagram our inbound call is a SOAP request and therefore we need a WSDL definition which defines the inbound API. Our outbound call is a REST request to a service we host on apiary (https://apiary.io) and uses the API Blueprint standard (https://apiblueprint.org) to define the REST API.

Let's start with the inbound or source definition as shown in the following screenshot. The WSDL has one operation which uses an input, output, and a fault message:

The messages reference an XSD which defines the structure for our input, output, and fault message is as follows:

The WSDL is available in the downloads as ICSBook-Ch2-FlightAirlines-Source.WSDL.

As you can see the WSDL contains one synchronous operation called AllAirlines, which uses elements from the embedded XML schema for the input, output, and fault message. In Chapter 1,Introducing the...

Setting up apiary


Before we start creating the integration, let's set up our backend REST API with the tools needed to receive and mock our web service calls. With Apiary we can design and mock our APIs without writing a single line of code. Upon visiting apiary.io (https://apiary.io), we are welcomed with direct access to sign up for the service. If you have a GitHub account you can sign up just by logging in, but you also have the option to sign up using a Twitter account or your existing account.

Once signed up and signed in to Apiary we can create our new API by picking the default name, which is the same as your username, or choose a different one as shown in the following screenshot:

After choosing a name you will see the main editor where we can build our API. For a quick start, apiary supplies a demo API. You can look at this to get a feeling of the syntax that is used and get familiar with the UI.

Replace the contents of the editor with the ICS Flights API. The API Blueprint is available...

Define the necessary connections


Because creating connections is one of the core components of an integration, we can easily navigate to the designer portal and start creating connections.

On the home page, click the Create link of the Connection tile:

The Connections page will load; this lists all created connections, and a modal dialog automatically opens on top of the list. This pop-up shows all the adapter types we can create. As we explained in Chapter 1,Introducing the Concepts and Terminology, there are a few types of adapters. For our first integration we define two technology adapter connections: An inbound SOAP connection and an outbound REST connection.

Inbound SOAP connection

In the pop-up we can scroll down the list and find the SOAP adapter, but the modal dialog also includes a search field. Just search on SOAPand the list will show the adapters matching the search criteria as shown in the following screenshot:

Tip

Find your adapter by searching on the name or change the appearance...

Integrate the two applications


Now that we have created two connections, we can integrate our applications by creating the integration. From the Connections page of the developer portal, we can navigate to the Integrations page, to create our first integration by clicking the Integrations link in the menu at the left side of the page, as shown in the following screenshot:

Let's click the New Integration button. We are presented with a pop-up that gives us multiple patterns to create an integration as shown in the next screenshot. We discussed these integration patterns in Chapter 1, Introducing the Concepts and Terminology:

Select the Basic Map Data pattern for our first point-to-point integration. Before we can setup any integration, every creation starts with choosing a name, version, package name, and an optional description as shown in the following screenshot:

Create the integration with the details given in the following table:

Property

Description

Integration Name

Enter...

Map message data


Now that we finished the initial integration between our two applications it is time to map the incoming SOAP request message to the REST outbound message. The same goes for mapping the REST response message to the SOAP outbound message.

Currently our integrations looks as follows:

Mappings can be created or imported (from local disk) by clicking on the icon in the center of the integration. From top to bottom we will define the request, response, and fault mapping. First click on the request mapping and then on the plus sign, to create a new mapping. We are presented with a feature full mapping UI which has all capabilities that XSLT supports. In this chapter, we will not go into detail about all these capabilities, but we will touch base on them during later chapters.

The default view shows us the source message on the left and the target message on the right. The nodes to map depend on the selected adapters. Our target message doesn't have any leaf nodes, but we are still...

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • • The only guide to Integration Cloud Service in the market
  • • Focused on practical action to deliver business value
  • • A professional’s guide to an expensive product, providing comprehensive training, and showing how to extract real business value from the product

Description

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

Who is this book for?

Who is this book for? ? A range of readers from Citizen Integrators to software architects and developers ? Web developers and others with no knowledge of WebStorm but are experienced in JavaScript, Node.js, HTML and CSS

What you will learn

  • After a practical introduction to ICS capabilities, you?ll find out how to use ICS to integrate different systems together. Discover advanced integrations and learn how to achieve sophisticated results using ICS, before covering cloud app monitoring and even more powerful integrated applications.

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jan 20, 2017
Length: 506 pages
Edition : 1st
Language : English
ISBN-13 : 9781786469564
Vendor :
Oracle
Category :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Jan 20, 2017
Length: 506 pages
Edition : 1st
Language : English
ISBN-13 : 9781786469564
Vendor :
Oracle
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 141.97
Implementing Oracle Integration Cloud Service
€45.99
Oracle Business Intelligence Enterprise Edition 12c
€53.99
Implementing Oracle API Platform Cloud Service
€41.99
Total 141.97 Stars icon

Table of Contents

13 Chapters
1. Introducing the Concepts and Terminology Chevron down icon Chevron up icon
2. Integrating Our First Two Applications Chevron down icon Chevron up icon
3. Distribute Messages Using the Pub-Sub Model Chevron down icon Chevron up icon
4. Integrations between SaaS Applications Chevron down icon Chevron up icon
5. Going Social with Twitter and Google Chevron down icon Chevron up icon
6. Creating Complex Transformations Chevron down icon Chevron up icon
7. Routing and Filtering Chevron down icon Chevron up icon
8. Publish and Subscribe with External Applications Chevron down icon Chevron up icon
9. Managed File Transfer with Scheduling Chevron down icon Chevron up icon
10. Advanced Orchestration with Branching and Asynchronous Flows Chevron down icon Chevron up icon
11. Calling an On-Premises API Chevron down icon Chevron up icon
12. Are My Integrations Running Fine, and What If They Are Not? Chevron down icon Chevron up icon
13. Where Can I Go from Here? Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.3
(4 Ratings)
5 star 50%
4 star 25%
3 star 25%
2 star 0%
1 star 0%
ewomack Jan 14, 2018
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
As cloud-based SaaS programs come to dominate IT enterprises, the need to share data between such programs becomes critical. Exporting and importing flat files, such as .csv files, won't typically meet the needs of organizations rife with data that requires frequent and rapid updates. An integration platform, ideally also in the cloud with automation capabilities, can help fill this gap. Oracle's Integration Cloud Service, or ICS, provides functionality to integrate cloud-based applications within the cloud itself, although it does also support integration with on-premise platforms. Connecting two SaaS applications with ICS shouldn't pose too much of a problem for anyone familiar with basic integration principles, but some may find Oracle's online ICS tutorials less than exhaustive. Thankfully, the era of the book has not faded completely, not yet at least, in early 21st century digital culture and anyone seeking more in-depth information on ICS can turn to Packt Publishing's "Implementing Oracle Integration Cloud Service." In block paper form, the book does suffer the same fate as many fibrous technology references in that it can't update itself, so consider the first edition frozen in time at January, 2017. As such, expect screen shots that don't exactly match the current ICS interface, ancillary applications that differ somewhat as described and, of course, no descriptions of any new functionality following publication. New editions, paper or electronic, will hopefully provide updates as the book will likely age rapidly in the hyper-dynamic cloud era. Currently, this book stands as one of the only, if not the only, book length treatment of ICS.Everything begins where it should, with the basics. A preface gives a general overview of recent terms such as SaaS, PaaS, IaaS and where ICS fits into this landscape and into the Oracle tool suite. The book assumes no previous knowledge with any of these concepts or any prior experience with ICS. Those who want to really learn the platform hands on will need access to ICS either through a licensed version or via a 30-day free trial. Each chapter also uses numerous tools, such as SoapUI, cURL and VirtualBox, to simulate real-world scenarios. Other tools such as Apiary and Mockable simulate web services for convenience, so readers won't have to create their own full-blown services to run the book's examples. Once again, some of these tools may have evolved since the book's publication. The first chapter delineates a typical ICS workflow with connectors, adapters, integrations, mappings and agents. Agents come into play with on-premise integrations. Short discussions of different integration types, such as point-to-point, publish-subscribe, content-based routing and orchestration provide previews of subsequent chapters. A very brief outline of transformations, XSLT, XPath and Lookups closes this introductory chapter. All of this sets the stage for the book's first real integration that uses an airline messaging scenario between SOAP and REST connections. Apiary and SoapUI provide the framework to complete the integration. Setting up these tools arguably takes up just as much, or perhaps more, time than setting up Oracle ICS itself.Subsequent integrations use different patterns and SaaS platforms to demonstrate ICS's capabilities. These include a Pub-Sub integration, a Salesforce integration using outbound messages, WSDLs and Twilio, and an integration using Twitter and the GMail API. Transformations and Lookups for enriching information in process appear in Chapter 6. Filtering using ICS's condition builder and Routing with logic based on data conditions appear in Chapter 7. Integrations with external applications, Chapter 8 uses a sample Java application and the OMCS connection, show how ICS can works with non-cloud based resources. Anyone wanting to transfer files with ICS should consult Chapter 9's discussion of the FTP connector, which also introduces orchestration, scheduling and encryption. Chapter 10 brings orchestration to the forefront by showing its workflow, routing, variable and logic capabilities. Orchestration can probably do just about anything, though this chapter only shows a simpler examples, probably due to obvious space restrictions. Chapter 11 takes things on-premise and talk about connection and execution agents, deploying agents to a VirtualBox instance and performing an integration. It also includes a basic integration with a simple Oracle database. Chapter 12 talks about the crucial topic of monitoring, or making sure that integrations don't fail, or at least knowing when they do. It outlines the dashboard, logs, error codes, maintenance windows and certificates. A final chapter gives advice on how to further expand one's ICS experience and knowledge with more advanced concepts such as importing and exporting integrations, pre-built integrations, packaging and the ICS API with examples using cURL."Implementing Oracle Integration Cloud Service" provides a decent introduction to this highly flexible cloud-based tool. It covers enough of the ICS landscape to get just about anyone started happily integrating. Of course no book can cover everything and this book by necessity leaves out integrations with non-Oracle products such as Microsoft SQL Server. In such cases one must peruse the not always intuitive Oracle documentation. Not only that, the book has already dated and some of the tools used have changed enough to make certain instructions no longer applicable. A little research or fiddling around will solve these problems relatively quickly, but some examples do require effort outside of just miming the book's text. Plus, readers will have to explore all of the possibilities of Orchestration integrations on their own as the book covers only a smidgen of this advanced topic. Ultimately, it doesn't seem fair to call this the best book on Oracle ICS because it appears to be the only book on Oracle ICS readily available. At the very least, it builds a solid foundation upon which to build future ICS experience. One has to start somewhere.
Amazon Verified review Amazon
SUBBURAJ RAJ May 03, 2017
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
Good Introductory book.
Amazon Verified review Amazon
Rolando Carrasco Apr 08, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is a great book.Why is a great book? For many reasons:1. It is very well written.2. All the examples and scenarios that are described are very clear and useful for the reader3. The content is good for a person that is new with Oracle ICS and also for a person who wants to go deeper with the product4. Even though Oracle ICS, as well as the other Oracle Cloud products, are being updated every 2-3 months, the book contains the core functionality that is useful today and it will be tomorrow.5. The book is also useful to undrerstand how things are integrated in the cloud. It also covers scenarios of on.premise to cloud integration, or cloud to on.premise integration6. The authors are professionals with a lot of experience. They really put their print in the book. They are experts in the topic7. The book is useful for a person who wants to go through the samples and test them on its own environment, or just go through the concepts. It will help both audiences.I really enjoyed reading it and it helped me a lot to understand every piece of Oracle ICS.
Amazon Verified review Amazon
deepak dev Mar 23, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Brilliant for ICS Developers. Pretty Detailed
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.