7.0 Configuring and Administering the Database

Operations Center uses various embedded databases to store configuration data and support connections to both embedded and external data stores.

When configuring Operations Center, you’ll need to set up and configure databases to handle the following features:

  • Configuration Storage: define a database for Operations Center configuration data, version tracking, and to control connections to all databases configured for use with Operations Center, including the Event Data Store, Service Warehouse, Configuration Storage.

  • Event Store: define a database for SNMP Integrator, Event Manager, and/or alarm suppression. Note that alarm suppression is not supported on Sybase.

  • Service Warehouse: define a database to record alarm history and comments, historical performance and Service Level metrics.

  • Dashboard: must be configured to use an external database. See the Operations Center 5.6 Dashboard Guide for more information and configuration information.

For information about supported databases and versions, see Supported Databases in the Operations Center 5.6 Getting Started Guide

Database Definitions are used to define database connections for Operations Center (except the Configuration Storage). They are also to connect to external data sources that provide additional data for Service Level Agreement calculations.

In addition, the following Operations Center features and products use embedded databases:

  • Configuration Storage: initially uses an embedded data store before the external database is configured.

  • Dashboard: is installed with a Hypersonic SQL data store for dashboard configuration settings. However, an external database must be configured for the dashboard.

  • SQL Views: uses an Apache Derby database to make data available.

For information about embedded databases, see Embedded Databases for Dashboard, SQL Views, and Operations Center Server in the Operations Center 5.6 Getting Started Guide

The following sections provide further details regarding the various data stores and explain how to configure external databases for configuration storage, event store and the Service Warehouse: