iPaaS@ORACLE.CLOUD: August 2022

OCI Dashboards are a great value add to the OIC administrator's toolbox. The screenshot above shows base message statistics from multiple OIC instances, running in different regions; a boon for admins running OIC in multiple data centres.

Before going into the details of creating such, how do I get there?

The main OCI Logging page provides the link.

The Dashboard is composed of Widgets - here are the first three, based on Service Metrics -

I've covered Service Metrics in many previous posts - but, for the neophytes among you, I'll go thru the process. I click Add Widget - note the groups available. I will click Monitoring -

A new monitoring widget is added to my dashboard, all I need to do now is click Configure -

I enter an appropriate name - note the visualisation options -

Now to the main configuration - note the ability to choose the region -

Note the Dimensions available - flowCode refers to integrations - so we could have a widget that jut renders this information for a specific integration -

flowVersion refers to the version of the integration e.g. 1.0.0.0

resourceId refers to the OIC instance itself as I could have multiple OIC instances in the same compartment. Here is the result -

The next set of widgets refer to my Oracle Integration 3 in the Vinhedo region -

Note that I am only billed on the 2 integrations - AA_MAIN and AA_CREATE_CUSTOMER

However, note the other widgets, those covering actual messages processed, include another integration - AA_CHILD. This is because AA_CHILD is invoked locally by AA_MAIN, the return payload < 50kb, thus incurring no billing charges. The next set of widgets give us more details about the flows from my Phoenix OIC instance -

I have used the table visualisation to show the entries fro the OIC Activity Stream. The Dashboard user will be able to drill down into this data, using the OCI Log Explorer.

The pie chart gives us a nice breakdown of integrations - so I can easily see where my resources are being spent -

Note the Group By here -

As you can see, I can also slice the data based on endpoint - data.endpointName.

Let's return to the table displaying the OIC Activity Stream data from Phoenix -

Note the link - Open with Logging Search - here we can drill down into the log file contents. For example, let's search for a specific product, our excellent iBike. We have an integration that processes orders and the product is a request payload field.

We can enter an expression to search for that - the WHERE query is simple - | where logContent = '*iBike*' |

These searches can be saved -

Finally, let's look at individual adapter usage. My Oracle Integration 3 instance has integrations using the Netsuite adapter -

The Configuration is as follows -

Summa summarum, OCI Dashboards allow us to easily assemble dashboards on top of OCI Service Metrics and OIC Activity Stream logs.

These dashboards are, in part, interactive, allowing users to drill down and explore the logs. These "explorations" can be saved for easy future access.

Try out OCI Dashboards and let me know what you think!

OCI Metrics provide great insight into your Oracle Integration instances - these can be easily accessed by clicking on the instance link.

The last 2 are new for Oracle Integration 3, so let's take a look at them -

BilledMessageCount is of special interest to all customers. I often get asked about monthly statisitcs - e.g. what are my top integrations this month from a billing perspective - this is easily answered here.