How do you consolidate all of the data from your various monitoring solutions?

In automobiles, by design, the monitoring (sensors – oxygen, tire pressure, fuel, etc) all send their information to the dashboard and display it in a method understood by over 90% of the vehicle operators – even the dreaded “check engine” light. With enterprise monitoring/management solutions, each monitoring solution stores collects and presents data in the method of the providers choosing. There exists no standard.

There is no easy solution but it is possible. If all of your monitoring tools store their data in ODBC or SQL accessible data stores, then Microsoft SQL Server data services provide a simple method to connect to multiple data sources and create reports. Other considerations include SAP’s reporting tools (crystal reports and/or business objects). This assumes your monitoring solution stores data in an accessible database – some store data in proprietary formats or create log files.

The final method is to find an enterprise monitoring/management vendor that satisfies your requirements within your budget and time restraints. These vendors have methods to standardize the data from various monitoring solution and include some method of presenting the results.

Good luck!