#750 - Oracle Cloud Security - WAF et al - DDos protection for OIC

Great article from our security guru, Paul Toal

Read it here

Thanks to my colleague Matt B. for the pointer.

#749 OIC Feature Flag - Data Stitch

Data Stitch action in Orchestration

Available to you as feature flag
(oic.ics.console.integration.stitch-action)

Available from version -

All text in italics is from ORCL docs.

This is a new capability within the orchestration designer that enables customers to initialize and progressively update complex variables within integration flows. IT specialists can now use the "Global Variables" section of the designer to define new variables in the integration flow that can hold complex content and use the data stitch action to progressively populate and/or manipulate whole or parts of the document. You can simply drag and drop the "Data Stitch" action from the component palette into the canvas and graphically model the data assignments as an ordered sequence of statements to populate scalar or complex variables wholly or partially.  Designers can add multiple data stitch actions at various points in the integration flow to update existing or append new sections to previously declared and populated variables using data from various sources. 

Couldn't have said it better myself, net, net -
Data Stitch allows us to create and manipulate complex variables within an integration orchestration.

This was something missing in OIC, for those coming from SOA Suite/SOA CS.

Now to a simple example -

Data Stitch Example

I retrieve a customer file from Box, as follows -
Box adapter how to is here

Above screenshot shows the file format.

My integration will be REST based -
Request will be the folder_id required to locate my file on Box.

Response is as follows -

As you can see, the response is simply a subset of the data returned by ReadFile.

Global Variables 

Another new feature in OIC, here I create a Global variable to hold the customer data -

Note the new (x) icon above.

I set the variable to the type of CustomerList (the ReadFile response).

Note: you can include up to 20 Global Variables in an Orchestration.

Again, very similar to what we currently have in SOA Suite -

Data Stitch Action 

Now I map the response from the file read (CustomerList)
to this variable via the Data Stitch action -

Note the other Operations available -

Append essentially provides the same functionality as its pendant in SOA Suite -

Now back to OIC...

I can now leverage this in the mapping of the Integration response -

I deploy and test the integration -

Built-in OIC REST API Tester

Note the new built-in Tester for REST interfaces - this allows one to test on's integration from within OIC; this certainly saves me for having to open Postman, in order to do the same.

Net, net, OIC is going from strength to strength - so get onboard!

#748 - OIC Feature Flags --> New Connector for Box

Feature Flag - Box adapter (oic.cloudadapter.adapters.box)

In order to get the above data - I nee to create a new app in Box -

Login to Box Dev Console here

I create a new app of type - Custom App
and then select the Authentication Method below -

I also enter the redirect URI for OIC -

The format is as follows -

https://yourOIC:443/icsapis/agent/oauth/callback

Now back to the connection for Box in OIC -

I click Provide Consent, I am then prompted to enter my OIC credentials.

I then see the following -

I click Grant access to Box

I return to the Box connection page in OIC and click Test/Save.

Upload a file to Box -

This is a csv file containing customer information -

I put this into a folder - Customers

I now create an integration that will leverage the Box connection.

I begin by getting the root folder - Box api requires a folder_id to be passed in this
request. The folder_id for the root folder is 0.

I now run the integration -

Response payload is as follows -

I run the integration again, this time using the id from the Customers folder.

Response is as follows -

Now let's download the file to OIC -

Note the file_id parameter.

Here is the Response -

I now use the Stage File action to read the file -

I run the integration - its Response -

Box Adapter in Detail

Now to some detail on the adapter itself -

The adapter leverages the Box apis under the hood - those apis are detailed
here

So what does the OIC Box adapter actually support -
I

Most of these are self-explanatory, except maybe -
Get Enterprise Templates

Box allows one to create Templates via its Admin Console; here's an example -

So let's try this out -

marker can be used for pagination
limit is the max number of templates to be returned per page.

I leave both of these blank - they are optional.

The result is as follows -

Watermarking protects your Box resources from being downloaded and used without your express permission.