#797 OIC August 2020 Release New Features

August is here, or as we say in Ireland Lunasa - the time of the Celtic harvest festivities.
With it a new release of Oracle Integration (OIC) - containing lots of compelling new features.

These are all fully documented in the What's New doc here

There is also an excellent set of blog posts on the Oracle Integration Blog - starting point is here

Now to my highlights -

New Home Page

First thing to note is the new Home Page - here the focus is on reuse as opposed to immediately diving in and creating your own integrations etc.

Also note the addition of Business Accelerators -

Note Business Accelerators are ready to run business integrations - e.g. opportunity to order between Salesforce and Netsuite.

Recipes are more akin to starter templates - there are many of these already available -

New Adapters

PayPal Adapter

The PayPal we all know and love - check out my PayPal adapter blog post here

AS2 Adapter

AS2 = Applicability Statement 2

According to Wikipedia - It is a specification about how to transport structured business-to-business data securely and reliably over the Internet. Security is achieved by using digital certificates and encryption.

Widely used in the retail space - Walmart, Target, the little shop on the corner etc.

I do not have access to a Trading Partner Endpoint as yet - so a dedicated AS2 adapter blog post is on my to-do list.

Intelligent Advisor Adapter

TPFKA Oracle Policy Automation. Essentially a renaming of the existing OPA adapter.

Again, I do not have access to such at the moment, so I will cover this in a later post.

OCI Streaming Adapter

The Oracle Cloud Infrastructure Streaming service provides a fully managed, scalable, and durable storage solution for ingesting continuous, high-volume streams of data that you can consume and process in real time. Streaming can be used for messaging, ingesting high-volume data such as application logs, operational telemetry, web click-stream data, or other use cases in which data is produced and processed continually and sequentially in a publish-subscribe messaging model.

Read all about the OCI Streaming Service here

Streaming could be used for Pub/Sub, in an OIC ecosystem. It can also be used for app event processing, e.g. your ERP business event - Purchase Order Created.

Check out my OCI Streaming adapter blog post here

Shopify Adapter Improvements

Check out my post on these improvements here

Integration Design Time New Features

Actions

Data Stitch is now GA -

See my previous blog post here for a full description of Data Stitch and what it can do for you.

Mapper

Note the new Developer icon

I see the following, if I do a simple field to field mapping -

The Expression is View Only - I need to click the Developer icon to edit this -

OIC Design Time Variables 

Integration properties provides a degree of integration configurability outside of the flow itself. For example, an email address used by a Notification activity within the flow can be externalized as integration property 'sendTo' allowing it to be configured without having to edit the integration itself or having to pass the value at runtime.

Interested? Then check out my blog post here

New Import/Configuration UI

Import/Export of Design Time Metadata

Check out my blog post on Import/Export here

Kudos to the Oracle Integration engineering team for such a compelling release.
Well done folks!

#795 - OIC Shopify Adapter improvements - August Release New Feature

1. The OIC Shopify adapter is now certified with the 2020-04 version of the Shopify api.

2. The OIC Shopify adapter now supports the Inventory Level Update event -

I specify some Tracking fields - activate and test -

Starting point is one product in Shopify

The relevant Shopify permissions have been granted -

I now change the inventory level in Shopify -

An integration flow has been triggered -

3. The Store name is now included in the Business Event payload

4. "Presentment" price support - ability to fetch prices in different currencies - e.g.

Hare of the Dog Vol 1 costs $20 in the US shop and €20 in the EMEA shop.

This requires custom header support in the Shopify adapter.

#794 OIC - Design Time variables - August Release New Feature

Integration Properties are user defined properties available for usage by activities(e.g Notification ,Log) as read-only data within the flow. 

Integration properties provides a degree of integration configurability outside of the flow itself. For example, an email address used by a Notification activity within the flow can be externalized as integration property 'sendTo' allowing it to be configured without having to edit the integration itself or having to pass the value at runtime.

Ok, makes sense - so how to leverage this in OIC -

I can update this property as follows -

an-mhaith, as we would say in Eire.

#793 OIC - Import/Export - August Release New Feature

from the What's New doc -

You can export and import archives of integration and process design-time metadata between instances. This feature can be useful if you want to move metadata from a test to a production environment, perform manual archival backups, or automate your environment to archive backups daily to a repository such as Git.


This is discussed in detail in the following guide

The export is stored in object storage, so you need to configure this under Storage -

Now to try this out -

Download a detailed report -

Import functions as one expects -

More details in this great blog post from my colleague Steve.

#791 OIC - PayPal Adapter - August Release New Feature

Another new feature of the OIC August release is the PayPal Adapter

Yes, the PayPal we all know and love -

Note - this first release supports Invoke only.

Pre-requisite as usual is the PayPal developer account setup -

Here I can find the ClientID/Secret which are needed for defining the PayPal connection in OIC.

Using the Connection in an integration -

Query Options

PayPal adapter doc is here