Tuesday, August 30, 2022

#928 - OCI Dashboards for OIC

 


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!
 

#927 Oracle Integration - OCI Metrics

 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.


Naturally, I can also enter my own specific start and end times - 

So let's look at the graph and the data -



Note the breakdown by integration and adapter type, in both cases, rest.

That's the Billing view - not lets look at the Configured Messages data - 


As you can see, 5k messages per hour, so 1 message pack configured.

Next Metric is NumberOfInboundRequests



Note the format of the data shown - details trigger type, http verb used etc.

On to NumberOfOutboundRequests -  


Note the format of the data shown - details adapter type etc. colocatedics refers to local invoke.

I can also add adapter specific dimensions - here I am just interested in the number of Netsuite invokes - 



I can also switch to the Graph view - 


Great stuff! Now let's look at another widget - 



We can add dimensions such as flow code - which is essentially the individual integration.


resourceId refers to the OIC instance -


Another great feature here is Alarms


The Alarm has been configured to fire if the Netsuite invoke takes longer than 3 seconds - 


The alarm is linked to OCI notifications service - 


I do a stress test of the createNetsuiteCustomer integration, triggering the alarm - 

I receive the relevant email -