1.0 About SQL Views

Operations Center SQL Views provides functionality in Operations Center that allows for third-party applications to have read access to Operations Center data. The purpose of SQL Views is to take data from the Operations Center server and the Service Warehouse and make it accessible for you to query it and write reports using it. External products, such as Business Objects Crystal Reports or Microsoft Excel can be used to create reports. In addition to reporting, Operations Center data can also be used by other applications for other business purposes.

The Operations Center server contains real-time data feeds from external management systems and the Service Warehouse contains historical data, such as alarms, Service Level Agreement data, and performance data.

The foundation of SQL Views is Apache Derby, which is a relational database implemented entirely in Java. This database is embedded in the Operations Center server. For more information on Apache Derby, see www.db.apache.org.

To use SQL Views, do the following:

  1. Obtain a license that allows access to both Operations Center SQL Views and the Operations Center Web Services Application Interface.

  2. Configure SQL Views.

  3. Connect a third party reporting tool to SQL Views.

  4. Write queries and create reports using the reporting tool.

The data in SQL Views is surfaced using views. Operations Center ships with some existing system views. You can create additional views to use to create your reports.

The other sections in this guide explain each step in detail and describe how to create new views. In addition, examples of reports that you can create are included in Section 5.0, Example Reports.

In order to explain how to use SQL Views, this guide includes step-by-step instructions and illustrations from other products that are not associated with Operations Center, including Microsoft Excel and Business Objects Crystal Reports. These instructions and illustrations can vary, depending on the version of the product being used. Consult the documentation for the product for additional information.