OIC 23.02 Release New Features

Welcome to the 23.02 release. This release brings a plethora of new features, so without further ado, let’s look at them!

Common Features 

OIC Usage Factory API

This API retrieves information about your integration resources and how they are used. It covers lookups (DVMs), application instances, integrations, integration designs, packages, messages, agent, adapters, API libraries, message system, and schedules.

 {
    "adapterMetrics": {
        "adapterCount": {
            "adapterDisplayNameMap": {},
            "marketPlaceAdapterCount": 0,
            "preInstalledAdapterCount": 77,
            "privateAdapterCount": 0,
            "totalAdapterCount": 77
        }
    },
    "agentMetrics": {
        "agentsByGroup": {
            "AA-Agent-Group": 1
        },
       ...
        "numberOfDownAgents": 1,
        "totalAgents": 1
    },
    "apiLibraryUsageMetrics": {
        ...
    },
    "applicationInstanceUsageMetrics": {
        "active": 4,
        "configured": 4,
        "inProgress": 0,
        "total": 4,
        "typeNumbers": {
            "QuickBooks": 1,
            ...
        },
       ...
        "used": 4
    },
    "domainValueMapUsageMetrics": {
        "numberInUse": 0,
        "total": 1
    },
    "integrationDesignMetrics": {
        "styles": [
            {
              ...
            },
            {
                "name": "Orchestration",
                "patterns": [
                    {
                        "active": 1,
                        "configured": 0,
                        "draft": 0,
                        "failed": 0,
                        "name": "Scheduled",
                        "total": 1
                    },
                    {
                        "active": 4,
                        "configured": 2,
                        "draft": 0,
                        "failed": 0,
                        "name": "Map Data",
                        "total": 6
                    }
                ],
                "total": 7
            }
        ]
    },
    "integrationStateMetrics": {
        "activationInProgressCount": 0,
        "activeIntegrationCount": 5,
        "totalCount": 5
    },
    "integrationUsageMetrics": {
        "activated": 5,
        "activeAppInstance": 4,
       ...
        "configured": 2,
        "failedActivation": 0,
        "inProgress": 0,
        "integrationsByAdapters": {
            "QuickBooks": 3,
            "REST": 6,
            "Mailchimp": 1
        },
        "integrationsByAdaptersArray": [
           ...
        "intgStyles": {
            "Orchestration": 7
        },
        "numberOfMEPTypes": 2,
     ...
    },
    "links": [
      ...
    ],
    "messageMetrics": {
        "aborted": 0,
        "debugInstances": 0,
        "failed": 0,
        "success": 0,
        "total": 0
    },
    "messageSystemMetrics": {
        "jmscount": 0,
        "omscount": 0
    },
    "packageUsageMetrics": {
      ...
        "total": 0
    },
    "scheduleUsageMetrics": {
        "active": 0,
        "inUse": 0,
        "stopped": 0,
        "total": 0
    }
}

Integration  

OIC Projects – enhancements

OIC 22.12 brought the first release of Projects. This release add more functionality in respect of deployment. Deployments are at integation level. They can include some or all integrations. For example, deployment1 could include v1 of integrations A and B; deployment2 could include v1 of integration A and v1.1 of integration B. Deployments can be activated, deactivated and exported.

.

Please note: You can create a maximum of 70 integrations, 10 connections, 10 lookups, and 10 JavaScript libraries in a project.

Parallel Processing Enhancements

The Parallel Processing action was released in January 23. It allowed for MAP and INVOKE / CALL INTEGRATION actions in the individual parallel branches. The supported actions have been augmented in 23.02 with the following – NOTIFICATION, LOGGER, SCOPE, JAVASCRIPT. Within SCOPE you can add a SWITCH.

Currently, up to 5 branches are supported.

Certificate UI support for uploading signed key type certificates

A common scenario for such is when you must invoke a service that does not view an OAuth client secret as secure. For these use cases, JWT assertions can be used to authenticate the client application without the use of a client secret. Oracle Integration uses the signing key to generate the JWT assertion.

Ability to View Integration Properties of Active Integrations

With 23.02, you now can view the integration properties, without having to deactivate the integration first.

Improved Observability

The 23.02 release includes Connection specific monitoring.- We see immediately which connections are causing errors. In this case, its 23 connections. The doughnut sections show the top errored connections, based on the number of flows that have failed, due to connection issues. This includes connection availability and errors thrown such as duplicate order etc. 

Hovering over a section shows how many errored flows this connection has caused –

You can also drill down from the doughnut section to the individual errored flows.

B2B

OIC 23.02 now supports B2B. This ensures parity with OIC gen 2 in this respect.

File Server

File Server now supports additional algorithms. These algorithms are available in the Security -> Signature Algorithms field on the File Server Settings page.

New EdDSA and Ed25519 algorithm

ssh-ed25519

New ECDSA algorithms

ecdsa-sha2-nistp256
ecdsa-sha2-nistp384
ecdsa-sha2-nistp512

Prebuilt Connectivity New Adapters & Enhancements

Every release of OIC brings new additions in this space, this one is no exception. 23.02 sees the arrival of a new adapter as well as enhancements to existing ones. 

• New Adapter – Netezza Adapter
• Adapter Enhancement – REST Adapter
• The REST Adapter has been enhanced in the following areas –
  • JWT for OAuth 2.0-based flows support
  • RPST outbound security policy support
• The IBM MQ Series JMS Adapter has been enhanced to enable SSL communication.
• The SAP Concur Adapter now provides Regeneration support. This support is already available with many other OIC adapters, now SAP Concur adapter can avail of this feature.
• The SAP ASE (Sybase) Adapter has been enhanced in the following areas – DB Bulk Import and Paginiation support.
• The SOAP Adapter – now includes OAuth Client Credentials and OAuth Authorization Code Credentials security policy support. 
• The Snowflake Adapter enhanced to support Internal Stage
• The Concur Adapter Supports Regeneration
• Latest API certification for Shopify Adapter

Please see the detailed blog post here for more details on new adapters and enhancements to existing adapters.

New Recipes

Recipes are pre-assembled solutions that bundle all the resources required by the integrations, such as the connections and lookups, into one package. Use a recipe to quickly get started building your first integration. OIC already includes a plethora of recipes, this release sees more added.

• Import Documents from Oracle ERP Cloud to Adobe Sign
• Create Activities in Oracle Field Service for Oracle ERP Cloud Work Orders
• Sync Contracts between SAP Ariba and Oracle ERP Cloud
• Import a File into Oracle Content Management
• Sync P6 Project Details with Primavera Cloud
• Sync Primavera Cloud Project Details with P6
• Sync Customer and Campaign data between Unity and Salesforce Marketing Cloud
• Sync Workday employees with ServiceNow users

Summary

Our 23.02 release comes with a plethora of compelling new features, giving you more functionality to make it easier to organize and develop your integrations. I hope you get the opportunity to try them out soon!