O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Oracle Integration Cloud Service

Book Description

Understand everything you need to know about Oracle's Integration Cloud Service and how to utilize it optimally for your business

About This Book

  • 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

Who This Book Is For

This book is ideal for any IT professional working with ICS, any Oracle application or cloud solution developer or analyst who wants to work with ICS to deliver business value.

What You Will Learn

  • Use ICS to integrate different systems together without needing to be a developer
  • Gain understanding of what a number of technologies and standards provide – without needing to understand the fine details of those standards and technologies
  • Understand the use of connectors that Oracle provide from technology based connections such as file and database connections to SaaS solutions ranging from Salesforce to Twitter
  • Enrich data and extend SaaS integration to route to different instances
  • Utilize a number of tools to help develop and check that your integrations work before connecting to live systems
  • Introduce and explain integration concepts so that the integrations created are maintainable and sustainable for the longer term
  • Provide details on how to keep up to date with the features that Oracle and partners provide in the future
  • Get special connections developed to work with ICS

In Detail

Businesses are built on data, and applications that access that data. In modern businesses the same cloud-based data stores and applications might be accessed by hundreds of different applications from thousands of different devices via APIs. To make this happen, APIs must be wired together i.e. integrated. Oracle Integration Cloud Service provides a complete method for integrating enterprise applications in the cloud. Integration Cloud Service (ICS) provides a cloud hosted means to integrate systems together using a graphical means to define and represent integrations.

This book will be a comprehensive, hands-on guide to building successful, high-availability integrations on ICS. This book sets out to demonstrate how ICS can be used to effectively implement integrations that work both in the cloud and on premise. It starts with a fast, practical introduction to what ICS can do for your business and then shows how ICS allows you to develop integrations not only quickly but in a way that means they are maintainable and extensible. Gradually it moves into more advanced integrations, showing how to achieve sophisticated results with ICS and work with external applications. Finally the book shows you how to monitor cloud apps and go beyond ICS to build even more powerful integrated applications.

By the end of the book, you will the knowledge on how to use ICS to solve your own integration needs and harness the technologies in a maintainable and sustainable manner.

Style and approach

This book will take a pragmatic approach and will be a business-focused guide to delivering business value with ICS.

Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

Table of Contents

  1. Implementing Oracle Integration Cloud Service
    1. Implementing Oracle Integration Cloud Service
    2. Credits
    3. Foreword
    4. About the Authors
      1. Acknowledgement from both the authors
    5. About the Reviewer
    6. www.PacktPub.com
      1. Why subscribe?
    7. Customer Feedback
    8. Preface
      1. What this book covers
        1. How we have approached this book
      2. What you need for this book
        1. Introduction to apiary
        2. Introducing Mockable
        3. Creating an instance of Integration Cloud Service
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Downloading the color images of this book
        3. Errata
        4. Piracy
        5. Questions
    9. 1. Introducing the Concepts and Terminology
      1. Typical workflow and steps to execute
      2. Connections define our integration points
        1. SaaS adapters
          1. What's the difference with native APIs?
        2. Technology adapters
          1. SOAP adapter
          2. REST adapter
            1. Resource examples
          3. FTP adapter
        3. On-premises adapters
          1. What is the Connectivity Agent?
            1. Architecture Guidelines
            2. Architecture
            3. Message Exchange Patterns
          2. What is the Execution Agent?
            1. Noticeable differences
            2. Restrictions between connectivity and execution agent
        4. Social and productivity adapters
      3. Integrations
        1. Point-to-point integration
        2. Publish-subscribe integration
          1. Topology
          2. Advantages of pub-sub
            1. Scalability
            2. Loosely coupled
          3. Disadvantages of pub-sub
            1. Inflexibility of decoupling
            2. Issues with message delivery
        3. Content-based routing
          1. Topology
          2. Simple example architecture
          3. Advantages of content-based routing
            1. Very efficient
            2. Sophisticated routing decisions
          4. Disadvantages of content-based routing
            1. Additional consumers
            2. Sequential processing
        4. Orchestration for complex integrations
          1. Topology
          2. Practical example
          3. Advantages of Orchestration
            1. Loosely coupled
            2. Enables automation
          4. Disadvantages of Orchestration
      4. Transformation and lookups
        1. Transformations
          1. XQuery
          2. XSLT
            1. XPath expressions
            2. XPath Examples
            3. XLST constructs
        2. Lookups
      5. Summary
    10. 2. Integrating Our First Two Applications
      1. Getting ready
      2. Setting up apiary
        1. Time to switch to integration cloud
      3. Define the necessary connections
        1. Inbound SOAP connection
        2. Outbound REST connection
        3. Troubleshooting
      4. Integrate the two applications
      5. Map message data
      6. Completing and activating the integration
      7. Testing the Integration
      8. Invoke SOAP endpoint using SoapUI
        1. Providing a valid WS-Security header
        2. Invoking the integration for the first time
      9. Monitoring the instance flow
        1. Verifying the message processed by the backend
      10. Summary
    11. 3. Distribute Messages Using the Pub-Sub Model
      1. Getting ready
        1. Setting up Mockable
        2. Setting up SoapUI
      2. Stage 1 - creating the direct connection integration
        1. Defining the connections in ICS
        2. Testing the integration
      3. Stage 2 - reworking to use the pub-sub approach
        1. Defining the publication service
        2. Defining the subscription service
        3. Running the test again
      4. Stage 3 - adding a second subscriber
        1. Setting up a second Mockable.io service
        2. Setting up the subscriber integration
        3. Running the test with two subscribers
      5. Enhanced techniques
        1. Multiple sources
        2. Canonical data model pattern and normalizers
      6. Summary
    12. 4. Integrations between SaaS Applications
      1. Getting ready
        1. Setting up Salesforce
          1. Step 1 - get access to a Salesforce instance
          2. Step 2 - generate the Enterprise service definition
          3. Step 3 - obtain or reset your security token
          4. Step 4 - create workflow rule for escalated cases
          5. Step 5 - define outbound message and generate message WSDL
        2. Setting up Twilio
          1. Step 1 - get access to a Twilio account
          2. Step 2 - create phone number for sending messages
          3. Step 3 - add verified callers IDs
          4. Step 4 - obtain live and/or test API credentials
      2. Define the necessary connections
        1. Troubleshooting
      3. Integrate the SaaS applications
      4. Map message data
        1. Map Salesforce notifications to Twilio requests
        2. Map Twilio's response to Salesforce's case comment
        3. Map Twilio's fault to Salesforce's feed comment
      5. Completing and activating the integration
      6. Testing the integration
        1. Troubleshooting
        2. Next steps
      7. Summary
    13. 5. Going Social with Twitter and Google
      1. Tweet changes in flight schedules
        1. Getting ready
          1. Setting up Twitter
            1. Step 1 - get access to a Twitter account
            2. Step 2 - register a new application
            3. Step 3 - create access token and obtain API credentials
          2. Inbound WSDL with multiple operations
        2. Define the necessary connections
        3. Tweet when a flight schedule has changed
          1. Map message data
            1. Map FlightScheduleUpdate to Twitter's request
            2. Map Twitter's response to ScheduleUpdateResult
            3. Mapping Twitter's fault to BusinessFault
        4. Completing and activating the integration
        5. Testing the integration
          1. Invoke cloud endpoint using SoapUI
          2. Troubleshooting
            1. Twitter rejects duplicate messages
            2. No valid authentication token
            3. No rights to write a tweet on the timeline
      2. Send missing person report by e-mail
        1. Getting ready
          1. Setting up Google
            1. Step 1 - get access to a Google account
            2. Step 2 - register a new project and enable API
            3. Step 3 - create access token and obtain API credentials
        2. Define the necessary connections
        3. E-mail the front desk to report a missing person
          1. Map message data
            1. Map MissingPersonReport to Google's sendMsg request
            2. Map Google's response to MissingPersonResult
            3. Map Twitter's fault to BusinessFault
        4. Completing and activating the integration
        5. Testing the integration
          1. Invoking the Cloud endpoint using SoapUI
          2. Troubleshooting
            1. No valid client ID found
            2. Use of Gmail API is disabled in Google's API Manager
            3. Wrong scope defined for chosen operation
      3. Summary
    14. 6. Creating Complex Transformations
      1. Using variables to enrich messages
        1. Preparation
          1. Client connection
        2. Creating the enriched mapping
        3. Setting up SoapUI and Mockable
          1. Mockable
          2. SoapUI
      2. Enrichment services
        1. Preparation
        2. Creating the connector
        3. Creating the integration
        4. Testing the enriched integration
      3. Using lookups
        1. Creating a lookup
          1. Alternate lookup creation
      4. Incorporating a lookup into a mapping
        1. How to get function documentation
        2. Executing the integration with a lookup
      5. Summary
    15. 7. Routing and Filtering
      1. Preparation
      2. Creating connections
      3. Creating a filtered integration
        1. Applying a filter
        2. Setting up Mockable
        3. Testing the integration
      4. Routing by Message Content
      5. Creating the Routing Integration
        1. Mapping the alternate route
        2. Testing the routing
      6. Extending the filter integration to use a REST source
      7. Creating the trigger REST connection
      8. Cloning the filter integration
      9. Changing the invoke connector
        1. Parameters
        2. HTTP Headers and CORS
        3. Configuring the Request
        4. Reapplying mappings
      10. Defining a multipart filter
      11. Running the REST filter service
      12. Summary
    16. 8. Publish and Subscribe with External Applications
      1. Preparation
        1. Overview of our Java application
        2. Configuring ready to go
      2. OMCS connection
      3. Creating the integration
        1. Configuring Trigger and Invoke
        2. Connecting endpoints and tracking
      4. Testing the integration
      5. Summary
    17. 9. Managed File Transfer with Scheduling
      1. Differences between File and FTP connectors
      2. Scenario
      3. Prerequisites
      4. Setting up FTP locations
        1. Creating the FTP connector
      5. Creating the FTP to FTP integration
        1. How to describe FTP file structure
        2. Scheduling the integration
      6. Using encryption
      7. Common FTP use cases with Orchestration
      8. Extra steps to define structure for file content
      9. Calculated filenames
      10. FTP integrations with interesting behaviors
        1. Using FTP without a schema mapping in Orchestration
        2. Implementing the single value mapping technique
      11. Summary
    18. 10. Advanced Orchestration with Branching and Asynchronous Flows
      1. Getting ready
      2. Setting up Trello
        1. Step 1 – Getting access to a Trello account
        2. Step 2 – Creating a new board and tasks list
        3. Step 3 – Obtaining a list identification
        4. Step 4 – Obtaining API credentials
      3. Updating the apiary Flight API
        1. Step 1 – Log in to apiary and switch the API
        2. Step 2 – Change the source of the API Blueprint
      4. Defining the necessary connections
        1. Checking if all connections are created
      5. Building the orchestration
        1. It uses a different UI and workflow
        2. From simple to more advanced actions
        3. Extracting data into simple variables
        4. Branching the integration into multiple routes
      6. Completing and activating the integration
      7. Testing the orchestration
      8. Invoke a cloud endpoint using SoapUI
      9. Summary
    19. 11. Calling an On-Premises API
      1. What kinds of agents exist?
      2. When can an agent help?
      3. Prerequisites and deploying an agent
        1. Setting up and starting the VM
        2. Checking everything is ready
        3. Agent download
        4. Creating the Agent Group
        5. Installing the Connectivity Agent
        6. Installing the Execution Agent
        7. Differences between execution and connection agents
        8. Upgrading your agent
        9. Starting and stopping the Agent
        10. Troubleshooting
          1. Agent log files
          2. The agent as a WebLogic container
          3. Just start WebLogic
          4. Sanity check the configuration
      4. Building the integration
        1. Preparation
        2. Creating the integration
          1. On-premises database connection
          2. REST connection
          3. Basic Map Data integration
          4. Connecting endpoints and tracking
        3. Testing the integration
      5. Summary
    20. 12. Are My Integrations Running Fine, and What If They Are Not?
      1. Core monitoring information
        1. ICS - all is well
      2. Dashboard
        1. Inducing errors for integrations
      3. Runtime health
      4. Design time metrics
      5. Looking at integrations
      6. Agents view
      7. Tracking view
      8. Errors view
      9. Advanced resolution
        1. Things to check
        2. Examining logs
        3. Reporting incidents and downloading incidents information
        4. Where to go for information about errors
      10. System maintenance windows
      11. Incorporating ICS monitoring into the enterprise
      12. Administration
        1. Certificate management
        2. Changing log levels
        3. E-mail reporting
      13. Summary
    21. 13. Where Can I Go from Here?
      1. Import and export
      2. Import and export scenarios
        1. Controlling change in a live environment
        2. Configuration management
        3. Common service deployment around the world
        4. Pre-built integrations
        5. Synchronizing lookup data
        6. Complex editing and using developer tooling
      3. Exporting and importing integrations
      4. Individual export
      5. Illustrating import and export
      6. Individual import
        1. Regeneration
      7. Lookup export
      8. Lookup import
      9. Packaging
        1. Package export and import
      10. Alternate tools
      11. ICS API
        1. Getting and using cURL
      12. Cloud adapters software development kit
      13. Keeping up to date
      14. Summary