Welcome to Oracle Integration’s 25.02 release! This update introduces powerful new adapters and significant enhancements across our existing portfolio, ensuring seamless integration, advanced connectivity, and enhanced productivity for diverse use cases.

New Adapters:

• RabbitMQ Adapter: Expands Oracle Integration’s messaging capabilities with robust support for publishing, consuming, and managing messages through RabbitMQ exchanges and queues.
• Asana Adapter: Elevates project management and collaboration by enabling direct integration with the Asana platform, offering CRUD operations, OAuth 2.0 authentication, and support for Personal Access Tokens (PAT).

Partner Developed-Adapters Using the Rapid Adapter Builder 

Oracle Integration (OIC) is expanding with a growing number of partner-developed adapters built using the Rapid Adapter Builder (RAB), enabling seamless integrations with enterprise applications. As part of this release, we offer three adapters delivered by partners:

• Infobip Omnichannel Messaging Adapter: Simplifies multi-channel messaging.
• Open Exchange Rates Adapter: Provides real-time and historical forex data integration.
• Loftware Adapter: Integrates with industry-leading labeling solutions for efficient, high-quality label printing.

Oracle invites partners to build adapters with RAB, enhancing application visibility and expanding market reach. Partner with us today! 

Enhanced Adapters:

• Dynamic Connections for FTP Adapter: Enables runtime flexibility by dynamically updating connection details for outbound invokes.
• Stage File Action Enhancements: Adds PGP-based file signing and verification for secure encryption and decryption.
• Apache Kafka Adapter Enhancements: Supports multiple offsets, ranges, and partition resets for flexible message processing.
• Microsoft Dynamics 365 Adapter: Now supports inbound trigger capabilities, enabling real-time event-driven workflows for various entity operations.
• ArcGIS Adapter: Introduces inbound trigger support for ArcGIS Online and ArcGIS Enterprise, leveraging OAuth, HMAC, and API key security policies.
• Shopify GraphQL Adapter: Expands trigger role functionality to include enhanced support for customer companies and fulfillment workflows.
• Salesforce REST Adapter: Adds a bulk query operation, simplifying data retrieval and processing for large data sets.
• GCP Pub/Sub and GCP Storage Adapters: Provides connectivity agent support to enhance secure, private network connections for invoke operations using JWT User Assertion security policies.
• Amazon SNS Adapter: Supports the AVRO schema for publishing and subscribing across trigger and invoke connections, alongside JSON and XML.
• Amazon SQS Adapter: Supports the AVRO schema for sending and receiving in invoke connections, alongside JSON and XML.
• Certified a number of adapters with new API versions.

****Important Updates****

• We have extended the deadline from 25.02 to 25.04 to complete changes to the SOAP Adapter for ERP endpoints. Refer here for more information.

RabbitMQ – New Adapter 

As part of our multi-cloud strategy, we’re introducing the RabbitMQ Adapter to our messaging adapter category in Oracle Integration.  

The RabbitMQ Adapter enables you to create an integration in Oracle Integration that connects to the RabbitMQ messaging service. The RabbitMQ Adapter connects to the RabbitMQ distributed publish-consume messaging system from Oracle Integration and provides for the publishing and consumption of messages from RabbitMQ exchanges/queues. The RabbitMQ Adapter can be configured as a trigger and an invoke connection. 

The RabbitMQ Adapter provides the following benefits for this release: 

• Supports configuration of Queues and Exchanges, where queues store messages, and exchanges route messages to queues based on defined routing rules. Available exchange types include Direct, Fanout, and Topic. 

• Supports XML/JSON, Binary, and String message structures for publishing and consuming the messages. 

• Supports adding Custom Headers. You can add custom header values on the Headers page. 

• Publishes messages and pulls messages. 

• Supports persistent messages for durability and non-persistent messages for temporary storage. 

• Supports Dead Lettering for inbound operations. 

• Supports Basic authentication for both invoke and trigger connections. 

• For Invoke connections, Binding and routing keys enable precise message delivery to desired exchanges and queues. 

• For Trigger connections, allows for setting the polling frequency up to a maximum of 600 seconds and fetching up to 1000 records. 

• Allows connections using publicly-accessible resources (over the public internet) as well as connectivity agent and private resources within your Virtual Cloud Network (VCN) through a private endpoint. 

The ability to provide support for OAuth2.0 Client credentials is on the future roadmap.                   

Connection Page: 

To connect with the RabbitMQ Adapter, specify the hostname, virtual hostname (vHost), and user name and password. 

Invoke Operation Page: 

Trigger Configure Polling Operation to perform on the RabbitMQ page 

Message Structure page 

Headers page 

Asana – New Adapter

The Asana Adapter provides seamless integration with the Asana cloud platform, empowering organizations to optimize their project management and collaboration workflows. This adapter supports various invoke operations, providing the following key capabilities:

• CRUD Operations: Perform Create, Update, Query, and Delete actions on core Asana objects such as:

  • Attachments
  • Tasks
  • Projects
  • Teams
  • Goals
  • Portfolios

• Authentication Options:

  • OAuth 2.0 for secure, token-based authentication.
  • Personal Access Tokens (PAT) for simplified integration scenarios.

• Pagination Support: Efficiently manage large data sets with built-in pagination.

Support for inbound webhook event-driven integrations is on the future roadmap.

You can implement the Asana Adapter in use cases such as:

• Synchronizing Asana tasks with Jira issues to ensure development and project management teams remain aligned.
• Converting Zendesk tickets into Asana tasks for efficient tracking and resolution of customer support issues.
• Automatically creating Asana tasks for order fulfillment when new orders are placed in Shopify or Magento.
• Synchronizing tasks, projects, and workspaces between Asana and NetSuite.

To connect with the Asana Adapter, configure authentication in the Security section using either an OAuth Client ID/Secret or a Personal Access Token.

Connection Page (Invoke)

Basic Info Page (Invoke)

Open Exchange Rates – New Adapter (Partner Developed)

The Open Exchange Rates Adapter, built using Oracle Integration and RAB infrastructure, allows seamless connectivity to the Open Exchange Rates API. This adapter makes it easy to access live and historical foreign exchange rates in a simple JSON format, covering everything from real-time rates to currency conversion.

Key Features

• GetLatestRates: Access real-time exchange rates to keep your data updated.
• GetHistoricalRates: Retrieve historical rates dating back to 1999.
• GetCurrencyList: Get a full list of available currencies and their names for dynamic integrations.
• GetRatesByTimePeriod: Request historical exchange rates over specific periods for reporting or analysis.
• GetPlanDataAndUsageStats: Monitor your app plan details and usage statistics.
• GetLatestConversion: Convert currency amounts using the latest exchange rates.

Use Cases

• Synchronize Forex Data with Oracle ERP: Automatically update exchange rates within Oracle ERP, ensuring financial systems stay aligned with the latest market trends.
• Convert Currency: Easily convert currencies (ideal for global businesses or international transactions).

Connection Page (Invoke):

Operations page (Invoke):

Infobip Omnichannel Messaging – New Adapter (Partner Developed)

We are excited to announce the Infobip Omnichannel Messaging Adapter, a powerful solution that simplifies the integration of multiple messaging channels —including SMS, MMS, WhatsApp, RCS, and Viber— within Oracle Integration (OIC). This adapter enables businesses to communicate seamlessly across channels through a unified platform, offering an intuitive interface for effortless messaging management.

Key Features

• Seamless Integration with Infobip: Connect easily to Infobip’s communication platform.
• Comprehensive Messaging Capabilities:
  • Send SMS, MMS, RCS, Viber, and WhatsApp (freeform & template) messages.
  • Receive inbound SMS by polling for new messages.
• Event-Based Triggers:
  • Initiate workflows based on inbound WhatsApp/SMS messages.
  • Act on message delivery reports.
  • Capture inbound conversation IDs for chatbot or contact center integrations.

Use Cases

• Automated Customer Notifications: Send real-time alerts based on predefined triggers.
• Message-Driven Actions: Update customer records dynamically based on incoming messages and delivery statuses.
• Conversational Interfaces: Enable two-way interactions across multiple digital channels for customer engagement.

With the Infobip Omnichannel Messaging Adapter, businesses can enhance their communication strategies and improve customer engagement through a streamlined, multi-channel approach.

 

Introducing Dynamic Connections for FTP Adapter in Oracle Integration

We’re excited to announce a powerful new feature in the FTP Adapter that supports dynamic connections for outbound invokes. This enhancement allows users to specify connection details dynamically at runtime, delivering increased flexibility and efficiency in integration management.

Key Benefits:

• Runtime Connection Flexibility: Dynamically update the connection for invoke actions by using properties in the incoming message payload or results from a lookup table function.
• Simplified Integration Management: Reuse a single integration to manage requests across multiple FTP endpoints, removing the need for separate integrations or multiple invoke endpoints.

How It Works:

Pass the connection details at runtime by specifying the connection ID in the FTP Adapter wizard at design time, as shown below.

You can review a detailed demo here.

Enhanced Security in Stage File Action: File Signing and Verification

The stage file action now supports PGP-based file signing and content verification, bolstering security in file operations to make it on par with the FTP Adapter. These enhancements make it easier to securely interact with files during integration workflows.

File Signing and Enhanced Operations

• Sign content using private PGP keys during encryption and verify signed files using public PGP keys during decryption.
• Enhanced support for file operations:
  • Read File / Decrypt File: Supports reading and verifying content during decryption.
  • Write File / Encrypt File: Enables encryption and file signing, with options for signing content during encryption.

Apache Kafka Adapter Flexibility and Control Enhancements

The Apache Kafka Adapter is now enhanced with greater control and flexibility for message processing. The Apache Kafka Adapter now supports two powerful capabilities:

1. Multiple Offsets and Ranges
   Gain precise control over message processing by defining multiple offsets and ranges. For instance:

   • Process the 1st message, 4th message, and all messages from 9 to 15 by specifying offsets such as 1-1, 4-4, 9-15.
   • This feature is perfect for scenarios requiring selective message retrieval, streamlining operations, and avoiding unnecessary data processing.

2. Reset to Specific Offset or Start from Beginning
   Reset the consumer to a specific offset (partition-specific) or rewind to the beginning of the partition.

   • This capability is invaluable for replaying events, debugging issues, and performing targeted testing or recovery with ease.

These new features empower you to optimize your integration workflows and improve efficiency in managing Kafka messages.

Consume records from a Kafka topic by specifying multiple offsets and ranges

Mapping for above operation where you can map multiple offset ranges for multiple partitions

Reset to a specific offset (partition-specific) or from the beginning

Kafka Inbound – Polling – Consumer Operation Wizard will have the following options: (Not applicable for Streaming API in Inbound)

With Read from specific offset selected, the location where you can provide partition and offset details

Shopify GraphQL Adapter Enhancement – Expanded Trigger Role Support 

The Shopify GraphQL Adapter provides significant enhancements to the trigger role for the 25.02 release. A new module, Order Returns, has been added, along with new business events (Company Create, Company Update, and Company Delete) within the Customers module.

With these updates, users can now add and modify company details, as well as return fulfilled orders using the Order Returns module. The available business events in this module are: Return Approve, Return Cancel, Return Close, Return Decline, Return Reopen, Return Request, and Return Update.

To access the business events for the Company and Order Return modules, simply select the module and the desired event on the trigger Events page. Refer to the image below for further details.

Microsoft Dynamics 365 Adapter Enhancement – Inbound Trigger and Pagination Support

Oracle Integration now supports inbound triggers for the Microsoft Dynamics 365 Adapter, enabling real-time, event-driven workflows.

Key capabilities include:

• Support triggers for Business, System, and Custom Entities, enabling create, update, delete, and merge operations.
• Outbound pagination for efficient handling of large data sets.
• Continued support for secure authentication via OAuth 2.0 client credentials or authorization code credentials, applicable for both invoke and trigger connections.

Connection Page (Trigger and Invoke)

ArcGIS Adapter Enhancement – Inbound Trigger Support

The ArcGIS Adapter now supports the Inbound connections for both the ArcGIS Online and ArcGIS Enterprise products.

The trigger functionality in ArcGIS Online supports OAuth Authorization Code & HMAC as a security policy, while ArcGIS Enterprise uses API Key Validation as its security policy.

ArcGIS Online supports multipoint, polyline, and polygon geometries along with point type for geographic information, while ArcGIS Enterprise supports point, polyline, and polygon geometries.

Trigger Connection page for ArcGIS Online

 

Trigger Connection page for ArcGIS Enterprise

Trigger Configuration page for ArcGIS Online

Salesforce REST Adapter Enhancement – Support for the Bulk Query Operation 

With this release, the Salesforce REST Adapter facilitates users to query bulk data. This is a significant addition to the existing bulk data operations (Create, Update ,Upsert, and Delete) provided by the adapter. Therefore, users can now use Bulk CRUD to modify a large data set and Bulk Query to retrieve a large data set.

The queries written are SOQL (Salesforce Open Query Language) statements. Each query statement is associated with a job Id. Therefore, when the user selects Bulk Query on the invoke Operations page in OIC, they can perform one of the following operations:

• Create a Job – Write a SOQL query statement, select a column delimiter, and test the query for any compile time errors. Users can also choose to include previously-deleted records as a part of query results.
• Get result for a job – View results of a query in OIC.
• Get info for a job – Get information of a single query in OIC.
• Abort a Job – Stop execution of a query if it hasn’t been processed completely.
• Delete a Job – Delete the existing query.

GCP Pub/Sub and GCP Storage Adapters Enhancement – Support for the Connectivity Agent

We’re excited to announce that connectivity agent support is now available for the GCP Pub/Sub and GCP Storage Adapters! This enhancement strengthens security and facilitates seamless private network connections for invoke operations.

Key Benefits:

• Enhanced Security: Supports the JWT User Assertion security policy, ensuring secure data exchange over private networks.
• Private Network Connections: Enables secure, private network connections for invoke operations, including publishing, consuming, and acknowledging messages.

Important Note:

Connectivity Agent support is exclusive to the JWT User Assertion security policy and does not apply to the Authorization Code Credentials security policy.

This update empowers you to leverage the GCP Pub/Sub and GCP Storage Adapters with confidence, knowing your connections are secure and reliable.

Note: The connectivity agent is not supported for the trigger connections.

Amazon SNS and SQS Adapters Now Support the AVRO Schema 

As a part of this release, the Amazon SNS Adapter in Oracle Integration is enhanced across trigger and invoke connections, with the feature of publishing and subscription of messages in AVRO schema format, in addition to JSON and XML formats.

Adapter Certification Updates 

With this release, many adapters have been certified with new application/API versions.

Refer to the table below to see the latest API versions supported by various adapters.

Adapter	Application Versions
Shopify GraphQL	2024-07 and 2024-10
Shopify[REST]	2024-07 and 2024-10
SAP Concur	Swagger API 3.0,3.1 and 4.0 Extract API 1.0 Payment Batch API  1.1
SAP	No change in the application versions. However, it is now certified with JCO version 3.1.10.
MySQL	8.3
Microsoft SQL Server	Microsoft SQL Server 2019,2022*
Oracle Advanced Queuing (AQ)	Oracle Database On-Premise: 19c and later Oracle Autonomous Data Warehouse (ADW): 19c and later. Oracle Autonomous Transaction Processing (ATP): 19c  and later. Oracle Database Cloud Service: 19c and later.
Rabbit MQ	RabbitMQ 3.13.7
Kafka	3.6.0