You are here

Data Warehouse

Opsview Data Warehouse (ODW)

The Opsview Data Warehouse, or ODW, is the long term storage for monitoring data. It converts the data from the Runtime database into an OLAP (On Line Analytical Processing) datawarehouse format. When generating reports, the data comes from the Opsview Data Warehouse.

A core requirement for a datawarehouse is to not normalise the data too much, yet still allow queries to be easily created. As you'll see, hopefully we will have reached this target.


The datawarehouse pulls data in once an hour. It works out if there have been any configuration changes and stores those if required. It then saves various Runtime information before calculating the summary statistics.

Distributed Monitoring

ODW calculates information based on the central Opsview Runtime database. Any Collectors monitoring remote sites will automatically send their information to the Orchestrator which updates the central database, and hence will be captured in ODW as well.

Easily store long term monitoring data

More like this

Why monitoring IT infrastructure is so important
By Jess Korn, Senior Marketing Manager

With a modern IT infrastructure monitoring system in place, teams are able to anticipate and resolve issues before there is any business impact....

opsview monitor 5.4
By Tom Hayes, VP of Marketing

Does you company have too many tools and too many inconsistencies? Here are three keys to monitoring IT from a single pane of glass. 

Tips on IT Infrastructure monitoring
By Freya Ballan Whitfield, Digital Marketing Executive

Monitor your networks so you can be more productive and avoid serious threats from network failures and server downtime.