It’s time for the December 2023 update of Oracle Integration! With the holidays around the corner, we’re thrilled to showcase the latest features and improvements in the Connectivity realm. This blog spotlights the new RosettaNet (RNIF) Adapter, which is now part of the expanding list of B2B connectivity adapters in Oracle Integration. Additionally, we are introducing exciting enhancements to the existing adapters.

coverpage

New Adapter: RosettaNet Adapter

The RosettaNet Adapter is a recent addition to the B2B lineup of adapters in Oracle Integration, providing customers with the capability to engage in business transactions with their trading partners through the RosettaNet protocol.

The RosettaNet Adapter provides the following capabilities:

  • Support for RNIF 2.0 protocol features: PIPs, RosettaNet business message handling, MIME headers, encryption, and signature over HTTPS.
  • Ability for you to define a RosettaNet schema and attach documents to trading partner setups for processing through our B2B component.
  • Streamlined tracking of message exchanges through B2B tracking, with the collaboration filter facilitating efficient narrowing down of related exchanges.

RNIFconn

RNIFconn1

Azure Active Directory Adapter Enhancements – Support for Inbound Triggers, Regeneration, and Pagination

The Azure Active Directory Adapter introduces the following new capabilities:

  • Supports inbound trigger operations for User and Group events, allowing seamless processing of notifications from Azure Active Directory to Oracle Integration.
  • Enhances outbound invocations with pagination support, facilitating efficient handling of large data sets.
  • Enables both inbound and outbound connections to utilize the Refresh Integration Metadata option, providing for better control and synchronization.

The Adapter Endpoint Configuration Wizard allows users to select User or Group resources and specify actions (Create, Update, Delete, and Permanent Delete).

Azure AD

Azure Event Grid Adapter Enhancements

The Azure Event Grid Adapter introduces the following new capabilities:

  • Bearer Token (JWT) Authentication enhances security for more secure inbound trigger connections.
  • Extended operations support includes Domain and Domain Topics operations with both custom and cloud schema.

Connections page

grid1

Users can now publish and subscribe to Azure Event Grid using both Domains and Domain Topics. These operations can be performed using cloud schema and custom schema supported formats.

The following new operations are introduced on the Basic Info page of the Adapter Endpoint Configuration Wizard for inbound trigger connections:

  • Subscribe to a Custom Domain/Domain Topic 
  • Subscribe to a Cloud Domain/Domain Topic

Basic Info Page (Trigger)

grid2

The following new actions are introduced on the Basic Info page of the Adapter Endpoint Configuration Wizard for outbound invoke connections:

  • Publish Custom Events To Domain
  • Publish Cloud Events To Domain

Basic Info Page (Invoke)

grid3

Azure Storage Adapter Enhancements –  Connectivity Agent and Regeneration Support

The Azure Storage Adapter introduces the following new capabilities:

  • Facilitates outbound invoke connections using the connectivity agent.
  • Introduces the Refresh Integration Metadata (regeneration) option in Oracle Integration.

GraphQL Adapter Fragments Support

The GraphQL Adapter now supports defining and executing fragments. Both inline and named fragments are supported.

Inline Fragment example:

query ($customerID:ID!){
 node(id: $customerID) {
   ... on Customer {
     id
     firstName
     lastName
     email
   }
 }
}

Named Fragment example:

query ($customerId1:ID!, $customerId2:ID!, $first:Int!){
   OperationOne: customer(id:$customerId1){
       ...CustomerFragment
   }
   OperationTwo: customer(id:$customerId2){
       ...CustomerFragment
   }
}
fragment CustomerFragment on Customer {
   id
   firstName
   lastName
   email 
   addresses{
       city
   }
}

 

OData Adapter Batch Operations and Pagination Support

The OData Adapter (invoke direction) introduces the following new capabilities:

  • Batch operations – Support OData V4.
  • Pagination – Support OData V2 and V4 

The batch operation feature enables users to execute more than one operation as a batch.

  • Retrieve Operation: Get, Query
  • Modification Operation: Create, Update, Replace, Delete

For more information, see the OData Adapter documentation.

It’s important to note that the batch operation feature only supports Cloud OData services.

Operations Page (Invoke)

odata

Salesforce Marketing Cloud Adapter Inbound Trigger Support

The Salesforce Marketing Cloud Adapter introduces the following capabilities:

  • Inbound events.
  • OAuth2.0-based Client Credentials security policy, referred to as the Server-to-Server integration Security Policy in accordance with the SFMC application convention.

Connection Page

SFMC1

Basic Info Page (Trigger)

SFMC2

Certified PostgreSQL Adapter for the Managed PostgreSQL Database Service on Google Cloud Platform and Azure

The PostgreSQL Adapter is now certified on the following platforms:

GCP Cloud SQL for PostgreSQL: PostgreSQL 15.4

Azure Database for PostgreSQL: PostgreSQL version 11