At OpsLogix we’re always exploring new technologies and finding ways to use them in our products. Two days ago Microsoft released a new API for pushing data into Microsoft OMS Log analytics called the “HTTP Data Collector API“. Click here for additional information.
OpsLogix Microsoft OMS Log Analytics Solution
At OpsLogix we’re proud to announce that we already have an OMS solution available that makes use of this new technology and pushes all your Oracle monitoring data into Microsoft OMS Log analytics without the need of a SCOM environment. The solution works completely independent from SCOM, so there’s no need to install any SCOM components! Once the data is pushed into OMS you can create Alert triggers or view the data on the almost ‘real-time’ dashboards.
What does the OpsLogix Microsoft OMS Log Analytics Solution look like?
Two dashboards are provided that need to be imported into OMS, these dashboards will give you a great out of the box overview of your Oracle environment in OMS. A dashboard called “OpsLogix Oracle Performance” contains ‘all you need to have’ Oracle information and an “OpsLogix Oracle Auditing” dashboard contains all the security related information.
The OpsLogix Oracle Performance dashboard
This dashboard contains an overview of the most important Oracle metrics, for example, tablespace usage, memory consumptions, user sessions, database sizes, etc. It also contains smart OMS queries, that will, for example, give an indication when a tablespace free space has hit a threshold. The data will be refreshed automatically so you are able to use it as a NOC overview.
The OpsLogix Oracle Auditing dashboard
What actions are executed on the databases, how many failed logons do I have or who created/modified access permissions? With the OpsLogix Oracle Auditing dashboard you have all the important Oracle security auditing data at your fingertips.
Using the OMS Alert feature, you are also able to automatically send alert emails when, for example, when five failed logons were detected in the last 10 minutes. You can even run an Azure automation task to lock the account when it’s showing suspicious activity and more.
How does the OpsLogix OMS Solution work?
The following components are needed:
– A Windows server that will act as the Oracle to OMS Collector. This server needs to have internet access (or at least reach the OMS http rest API url’s) and it also needs access to the Oracle instances you would like to monitor.
– The OpsLogix OMS Oracle Collector service needs to be installed on the Oracle OMS collector server.
– A valid OpsLogix OMS Oracle Collector license is needed for every Oracle Instance you are going to monitor (We provide test licenses for free!). Just contact email@example.com
– A Microsoft OMS account. You can get one for free, just click here.
– An Oracle monitoring account for every Oracle Instance you want to monitor. This account has to have at least a Read Only access to the tables needed for monitoring.
The OpsLogix OMS Oracle Collector solution contains a NT service that will collect the Oracle monitoring data and push it into OMS. Using the Configuration Dashboard, you can specify the Oracle instances you want to monitor and at what interval.
The diagram below shows a technical overview of the solution:
If you are interested in trying out the solution, just contact us at firstname.lastname@example.org and be surprised how easy it is to get your Oracle environments under control.