4.0 Tables and Views

SQL Views uses views to make data stored in tables accessible for creating reports using third-party reporting tools. There are two types of views:

  • Predefined: Called system views that ship with Operations Center

  • Custom: views that you create

You can create views from a single table in the Operations Center console or you can use a third-party tool, such as Apache Derby to create views from multiple tables.

System views extract data only one level deep in the Operations Center hierarchy.

You can also write custom queries that extract data directly from the tables.