Welcome to Oracle Integration’s 24.06 release, featuring significant enhancements to the RAB infrastructure. We are introducing the OpenAPI-based ADD conversion alongside improvements for multicloud integrations. Key updates also include the new Coupa Procurement Adapter for streamlined procurement workflows and the Aconex Adapter for improved project management and collaboration. Other enhancements include updates to the Coupa Sourcing Adapter, AQ Adapter, GraphQL Adapter, GCP Storage Adapter, and GCP Pub/Sub Adapter, ensuring seamless integrations across diverse cloud environments. Enhanced security measures provide greater data protection, and certifications for the latest APIs versions, including the SAP S/4HANA Adapter and Shopify Adapter. This underscores our dedication to versatile cloud integrations as we continue to enable private endpoint capabilities for more adapters. 

coverpage

Here’s a glimpse of the enhancements that will be showcased:

  • RAB Enhancements – OpenAPI-based ADD conversion, simplified ADD registration, and Action Management.
  • Coupa Procurement Adapter – New adapter.
  • Aconex Adapter – New adapter.
  • Coupa Sourcing Adapter – Supports attachment download and enhanced security with the Authorization Code Security Policy.
  • AQ Adapter – Supports connections through a Single Client Access Name (SCAN) and the public gateway.
  • Amazon SQS Adapter – Supports the connectivity agent and XML messages.
  • GraphQL Adapter – Introduction of the Basic Authentication Security Policy and support for Custom Request and Response Headers.
  • GCP Storage Adapter – Introduction of JWT User Assertion for OAuth.
  • GCP Pub/Sub Adapter – Enhanced security with JWT User Assertion and support for Pull and Acknowledge messages.
  • IBM MQ Series JMS Adapter – Supports JSON payload and the connectivity agent.
  • Amazon S3 Adapter – Supports the connectivity agent.
  • Azure Active Directory Adapter – Supports new operations for outbound invocations.
  • Private Endpoints – Supports a new set of adapters.
  • Large Payload – Supports database adapters.
  • Shopify Adapter – Certification for new API versions.
  • SAP S/4HANA Cloud Adapter – Certification for SAP S/4HANA Cloud 2402.

RAB Enhancements – OpenAPI-based ADD Conversion, Simplified ADD Registration, and Action Management

As part of this release, we have introduced the OpenAPI converter to ADD. The OpenAPI converter further simplifies development because the developer is not required to worry about schemas. Request and response schemas are referred to directly from the OpenAPI specification. Also, you can add/remove actions very easily by simply selecting or deselecting the actions while updating ADD.

  • Convert OpenAPI to ADD: Swiftly convert OpenAPI documents into ADDs using the Convert OpenAPI Document option, which expedites the development processes.
  • Simplified ADD Registration: Effortlessly register ADDs alongside their corresponding OpenAPI documents with the Register RAB Bundle option, ensuring consistency and accuracy.
  • Effortless Action Management: Enhance agility in API management with the Update Actions with OpenAPI Document option, which facilitates adding or removing actions from ADDs based on OpenAPI documents.
  • RAB APIs are now available to List / Register / Update/ Get/ Delete adapters. Developers can now use REST APIs directly to perform these operations on ADD.

Coupa Procurement Adapter – New Adapter

This release introduces the Coupa Procurement Adapter, specifically designed to optimize procurement workflows. We have divided the Coupa Adapter into two specialized adapters: the Coupa Sourcing Adapter, which provides a broad range of sourcing features, and the new Coupa Procurement Adapter, focusing solely on streamlining procurement processes. Both adapters are available and fully supported, ensuring comprehensive coverage of sourcing and procurement needs. 

In this release, the Coupa Procurement Adapter supports outbound invoke connections with the following capabilities: 

  • Facilitates Invoke Actions for the following modules:
    • Purchase Orders
    • Requisitions
    • Contracts
    • Payment Terms MVPs
    • Advance Ship Notices
    • Exchange Rates
    • Items
    • Address
    • Budget Lines
    • Commodities
    • Comments
    • Attachments
    • Bulk Import
  • Provides support for custom fields.
  • Supports attachments, including the ability to import and export in bulk (up to 250 MB).
  • Implements the Client Credentials Security Policy (2-Legged) for enhanced security.
  • Utilizes the Code Authorization Security Policy (3-Legged) for robust authentication.

To establish a connection with the Coupa Procurement Adapter, you must provide the HostUrl, client ID, and client secret on the Connection page. Furthermore, when configuring the OAuth 2.0 Authorization Client Credentials or OAuth 2.0 Authorization Code Credentials security policy, you must specify a scope.

To obtain the client ID and client secret, refer to the Coupa documentation for OAuth Client creation and scope assignment.

Connection Page (Invoke)

coupa p1

Basic Info Page (Invoke)

coupa p2

Aconex Adapter – New Adapter

The Aconex Adapter enables you to set up a connection with Oracle Aconex. You can use this connection in integrations to connect with Aconex.
The Aconex Adapter is one of many predefined adapters included with Oracle Integration. You can configure this adapter as an invoke connection in an integration.
The Aconex Adapter provides the following capabilities:

  • Easy Selection of Aconex API Modules: The adapter facilitates the seamless selection of various Aconex API Modules, including:
    • Directory
    • Documents
    • Mail
    • Project Fields
    • Projects
    • Tasks
    • User Roles
    • Workflows
  • Simple Operation Selection: You can effortlessly choose specific operations (API service endpoints) within each selected API module. Each operation is accompanied by a basic description for usage clarification.
  • Data Mapping Functionality: The adapter supports intuitive data mapping based on the selected operation, with mandatory fields highlighted as necessary.
  • Automatic Population of Request Parameters: Common request parameters essential for a successful API request are automatically populated, streamlining the integration process.

ax1

ax2

 

 

Coupa Sourcing Adapter Enhancements – Supports Attachment Download and Authorization Code Security Policy

As discussed in the previous section on the Coupa Procurement Adapter, we have divided the original Coupa Adapter into two specialized adapters. The enhanced version of the original adapter is now called the Coupa Sourcing Adapter.

With this release, we have enhanced the adapter with following new features:

  • Supports attachment export, allowing files of up to 250 MB.
  • Introduction of the Authorization Code Security Policy alongside the existing Client Credentials policy, strengthening security for robust access control.

coupa s1

AQ Adapter Enhancements – Supports Connections Through Single Client Access Name IP (SCAN IP) and Public Gateway

Supports Connections Through Single Client Access Name (SCAN IP)

The AQ Adapter now supports connecting to the Oracle Database Classic Cloud Service instance and the Oracle Database On-Premises through the username password token policy using a Single Access Name IP (SCAN IP).

Cloud Support 

The AQ Adapter now supports the public gateway as an endpoint access type.

The AQ Adapter enables you to integrate a cloud application that supports AQ with Oracle Integration. As a prerequisite, it is required to connect to endpoints using the public internet.

Connection Page

On the Connection page, this new option is introduced under the access type: Public gateway.

image

GraphQL Adapter Enhancements – Introduction of the Basic Authentication Security Policy and Support for Custom Request and Response Headers

The Basic Authentication security policy is introduced in the GraphQL Adapter.

The Basic Authentication security policy requires username, password, and header (optional) details to establish the connection. You get the required information in the web service. See the Using the GraphQL Adapter with Oracle Integration 3 for more information.

Connection Page

GQ1

Supports Custom Request and Custom Response Headers

The GraphQL Adapter now allows you to select a check box to add the custom request header and custom response headers on the Operation Page. You can use this feature when:

  • Users can add headers that are unique to specific API operations. For example, if a particular GraphQL query requires an API key or a special content type that is not needed for other operations, it can be added specifically for that request on the Operation Page. This customization ensures that the required headers are included only when necessary, without affecting other API calls and override headers maintained during connection setup.

GQ2

GCP Storage Adapter Enhancement – Added Security with JWT Security Policy (Service Account-based Authentication)

The GCP Storage Adapter introduces JWT User Assertion for OAuth as an enhanced security policy for an added layer of security.

The GCP Storage Adapter has introduced the enhanced JWT security policy to provide the following benefits:

  • The added security with the JWT security policy does not set any limit on the expiration of refresh tokens.
  • In this enhanced security policy, service accounts use RSA key pairs for authentication instead of passwords.  
  • Before testing the connection, you can avoid the additional step of clicking Provide Consent.

For the JWT User Assertion for OAuth security policy, you must complete the Service Account and Project Id fields in the Connection Properties section to get validated. In the Connection Security section, you have the option to select either the preexisting Authorization Code Credentials or the newly added JWT User Assertion For OAuth as the security policy. Accordingly, you must enter the appropriate JWT Private Key Alias and Scope. 

GCPstorage

GCP Pub/Sub Adapter Enhancement –  Supports JWT User Assertion for OAuth Security Policy, Pull (Consume) Messages, and Acknowledge Messages

The GCP Pub/Sub Adapter enhances its security policy for trigger and invoke connections in the following ways:

  • Trigger Connection: JWT User Assertion for OAuth and JWT Validation.
  • Invoke Connection: OAuth Code Credentials as well as JWT User Assertion for OAuth.

Trigger Configuration Page

pubsub1

Invoke Configuration Page

pubsub2

The GCP Pub/Sub Adapter has also introduced two action items on the Invoke Configuration Page, alongside Publish Messages. They are:

  • Pull Messages: For consuming the published messages.   
  • Acknowledge Messages: For acknowledging the pulled (consumed) messages. Once the messages are acknowledged within the acknowledged deadline time frame, messages get deleted from the subscription.  This reduces the chances of duplication.

pubsub3

IBM MQ Series JMS Adapter Enhancements – JSON Payload Support and Certification of IBM MQ Cloud using Connectivity Agent

The IBM MQ Series JMS Adapter is one of the many messaging adapters developed by Oracle. It allows for messages to be consumed or published over queues or topics. It provides privileges to prioritize a message, and decide its persistency over the IBM server and lifetime over the messaging channels (queues and topics). It also provides support for both standard and custom headers.  

With this release, the IBM MQ Series JMS Adapter overcomes its restriction of supporting only an XML payload message structure. It now supports JSON payloads as well.  

Additionally, IBM MQ Cloud, a managed service, is now certified with the IBM MQ Series JMS Adapter for version 9.3.5.0 on the cloud using the connectivity agent.

MQ

Amazon S3 Adapter Enhancements – Improved Security Using the Connectivity Agent 

In this release, we are enhancing the Amazon S3 Adapter with improved security and flexibility. In addition to public gateways, it now allows connections to application endpoints using a connectivity agent.  

When configuring a connection with the Amazon S3 application, you must provide connection properties, security, and access type. If you select Connectivity agent as the access type, you must also specify the associated agent group. Refer to the image below for further details.

Export Product Data Files Using the Get Object and Send Data to Create a Product in SAP ERP can be considered as a significant use case for this adapter.

S3

Azure Active Directory Adapter Enhancement – New Operations Support

The Azure Active Directory Adapter introduces new operations that can be performed on the User business object for outbound invocations. This enhancement benefits users by enabling more efficient and comprehensive management of organizational hierarchies in Azure Active Directory. 

These operations have been introduced on the Basic Info page of the Adapter Endpoint Configuration Wizard. These new operations include:

  • Assign Manager
  • Remove Manager
  • List Direct Reports
  • Get Management Chain by id

Basic Info Page (Invoke)

AD1

If the Get Management Chain by Id operation is selected on the Basic Info page, the Configuration page is displayed. On the Configuration page, you are required to specify a numeric value and select the necessary options to get in response and execute the Get Management Chain by Id operation.

Configuration Page (Invoke)

AD2

Private Endpoint Enablement for a New Set of Adapters

In our continuous efforts to enhance security and privacy measures for our users, we are thrilled to announce that a new set of adapters have been enhanced to support private endpoints:

  • SAP S/4HANA Cloud
  • SAP Ariba
  • Salesforce REST  
  • Oracle Advanced Queuing (AQ)
  • Salesforce

This functionality empowers you to establish secure connections to private resources hosted within a virtual cloud network (VCN).

To connect to private endpoints, you must complete prerequisite tasks in the Oracle Cloud Infrastructure Console. Failure to do so results in errors when testing the connection. See Connect to Private Resources in Provisioning and Administering Oracle Integration 3 and Troubleshoot Private Endpoints in Using Integrations in Oracle Integration 3.

A new option, Private endpoint, has been introduced on the Connection page for the adapters listed above.

Large Payload Support for Database Adapters

The supported sizes for payloads have increased for the database adapters. These adapters now support 100 MB structured payloads for the cloud and 50 MB structured payloads with the connectivity agent. 

The database adapters that support these new payload sizes are:

  • PostgreSQL
  • SAP ASE (Sybase)
  • Netezza
  • IBM DB2
  • Snowflake
  • MySQL
  • Microsoft SQL Server

Shopify Adapter Certified to Support New API Versions 2024-01 and 2024-04 

The Shopify Adapter is certified with Shopify API versions 2024-01 and 2024-04. 

Important Note:
Shopify is urging its users to transition from using REST to using GraphQL for smoother interactions with their platform. As a result, the following REST endpoints and their operations will be deprecated by Shopify:

– Products
– Product Variants
– OrderRisk

Currently, our Shopify Adapter does not support GraphQL APIs, but we are actively working on developing a new adapter based on GraphQL. 
Customers who are using the Shopify Adapter in Oracle Integration Generation 2 should not create any new projects that rely on the deprecated REST APIs. Instead, they should plan to transition to Oracle Integration 3 to benefit from the future GraphQL-based integrations. We will inform you as soon as GraphQL API support is available in the Shopify Adapters for Oracle Integration 3.

For further details, please refer to the Shopify 2024-04 release notes.

Certified SAP S/4HANA Cloud Adapter for SAP S/4HANA Cloud 2402

The SAP S/4HANA Cloud Adapter is now certified with SAP S/4HANA Cloud 2402.