Thursday, August 27, 2020

#798 OIC DB Adapter - some more adventures...

simple requirement here - I have a DB table that has a primary key filled by a sequence, this table, let's call it the CUSTOMERS table, also has a field dateCreated.

Now I need to insert data into this table via OIC.
A simple flow - REST Trigger - DB Insert and that's it.

So here's the table definition -








DDL -

CREATE TABLE customers (cust_id integer generated by default as identity (start with 1) not null primary key, cust_name varchar2(20) not null, createdDate  date not null);

Here is the request payload for the REST trigger -




















So now to the configuration of the DB adapter -

First attempt - use INSERT






























































Note, I cannot de-select the custId column.

Now to the mapping -


















Note: I need to map custId - but, this is filled at DB level.

So another approach -



































Now to the mapping -













Note, no input parameters are shown.

So what was my solution here?

good old PL/SQL -

I create a stored procedure as follows -

 CREATE OR REPLACE Procedure p_createCust
     ( custName_in varchar2, createdDate_in DATE)
  IS
  v_status varchar2(10);

  BEGIN


     INSERT INTO customers
     ( cust_Name,
       createdDate )
     VALUES
     ( custName_in,
       createdDate_in );

     commit;
  EXCEPTION
  WHEN OTHERS THEN
     raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
  END;
 /

I call this from the DB adapter -


























Mapping -




 













Note I am setting the CreatedDate field to fn:current-date()

I activate and test -
















I validate in the DB -


Wednesday, August 19, 2020

#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!

Monday, August 17, 2020

#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.





















Thursday, August 13, 2020

#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.