It’s time for the Oracle Integration June 2023 update. In this release, we are introducing exciting new connectivity enhancements for the existing adapters.

  1. OData Adapter enhancements
  2. IBM DB2 adapter certified on AS400
  3. Large Payload support up to 100 MB
  4. Inbound Polling without the Connectivity Agent
  5. Improved Endpoint Wizard for the Oracle Hospitality Adapter

OData Adapter Enhancements

The OData Adapter comes with new features, including: 

  1. On-premises OData-based application connectivity
  2. ATOM-XML message format support
  3. Custom queries support for the query operation

The OData Adapter enables users to integrate on-premises applications and expose OData services with Oracle Integration using the connectivity agent.

Connections Page

On the Connections page, a new option is introduced: Access type (public gateway / connectivity agent). As a prerequisite, an agent group configuration is required to access the service that is hosted on-premises behind a firewall.

image1

 

The OData Adapter now supports ATOM-XML request / response media types to process ATOM-XML messages.

On the Operations page, the Request and Response Media Type option is introduced. Users can select the JSON and ATOM-XML media types.

Operations Page

image2

The OData Adapter also supports custom queries for the query operation.

The Configure Query Parameters (Query Expression and Query Builder) option is introduced on the Query Parameters page. Users can select Query Expression to generate the query by clicking the Generate Query option, or users can select Query Builder to create a custom query.

Query Parameters Page (when Query Expression is selected)

image3

Query Parameters Page (when Query Builder is selected)

image4

IBM DB2 Adapter on AS400 is Certified!

IBM DB2 Adapter is now certified with the i7R4 (V7R4) version.

Large Payload Support

The supported message payload size has been increased to 100 MB for structured messages. Please refer to the documentation for detailed information.

Inbound Polling without the Connectivity Agent

Oracle Integration currently supports inbound polling only with a connectivity agent. As part of this release, you can poll ATP, ADW, and DBaaS applications without the connectivity agent.

Adapter capabilities remain the same as before without any change. There is no difference in the integration modeling perspective, apart from the Connectivity Agent selection on the Connections page.

In upcoming releases, both the Oracle Cloud Infrastructure Streaming Service and the Apache Kafka Adapters will be introduced with this capability.

Improved Oracle Hospitality Adapter Endpoint Wizard

The Oracle Hospitality Adapter endpoint brings a new level of usability, where the available operations and their business objects are mapped dynamically according to what’s available in OPERA Cloud for that user/application. Users are no longer required to provide JSON sample messages for request/response and endpoint URLs.