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
By Tom Hayes, VP of Marketing

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

AWS Monitoring
By Josh Kirkwood, Pre-Sales Engineer

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

By Josh Kirkwood, Pre-Sales Engineer

Monitoring network traffic is an incredibly powerful way to understand issues or problems within your IT environment.