Oracle® Cloud

What’s New for Oracle Autonomous Integration Cloud

E84902-08

June 2018

What’s New for Oracle Autonomous Integration Cloud

Learn about the new features available with the first release of Oracle Autonomous Integration Cloud.

May 2018

New Common Features
Feature Description

Oracle Autonomous Integration Cloud support

Oracle Autonomous Integration Cloud is a new Oracle-managed service offering that provides a unified platform in which you can automate processes, integrate applications, analyze results, and visually build custom enterprise applications. You install Oracle Autonomous Integration Cloud, but Oracle manages your service instance, including performing backups, upgrades, patching, scaling in/out, database administration, and more. This enables you to concentrate fully on designing and deploying your applications.

See What is Oracle Autonomous Integration Cloud of Administering Oracle Autonomous Integration Cloud.

Support for Oracle Autonomous Integration Cloud on Oracle Cloud Infrastructure

Oracle Autonomous Integration Cloud runs on Oracle Cloud Infrastructure. Oracle Cloud Infrastructure combines the elasticity and utility of public cloud with the granular control, security, and predictability of on-premises infrastructure to deliver high-performance, high availability, and cost-effective infrastructure services. Oracle Cloud Infrastructure is an enterprise cloud, capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern serverless and container-based architectures.

See Oracle Cloud Infrastructure and What is Oracle Autonomous Integration Cloud of Administering Oracle Autonomous Integration Cloud.

New Integrations Features
Feature Description

On-premises connectivity agent

The next generation connectivity agent with a significantly smaller foot print of less than 150 MB is delivered with Oracle Autonomous Integration Cloud. This enables you to build integrations that can exchange messages between Oracle Autonomous Integration Cloud and on-premises assets behind a fire wall. The connectivity agent is certified to run on JDK 8 and 9. The agent is certified to run on OEL 6 and 7, RHEL 6 and 7, SUSE Enterprise 12, and Windows Standard 2016. This next-generation connectivity agent eliminates the need for you to manually upgrade the agent whenever Oracle Autonomous Integration Cloud is upgraded. The agent upgrade occurs automatically whenever Oracle Autonomous Integration Cloud is upgraded/patched.

With a significant reduction in foot print, the download and installation of the connectivity agent are completed in less than a few minutes.

See About Agents and Integrations Between On-Premises Applications and Oracle Integration Cloud and Downloading and Running the Connectivity Agent Installer of Using Integrations in Oracle Autonomous Integration Cloud.

FTP Adapter - GZIP support

With the support of this feature, your customers/partners can upload files to sFTP/FTP servers as GZIP files. The FTP Adapter can download, uncompress the GZIP files, and stage them for downstream processing.

See FTP Adapter Capabilities of Using the FTP Adapter with Oracle Autonomous Integration Cloud.

FTP Adapter - Read file operation file size support

The FTP Adapter now supports reading files up to 10 MB in size with the read file operation. With this capability, additional modeling and processing activities needed for downloading and staging the files and using a stage file action for reading the file in segments are eliminated for processing files up to 10 MB in size.

See What You See on the FTP Adapter Invoke Operations Properties Page of Using the FTP Adapter with Oracle Autonomous Integration Cloud.

Oracle Commerce Cloud Adapter - New business objects

New trigger request and invoke operation business objects are provided. For invoke connections, files, audiences, organization requests, and bulk import/export process operation business objects are provided.

See Adding the Oracle Commerce Cloud Adapter Connection to an Integration of Using the Oracle Commerce Cloud Adapter with Oracle Autonomous Integration Cloud.

REST Adapter - OAuth 1.0 One Legged Authentication

The OAuth 1.0 One Legged Authentication security policy enables web sites or applications (consumers) to access protected resources from a web service (service provider) through an API without requiring you to disclose your service provider credentials to consumers.

An Oracle NetSuite application, for example, protects the RESTlets using OAuth 1.0a token-based authentication. You can use the REST Adapter to invoke Oracle NetSuite REST APIs using a connection configured with this policy.

See How Do I Configure the REST Adapter to Consume a REST API Protected with OAuth 1.0a One-Legged Authentication of Using the REST Adapter with Oracle Autonomous Integration Cloud.

REST Adapter and SOAP Adapter - Size enforcements on messages and attachments

The REST Adapter and SOAP Adapter enforce new size limits on messages and attachments.

For the REST Adapter, there are multipart request and responses in the inbound and outbound directions, respectively. The size limit on attachments is applicable in both the inbound and outbound directions, getting the response from the external service. For example, the REST Adapter trigger cannot take more than 1 GB of attachments combined. Assume there are two multipart attachments that are 500 MB in size. Only two attachments can be sent in that request as the inbound limit is 1 GB. This is the same with outbound responses, if an external service is sending two multipart attachments of 500 MB in size. Only two attachments can be consumed because the outbound response limit is 1 GB for the total number of attachments.

See REST Adapter Capabilities of Using the REST Adapter with Oracle Autonomous Integration Cloud.

See SOAP Adapter Capabilities of Using the SOAP Adapter with Oracle Autonomous Integration Cloud.

Describing data definitions using a set of XML schema definitions in the REST Adapter, FTP Adapter, and File Adapter (complex schema support)

Do you have the need to describe the data structure for an XML-formatted message/file using a set of XML schema definitions (XSD)? Starting with this release, the FTP Adapter, File Adapter, and REST Adapter now allow for an archive (ZIP) of XML schema definitions to be uploaded to describe the data structure. The FTP Adapter and File Adapter provide this capability for read and write operations. The REST Adapter provides this support for describing the data structure when the application/XML content type is selected for request and/or response messages in both trigger and invoke connections.

See REST Adapter Capabilities of Using the REST Adapter with Oracle Autonomous Integration Cloud, FTP Adapter Capabilities of Using the FTP Adapter with Oracle Autonomous Integration Cloud, and File Adapter Capabilities of Using the File Adapter with Oracle Autonomous Integration Cloud.

Describing data definitions using a sample XML document in the REST Adapter, FTP Adapter, and File Adapter

The REST Adapter, FTP Adapter, and File Adapter now allow you to upload sample XML documents to provide data definitions for XML-formatted messages/files. The FTP Adapter and File Adapter provide this capability for read and write operations on XML-formatted files. The REST Adapter provides support for describing the data structure when the application/XML content type is selected for request and/or response messages in both trigger and invoke connections.

See REST Adapter Capabilities of Using the REST Adapter with Oracle Autonomous Integration Cloud, FTP Adapter Capabilities of Using the FTP Adapter with Oracle Autonomous Integration Cloud, and File Adapter Capabilities of Using the File Adapter with Oracle Autonomous Integration Cloud.

Describing data definitions using a sample JSON document in the REST Adapter, FTP Adapter, and File Adapter

The REST Adapter, FTP Adapter, and File Adapter now support for allowing customers to upload sample JSON documents for describing the data definitions. The FTP Adapter and File Adapter provide this capability for read and write operations for JSON-formatted files. The REST Adapter provides this support for furnishing the data definition when the application/JSON content type is selected for request and/or response messages in both trigger and invoke connections.

See REST Adapter Capabilities of Using the REST Adapter with Oracle Autonomous Integration Cloud, FTP Adapter Capabilities of Using the FTP Adapter with Oracle Autonomous Integration Cloud, and File Adapter Capabilities of Using the File Adapter with Oracle Autonomous Integration Cloud.

Oracle Siebel Adapter IP2017 certification

Oracle Siebel Adapter is certified on IP2017.

See the Oracle Integration Adapters Certification matrix.

Oracle Database Adapter - Bulk data import support for insert and update operations

Oracle Autonomous Integration Cloud is delivering a much-sought after feature - the Oracle Database Adapter allows integration developers to declaratively define an insert-only operation and update-only operation on one or more tables. This new feature supports the sending of multiple records (for example, multiple employees details can be inserted/updated in a single request). It also supports relations (for example, multiple employees within one department can be inserted/updated in a single request).

The Oracle Database Adapter enables Oracle Autonomous Integration Cloud to send 10 MB of data to an Oracle database in a single request.

The Oracle Database Adapter now enables you to declaratively construct your complex DML statements such as insert and update in a few clicks using a graphical editor. The editor supports only insert and update operations. The Adapter Endpoint Configuration Wizard guides you to select schemas, tables, and relationships to construct the data structure that you want to send to the database. The wizard also helps you to filter the attributes from the selected data structure to fine tune the data you may want to send to the database instead of sending all attributes.

Another salient aspect of this feature is that the adapter can accept a collection of records to send to the database as a single unit of work.

The following use cases can be implemented using this new capability:

  • Bulk data insert – You can perform mass inserts. For example, up to 10 MB in the target application’s database in a single transaction in conjunction with orchestration and mapper capabilities. You can model integrations such as the synchronization of customer data from a CSV file to an Oracle database to use this capability.

  • Bulk data update - You can perform mass updates For example, updates of employee benefits from Oracle HCM Cloud to an on-premises database up to 10 MB in the target application’s database system in a single transaction in conjunction with orchestration and mapper capabilities.

See Oracle Database Adapter Capabilities of Using the Oracle Database Adapter with Oracle Autonomous Integration Cloud.

Oracle Advanced Queuing (AQ) Adapter and Oracle WebLogic JMS Adapter - Support for size enforcement and rejection handling

Support is provided for processing payloads up to 10 MB in size.

See Oracle Advanced Queuing (AQ) Adapter Capabilities of Using the Oracle Advanced Queuing (AQ) Adapter with Oracle Autonomous Integration Cloud.

See Oracle WebLogic JMS Adapter Capabilities of Using the Oracle WebLogic JMS Adapter with Oracle Autonomous Integration Cloud.

Oracle Service Cloud Adapter - Upload and download attachment support

You can download a file as an attachment from Oracle RightNow Cloud to Oracle Autonomous Integration Cloud. After the file is downloaded, the Oracle Service Cloud Adapter exposes the file reference in the mapper for use by other adapters for further processing.

Similarly, the Oracle Service Cloud Adapter provides support for uploading a file as an attachment to Oracle RightNow Cloud. An integration flow can be modeled to upload a file as an attachment to an object in Oracle RightNow Cloud.

See Oracle RightNow Cloud Capabilities of Using the Oracle RightNow Cloud Adapter with Oracle Autonomous Integration Cloud.

Oracle Service Cloud Adapter - Syntactic validation of ROQL-based tabular queries (QueryCSV)

Syntactic validation of ROQL-based tabular queries (QueryCSV) is done automatically to catch any syntactic errors.

SOAP Adapter - Attachment support

The SOAP Adapter now supports sending attachments as part of the payload to an external SOAP API and receiving attachments as part of the responses received from the SOAP APIs.

The SOAP Adapter automatically discovers and supports attachments found in external SOAP APIs based on the Message Transmission Optimization Mechanism (MTOM) standard defined by the World Wide Web Consortium (W3C). Use cases such as the following can be implemented using the new capabilities. You can use the Send Attachments in Request feature in the SOAP Adapter to stream an employee’s data file from Oracle Autonomous Integration Cloud to UCM in Oracle HCM Cloud prior to submitting a request to Oracle HCM Cloud by invoking the Oracle HCM data loader service. Similarly, you can use the Accept Attachments in Response option in the SOAP Adapter to let the SOAP Adapter stream the Business Intelligence Publisher report available in UCM to Oracle Autonomous Integration Cloud, which can be accessed and processed by downstream actions within that integration flow.

See SOAP Adapter Capabilities of Using the SOAP Adapter with Oracle Autonomous Integration Cloud.

SOAP Adapter - Support for uploading a ZIP file with multiple WSDLs and schemas

The SOAP Adapter provides support for uploading complex SOAP interfaces. The WSDL archive can consist of WSDLs along with any number of artifacts such as WSDLs and schemas referenced within. The archive can be uploaded through the SOAP connection. You can use this connection for invoking an external SOAP operation defined in the WSDL archive. Similarly, you can use this connection as a trigger for implementing an integration supporting one of the operations defined in the WSDL archive. For example, you can use this feature to implement integrations that expose SOAP endpoints using OAGIS-based object definitions.

See SOAP Adapter Capabilities of Using the SOAP Adapter with Oracle Autonomous Integration Cloud.

Oracle HCM Cloud Adapter - HCM Atom feed support

The Oracle HCM Cloud Adapter supports subscribing to the HCM Atom feed. Atom feeds enable you to track changes made to feed-enabled resources in Oracle Global Human Resources Cloud.

See Oracle HCM Cloud Adapter Capabilities of Using the Oracle HCM Cloud Adapter with Oracle Autonomous Integration Cloud.

Oracle HCM Cloud Adapter - HCM data extracts support

The HCM data extracts feature in Oracle HCM Cloud is a flexible tool for generating data files and reports in Oracle HCM Cloud. The Oracle HCM Cloud Adapter can be configured to automatically download HCM extracts from Oracle HCM Cloud to Oracle Autonomous Integration Cloud and have them be accessible for downstream processing. For example, you can schedule to run the benefits data extract in Oracle HCM Cloud and have a scheduled orchestrated integration built to automatically download the extracts to Oracle Autonomous Integration Cloud and send all or partial information to downstream applications.

See Oracle HCM Cloud Adapter Capabilities of Using the Oracle HCM Cloud Adapter with Oracle Autonomous Integration Cloud.

New adapter - Oracle Enterprise Performance Management Cloud Adapter

The Oracle Enterprise Performance Management Cloud Adapter enables you to connect to Oracle Enterprise Performance Management Cloud. This enables organizations to:
  • Simplify the close process in Oracle Financial Consolidation and Close Cloud and Oracle Tax Reporting Cloud

  • Streamline the close process through automation

  • Leverage first-in-class consolidation and tax reporting functionality

See Oracle Enterprise Performance Management Cloud Adapter Capabilities of Using the Oracle Enterprise Performance Management Cloud Adapter with Oracle Autonomous Integration Cloud.

New adapter - Oracle Database Cloud Service Adapter

The Oracle Database Cloud Service Adapter facilitates the integration with Oracle Database Cloud Service using the connectivity agent.

Oracle Utilities Adapter - WSDL upload support

You can manually upload a WSDL (with all elements exposed as formattedElements so you can map them properly) for a particular service instead of parsing the WSDL from the service catalog.

Workday Adapter

Workday is a SAAS-based human capital management system that also supports financial management systems for organizations. Workday can be the one system for all your organizational activities such as recruiting, payroll, finance, inventory, and so on.

See Using the Workday Adapter.

SuccessFactors Adapter - inbound events support

Trigger (inbound) support is provided for receiving event notifications from SuccessFactors.

See SuccessFactors Adapter Capabilities of Using the SuccessFactors Adapter with Oracle Autonomous Integration Cloud.

Concur Adapter - API option support

You can select the API option in the invoke (outbound) direction of an integration.

See Configuring Concur Adapter Invoke API Option Properties of Using the Concur Adapter with Oracle Autonomous Integration Cloud.

Note:

This is the initial release of Oracle Autonomous Integration Cloud. There have been new Integrations features added in previous releases of the user-managed version of Oracle Integration Cloud. See What's New for Oracle Integration Cloud.
New Processes Features
Feature Description

Activation

We've enhanced the process application activation wizard:

  • In addition to SOAP integrations, you can now configure REST integrations during activation. Note that you must configure OIC integrations in the Integrations feature.

  • If a process application doesn't use any REST or SOAP integrations, the Customization step is skipped and you proceed directly to validation.

  • If you opt to use credentials configured during design time, they are automatically populated for you during runtime activation. Otherwise, you can create separate credentials for runtime.

See Activating Applications in Using Processes in Oracle Autonomous Integration Cloud.

Email notifications

Help end users more easily respond to tasks by customizing their email notifications. In addition to templates and actions, you can now specify:

  • When emails are sent (upon assignment, completion, or error). You can even specify a different template and subject for each status.

  • How forms associated with tasks are included as attachments (as images, PDF files, inline, or not included).

  • Whether documents or other files previously attached to tasks are included as email attachments.

See Configuring Email Notifications in Using Processes in Oracle Autonomous Integration Cloud.

Forms

Web form enhancements include:
  • Execute actions on columns: We’ve added new actions that let you hide or show table columns when an event occurs. In addition, we've added a new property in the Properties pane that lets you hide table columns.

  • Execute an action on all rows: We’ve added new event actions that let you:

    • Retrieve a control's value and apply it to each row of a table or repeatable section (For Each).

      See Configuring Tables in Using Processes in Oracle Autonomous Integration Cloud.

    • Copy values from one column to another for each row of a table or copy values from one control to another for each row of a repeatable section (Current Iteration Row).

      See Configuring Tables in Using Processes in Oracle Autonomous Integration Cloud.

  • Change presentations dynamically: A new action lets you dynamically switch a form’s presentation, with the option of retaining the modified payload. For example, in a travel request application, change the presentation and available controls based on whether the user selects a one-way or roundtrip flight radio button. See Changing Form Presentations Dynamically in Using Processes in Oracle Autonomous Integration Cloud.

  • Resize uploaded images: You can now control an image’s height and width on the Styling tab.

Data association process activity

A new activity, called Data Mapper, has been added to the structured process editor under System elements. Its sole purpose is to map data.

Use it to assign values to data objects when other activities that use data association (such as human or service tasks) are not needed at that point in the process. Or include a Data Mapper activity to initialize variables for the entire process. This activity can have output only.

See Working with Data Mapper Elements in Using Processes in Oracle Autonomous Integration Cloud.

Auto mapping

Auto mapping is available in both structured and dynamic process editors. Click the Auto Mapping icon in the Data Association window and Process makes its best guess on data values to map, based on names and data types. You may need to make adjustments, but auto mapping works well for straightforward use cases.

Custom properties for structured process activities

You can now assign values to process activities for use in runtime.

Begin by defining properties and assigning them fixed values in design time, then use a process metadata REST API endpoint in runtime to access the assigned values.

See Assigning Custom Properties to Structured Process Activities in Using Processes in Oracle Autonomous Integration Cloud.

Test activate dynamic processes

You can now test your dynamic processes, without needing to activating them each time to see changes.

See Test Activate Your Application in Using Processes in Oracle Autonomous Integration Cloud.

Dynamic process patterns

We've added new process patterns to get you quickly up and started creating dynamic processes. You'll see the available patterns when you add a dynamic process to a process application.

See Creating a Dynamic Process in Using Processes in Oracle Autonomous Integration Cloud.

Customize JSON before importing business objects

You can now edit generated JSON before you import business objects from JSON. This allows you to make any adjustments needed to the best guesses made during generation but before import.

See Importing a Business Object from JSON in Using Processes in Oracle Autonomous Integration Cloud.

REST APIs

New API options were added for dynamic processes. For example, create a new dynamic process instance after first fetching deployed dynamic process definitions. You can create a new dynamic process instance using either the id or key from the response.

See the What’s New topic under Get Started in Oracle Autonomous Integration Cloud REST API.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle Cloud What’s New for Oracle Autonomous Integration Cloud

E84902-08

Copyright © 2017, 2018, Oracle and/or its affiliates. All rights reserved.

Primary Author: Oracle Corporation

This document highlights the latest updates to Oracle Integration Cloud.

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.