Download ICS integration for Oracle Cloud and more Study Guides, Projects, Research Computer Science in PDF only on Docsity!
Oracle®^ Cloud
Using Oracle Integration Cloud Service
Release 17.
E55390-
March 2017
This guide describes how to connect applications in the cloud and monitor and manage these running integrations. It also describes how to access and use prebuilt integrations.
Oracle Cloud Using Oracle Integration Cloud Service, Release 17.
E55390-
Copyright ©^ 2015, 2017, Oracle and/or its affiliates. All rights reserved.
Primary Author: Mark Kennedy
Contributing Authors: Larry Hoffman
Contributors: Development, Product Management, and Quality Assurance teams
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency- specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.
iv
- Cloning a Connection 2-
- Deleting a Connection 2-
- Refreshing Integration Metadata 2-
- Managing Security Certificates 2-
- Creating Integrations.............................................................................................................................. 2-
- Creating an Integration.................................................................................................................. 2-
- Understanding Integration Patterns............................................................................................ 2-
- Importing a Prebuilt Integration 2-
- Adding a Trigger (Source) Connection 2-
- Adding an Invoke (Target) Connection 2-
- Creating Orchestrated Integrations 2-
- Creating an Integration to Publish Messages to Oracle Integration Cloud Service 2-
- Creating an Integration to Subscribe to Oracle Integration Cloud Service 2-
- Adding Request and Response Enrichments 2-
- Deleting Request and Response Enrichments............................................................................ 2-
- Creating Routing Paths for Two Different Invoke Endpoints in Integrations 2-
- Creating Routing Expression Logic in Both Expression Mode and Condition Mode 2-
- Deleting Routing Paths.................................................................................................................. 2-
- Editing the Endpoint Information in an Integration................................................................. 2-
- Mapping Data.......................................................................................................................................... 2-
- Creating Mappings......................................................................................................................... 2-
- Modifying Mappings 2-
- Deleting All Mappings 2-
- Mapping Faults............................................................................................................................... 2-
- Adding Customized Mappings to Prebuilt Integrations.......................................................... 2-
- Removing Customized Mappings from Prebuilt Integrations 2-
- Regenerating a WSDL File for Integrations................................................................................ 2-
- Creating Lookups 2-
- Creating a Lookup.......................................................................................................................... 2-
- Adding Adapters or Domain Names to a Lookup.................................................................... 2-
- Cloning a Lookup........................................................................................................................... 2-
- Deleting a Lookup 2-
- Creating the lookupValue Function..................................................................................................... 2-
- Accessing the Build Lookup Function Wizard 2-
- Selecting the Lookup Table........................................................................................................... 2-
- Selecting the Source and Target Columns 2-
- Specifying the Default Value 2-
- Reviewing Your Lookup Table Selections 2-
- Importing Map Files............................................................................................................................... 2-
- Importing a Map File into Oracle JDeveloper............................................................................ 2-
- Importing a Map File into Oracle Integration Cloud Service 2-
- Importing and Exporting Components 2-
- Exporting an Integration 2-
- Importing an Integration............................................................................................................... 2-
- Exporting a Lookup 2-
- Importing a Lookup 2-
- Assigning Business Identifiers for Tracking Fields in Messages 2-
- Assigning Business Identifiers 2-
- Deleting Business Identifiers 2-
- Managing Packages 2-
- Viewing the Integrations in a Package........................................................................................ 2-
- Importing a Package 2-
- Exporting a Package....................................................................................................................... 2-
- Updating a Package 2-
- Deleting a Package 2-
- Managing Agent Groups and the On-Premises Agent 2-
- Creating an Agent Group.............................................................................................................. 2-
- Downloading and Running the On-Premises Agent Installer................................................. 2-
- Creating a Connection with an Agent Group 2-
- Viewing and Editing Agent Groups.......................................................................................... 2-
- Deleting an Agent Group 2-
- Updating Property Values 2-
- Upgrading the On-Premises Agent to Release 17.1.3.............................................................. 2-
- Scheduling Integration Runs............................................................................................................... 2-
- Creating an Integration Schedule 2-
- Starting and Pausing an Integration Schedule......................................................................... 2-
- Viewing Past and Present Integration Runs............................................................................. 2-
- Viewing Future Runs 2-
- Editing an Integration Schedule................................................................................................. 2-
- Deleting an Integration Schedule............................................................................................... 2-
- Monitoring Integration Runs...................................................................................................... 2-
- Creating Ad-Hoc Integration Runs Using the REST API 2-
- Connecting to Oracle Mobile Cloud Service..................................................................................... 2-
- Monitoring Integrations........................................................................................................................... 3- 3 Administering Oracle Integration Cloud Service
- Viewing the Dashboard................................................................................................................... 3-
- Viewing System Health 3-
- Viewing Runtime Health................................................................................................................. 3-
- Viewing Design-Time Metrics........................................................................................................ 3-
- Monitoring Integrations 3-
- Monitoring Agents 3-
- Managing Integrations............................................................................................................................. 3-
- Activating an Integration 3-
- Deactivating an Integration 3-
- Modifying an Integration 3-
- Viewing the Trigger, Invoke, and Enrichment Details of an Integration............................... 3-
- Cloning an Integration................................................................................................................... 3-
- Creating a Draft of an Integration................................................................................................ 3-
- Deleting an Integration.................................................................................................................. 3-
- Tracking Behavior..................................................................................................................... 3- Reactivating Integrations After Instance Upgrade to View the Latest Business Identifier
- Filtering the Display of Integrations By Type 3-
- Changing the Time Zone............................................................................................................... 3-
- Managing Errors 3- - Managing Errors by Integration................................................................................................... 3- - Managing Errors by Connection 3- - Managing Errors by Integration Instance 3- - Resubmitting Failed Messages 3- - Viewing the Status of Message Recovery 3-
- Managing Business Identifiers for Tracking Fields in Messages..................................................... 3- - Tracking Business Identifiers in Integrations During Runtime............................................... 3- - Tracking Business Identifiers in Integrations in Which Routing Paths Are Defined........... 3- - Filtering the Display of Business Identifiers in Integrations.................................................... 3- - Viewing an Instance Payload 3-
- Viewing Preinstalled Adapters and Registering Custom Adapters 3-
- Notification Emails 3- Sending Service Failure Alerts, System Status Reports, and Integration Error Reports by
- Setting Logging Levels and Downloading Diagnostic Logs 3-
- Reporting Incidents 3-
- Configuring Basic Information Properties 4- 4 Adapter Configuration Reference - What You Can Do from the Basic Info Page................................................................................. 4- - What You See on the Basic Info Page 4-
- Configuring Salesforce Properties.......................................................................................................... 4- - Understanding Salesforce Constraints 4- - Configuring Salesforce Trigger Outbound Messaging Properties............................................ 4- - Configuring Salesforce Trigger Response Properties 4- - Configuring Salesforce Trigger Callback Response Properties 4- - Configuring Salesforce Invoke Basic Information Properties.................................................... 4- - Configuring Salesforce Invoke Operation Properties 4- - Configuring Salesforce Invoke Header Properties.................................................................... 4- - Configuring Salesforce Invoke Custom Operations Properties 4- - Performing Salesforce Adapter Postconfiguration Tasks......................................................... 4-
- Configuring Trigger Oracle Integration Cloud Service Messaging 4- - What You Can Do from the Trigger Oracle Integration Cloud Service Messaging Page.... 4- - What You See on the Trigger Oracle Integration Cloud Service Messaging Page 4-
- Reviewing Configuration Values on the Summary Page 4-
- What You Can Do from the Summary Page 4-
- What You See on the Summary Page 4-
- Downloading and Running the On-Premises Oracle Integration Cloud Service Installer............ 5- 5 Using On-Premises Oracle Integration Cloud Service
- Managing Users and Roles...................................................................................................................... 5-
- Creating Users and Assigning Roles 5-
- Editing On-Premises Users 5-
- Deleting On-Premises Users 5-
viii
- Using the Google Calendar Adapter
- Using the Google Task Adapter
- Using the JMS Adapter
- Using the LinkedIn Adapter
- Using the MailChimp Adapter
- Using the Microsoft Calendar Adapter
- Using the Microsoft Contact Adapter
- Using the Microsoft Email Adapter
- Using the Microsoft SQL Server Adapter
- Using the MySQL Adapter
- Using the Oracle Advanced Queuing (AQ) Adapter
- Using the Oracle Commerce Cloud Adapter
- Using the Oracle CPQ Cloud Adapter
- Using the Oracle Database Adapter
- Using Oracle E-Business Suite Adapter
- Using the Oracle Eloqua Cloud Adapter
- Using the Oracle ERP Cloud Adapter
- Using the Oracle Field Service Adapter
- Using the Oracle HCM Cloud Adapter
- Using the Oracle JD Edwards EnterpriseOne Adapter
- Using the Oracle Logistics Adapter
- Using the Oracle Messaging Cloud Service Adapter
- Using the Oracle NetSuite Adapter
- Using the Oracle Responsys Adapter
- Using the Oracle RightNow Cloud Adapter
- Using the Oracle Sales Cloud Adapter
- Using the Oracle Siebel Adapter
- Using the Oracle Utilities Adapter
- Using the REST Adapter
- Using the Salesforce Adapter
- Using the SAP Adapter
- Using the SAP Ariba Adapter
x
- Using the ServiceNow Adapter
- Using the SOAP Adapter
- Using the SuccessFactors Adapter
- Using the SurveyMonkey Adapter
- Using the Trello Adapter
- Using the Twilio Adapter
- Using the Twitter Adapter
Conventions
The following text conventions are used in this document:
Convention Meaning boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.
xi
Getting Started with Oracle Integration
Cloud Service
Review the following topics to learn about how Oracle Integration Cloud Service works. These topics provide information about Oracle Integration Cloud Service concepts and components to help you get started with creating your own integrations.
Topics
- About Oracle Integration Cloud Service
- About Oracle Integration Cloud Service Concepts
- About Monitoring
- About Error Management
- About Business Identifiers for Tracking Fields in Messages
- Starting Oracle Integration Cloud Service
- Navigating Oracle Integration Cloud Service
- About Oracle Integration Cloud Service Roles and User Accounts
About Oracle Integration Cloud Service Oracle Integration Cloud Service is a complete, secure, but lightweight integration solution that enables you to connect your applications in the cloud. It simplifies connectivity between your applications and connects both your applications that live in the cloud and your applications that still live on premises. Oracle Integration Cloud Service provides secure, enterprise-grade connectivity regardless of the applications you are connecting or where they reside. Oracle Integration Cloud Service provides native connectivity to Oracle Software as a Service (SaaS) applications, such as Oracle Sales Cloud, Oracle RightNow Cloud, and so on. Oracle Integration Cloud Service adapters simplify connectivity by handling the underlying complexities of connecting to applications using industry-wide best practices. You only need to create a connection that provides minimal connectivity information for each system. Oracle Integration Cloud Service lookups map the different codes or terms used by the applications you are integrating to describe similar items (such as country or gender codes). Finally, the visual data mapper enables you to quickly create direct mappings between the trigger and invoke data structures. From the mapper, you can also access lookup tables and use standard XPath functions to map data between your applications. Once you integrate your applications and activate the integrations to the runtime environment, the dashboard displays information about the running integrations so you can monitor the status and processing statistics for each integration. The
Getting Started with Oracle Integration Cloud Service 1-
dashboard measures and tracks the performance of your transactions by capturing and reporting key information, such as throughput, the number of messages processed successfully, and the number of messages that failed processing. You can also manage business identifiers that track fields in messages and manage errors by integrations, connections, or specific integration instances.
About Oracle Integration Cloud Service Concepts The following topics describe each of the components required to create an end-to-end integration. Each integration includes connections and mappings. You can also include lookups, which are reusable mappings for the different codes and terms used in your applications to describe the same item. You can also group integrations into packages.
Topics
- About Oracle Integration Cloud Service Connections
- About Oracle Integration Cloud Service Integrations
- About Mappings
- About Oracle Integration Cloud Service Enrichments
- About Oracle Integration Cloud Service Lookups
- About Oracle Integration Cloud Service Packages
- About Agents and Integrations Between On-Premises Applications and Oracle Integration Cloud Service
About Oracle Integration Cloud Service Connections
Connections define information about the instances of each configuration you are integrating. Oracle Integration Cloud Service includes a set of predefined adapters , which are the types of applications on which you can base your connections, such as Oracle Sales Cloud, Oracle Eloqua Cloud, Oracle RightNow Cloud, and others. A connection is based on an adapter. A connection includes the additional information required by the adapter to communicate with a specific instance of an application (this can be referred to as metadata or as connection details). For example, to create a connection to a specific RightNow Cloud application instance, you must select the Oracle RightNow adapter and then specify the WSDL URL, security policy, and security credentials to connect to it.
Video
Connection Creation You can create a connection based on any of the following adapters.
Adapter For Information Adobe eSign Adapter Using the Adobe eSign Adapter Concur Adapter Using the Concur Adapter DB2 Adapter Using the DB2 Adapter
DocuSign Adapter Using the DocuSign Adapter
About Oracle Integration Cloud Service Concepts
1-2 Oracle Cloud Using Oracle Integration Cloud Service
Adapter For Information Oracle Utilities Adapter Oracle Utilities Adapter
REST Adapter Using the REST Adapter Salesforce Adapter Using the Salesforce Adapter SAP Adapter Using the SAP Adapter SAP Ariba Adapter Using the SAP Ariba Adapter Oracle SOAP Adapter Using the SOAP Adapter SuccessFactors Adapter Using the SuccessFactors Adapter SurveyMonkey Adapter Using the SurveyMonkey Adapter Trello Adapter Using the Trello Adapter Twilio Adapter Using the Twilio Adapter Twitter Adapter Using the Twitter Adapter
Oracle Integration Cloud Service Messaging Oracle Integration Cloud Service Messaging enables you to publish messages to and subscribe to messages from Oracle Integration Cloud Service. You may have business use cases in which you need to synchronize objects between applications. For example:
- Create an object in one application that causes the object to be created in other applications. For example, create a new account in Oracle Sales Cloud Adapter, which causes the creation of an Oracle RightNow organization and an Oracle Eloqua account.
- Enable multiple applications to subscribe to Oracle Integration Cloud Service and register for updates.
- Add or remove subscribers without impacting other subscribers or producers.
Oracle Integration Cloud Service Messaging addresses these business requirements through the creation of two types of integrations: one for publishing to Oracle Integration Cloud Service and one for subscribing to Oracle Integration Cloud Service.
- You create an integration that enables you to publish messages to Oracle Integration Cloud Service by selecting the Publish to ICS option in the Create Integration — Select a Pattern dialog. In this integration:
- Oracle Integration Cloud Service is added as an invoke and is automatically configured.
- You configure a trigger (source) adapter (for example, Oracle RightNow, Oracle Sales Cloud, or another).
- The message to pass to Integration Cloud Service is opaque, so no request mapper support is provided.
- No trigger (source) enrichment mapper support is provided.
- Multiple publishers targeting a single message destination is not supported.
About Oracle Integration Cloud Service Concepts
1-4 Oracle Cloud Using Oracle Integration Cloud Service
Note: Modifying the publisher after creating the subscribers can potentially impact the subscribers. For example, if you change the published object, any existing subscriber mappings are impacted.
- You create an integration that enables you to subscribe to messages from Oracle Integration Cloud Service by selecting the Subscribe to ICS option in the Create Integration — Select a Pattern dialog. In this integration:
- Oracle Integration Cloud Service is added as a trigger (source).
- You are prompted to select the published integration to which to subscribe.
- You configure an invoke adapter to subscribe to and receive messages from Oracle Integration Cloud Service.
- Response mapper support is provided between the published object and the subscriber’s application object.
- Trigger (source) enrichment mapper support is provided.
See Creating an Integration to Publish Messages to Oracle Integration Cloud Service and Creating an Integration to Subscribe to Oracle Integration Cloud Service.
About Oracle Integration Cloud Service Integrations
Integrations are the main ingredient of Oracle Integration Cloud Service. An integration includes at the least a trigger (source) connection (for requests sent to Oracle Integration Cloud Service) and invoke (target) connection (for requests sent from Oracle Integration Cloud Service to the target) and the field mapping between those two connections. When you create your integrations, you build on the connections you already created by defining how to process the data for the trigger (source) and invoke (target)
About Oracle Integration Cloud Service Concepts
Getting Started with Oracle Integration Cloud Service 1-
specialized function is also provided for you to reference lookups directly from the mapper.
The mapper supports both qualified and unqualified schemas (that is, schemas without elementFormDefault=”qualified”). Elements and attributes with and without namespace prefixes are also supported.
Substitution groups in schemas are supported. You can see all the substitutable elements in a base element in the mapper, and select the one to use.
Elements and attributes for which mapping is required are identified by a blue asterisk (*) to the left of their names. To display only required fields, click the Filter icon, select Required Fields , and click Apply.
You can also place your cursor over elements and attributes to display specific schema details such as the data type, if mapping is required, and so on. When you place your cursor over some elements and attributes, additional custom annotations can also be displayed. These annotations are currently only available with the Oracle Sales Cloud Adapter. The Oracle Sales Cloud Adapter obtains this information from the applications and annotates it in the integration WSDL. This information is then read and made visible as annotations in the mapper (for example, title and description). This information can help you better understand what data is being mapped.
About Oracle Integration Cloud Service Concepts
Getting Started with Oracle Integration Cloud Service 1-
. Video
Mapping Request Data Between Applications Once you create an integration and have the trigger (source) and invoke (target) in place, you can define how data is mapped between the two data structures.
The mapper appears with the source data structure on the left and the target data structure on the right:
1. Map request data between the source data structure and target data structure. 2. On the toolbar, click Save.
When returning from the mapper, the map icon changes color to indicate it is complete. Once you create a mapping in an integration, you can return to the mapping and make any necessary changes to how you mapped your data. See Mapping Data of Using the Oracle Mapper.
Mapping Response Data Between Applications If your integration pattern contains a response, you can map the response.
1. Map response data between the source data structure and target data structure. 2. On the toolbar, click Save.
When returning from the mapper, the map icon changes color to indicate it is complete.
Once you create a mapping in an integration, you can return to the mapping and make any necessary changes to how you mapped your data.
See Mapping Data of Using the Oracle Mapper.
About Oracle Integration Cloud Service Concepts
1-8 Oracle Cloud Using Oracle Integration Cloud Service
