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

opsview monitor 5.4

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

Tips on IT Infrastructure monitoring

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

AWS Monitoring

A look at the advantages of monitoring AWS on top of CloudWatch, particularly for data capture, metrics and service checks.