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 thehierarchy.
You can also write custom queries that extract data directly from the tables.