Tuesday, October 31, 2017

#603 Oracle Integration Cloud on YouTube

Oracle Integration Cloud, Oracle's compelling new cloud offering combines application integration, Process Automation, Visual Application Building and Integration Analytics into one unified cloud service.

Check out the video here

#602 - ICS --> NetSuite to Zendesk integration

Here is a simple example of integrating NetSuite with Zendesk.
We will raise a ticket in Zendesk for a case, created in NetSuite.

I start by creating a NetSuite connection. This process is described in the previous post, available here

I then leverage the ICS REST adapter to access Zendesk. BTW. I logged in to Zendesk and took advantage of their free 30 day trial offer.

So my Zendesk account is as follows -

The REST connection in ICS in defined as follows -

Simple stuff!

I now create an Orchestration in ICS - trigger will be a schedule -

The logic is as follows - an internal NetSuite case id is passed into the process. The process variable is defined at Schedule level. This is then used to retrieve the Case from NetSuite. This case data is then used to create a ticket in Zendesk.

Here is the variable definition -

As you can see, I have hardcoded a value.

The NetSuite Invoke is configured as follows -

The NetSuite adapter offers comprehensive access to the product -

The Zendesk invoke is configured as follows -

Finally I add a Notification action to send out an email containing a link to the ticket in Zendesk -

Now to the testing -

Here is my case in NetSuite -

Hare of the Dog has gone missing - shock, horror!

I execute the test -

I click on the link in the email -

So easy, thanks to ICS.

#601 - ICS Netsuite adapter configuration

Here is an example configuration of an ICS connection

Yes, I have obfuscated some of the fields, but let's go thru them individually -



So from where did I get the version nr?

Now, I have little or no knowledge of NetSuite as an app, so I just logged in and searched.

so there it is, 2017.2

so my wsdl looks like -


Now to some NetSuite nomenclature -

A “user” is an individual who has access to a NetSuite account.
  •        Generally, most users are employees, but vendors, partners, and customers can also be users.

Email Address: This is your NetSuite user name

Account: This is your company account.

This information can also be garnered by logging into NetSuite and opening up any form within it,
then right click - view page source. Look at the bottom left of the page.

Role: the numeric value of the NetSuite role - for me it is 03. The NetSuite user has to have the
Admin role granted to it.

Application ID: You can generate this from within NetSuite -

Then test it -

Thursday, October 12, 2017

#599 APIP CS Analytics/Monitoring and custom logging

Monitoring of APIs is a very important feature of Oracle's API Platform Cloud Service.
We can do so at three levels -

1. Management UI


3. Gateway logs

So, as usual, here is a simple example to get us going.

As you can see, the API leverages the new APIP CS Service feature, which essentially
virtualises the backend endpoint.

Here is the Service Definition for my backend Bank Balance service -

The service is essentially a SOA Composite running on my laptop.

Anyway, back to monitoring -

I deploy the API to my Gateway and execute some tests via Postman.

My first test doesn't include the required app-key, so it gets rejected.

I now add the app key and re-test - and see the response I expect

I now execute some more requests so as to hit the throttling threshold -

Analytics via Management Portal UI 

Let's drill into the Errors & Rejections -

Now let's look at retrieving the same via the REST API.

Analytics via APIP CS REST API

Here I look for all rejections -

Again, I test using Postman -

Nice stuff!

Analytics via APIP CS Gateway logs

I find my Gateway log files here - 


I check out the most recent logfile -

Now to the final piece -

the Response definition of the API is as follows -

As you ca see, I have included a Logging Policy -
Here I attempt to log the customer account number, returned by the backend service.

As you can see, the default custom logfile is called apipcs.log.

I find that logfile here - /out/domains/gateway1/apics/customlogs

so it failed to find the accoountNr, now what a surprise.
I now go back to the API definition and amend the Log policy accordingly.

Monday, October 2, 2017

#598 Oracle Unveils Oracle PaaS and IaaS Universal Credits

read all about it here

The actual service descriptions are available here