4.3 Databases

The following sections provide information about supported database management systems for Operations Center components, embedded databases, and JDBC driver support for Data Integrator deployments:

4.3.1 Supported Databases

Supported database management system version are outlined in Table 4-3 by Operations Center component. Application performance varies depending on the underlying database architecture. For assistance in selecting the most efficient database for your implementation, contact Novell Consulting.

Table 4-3 Supported Management Systems by Product Component

DBMS

Configuration Storage*

Service Warehouse & Event Data Store**

Version Tracking

Dashboard

Event Manager

Experience Manager

IBM DB2 9.7

X

X

Microsoft SQL Server 2008, 2012

X

X

X

X

X

X

Oracle 11g

X

X

X

X

X

X

PostgreSQL 8.4

X

X

X

 

Sybase ASE 15.5

X

X**

X

X

*The database used for Configuration Storage must be case insensitive.

**The Event Data Store for use with SNMP Integrator and Alarm Suppression only. See Event Manager column for supported databases with that use case. Note that Alarm suppression is not supported on Sybase.

4.3.2 Embedded Databases for Dashboard, SQL Views, and Operations Center Server

Table 4-4 lists products that have embedded databases installed as part of the product installation.

Table 4-4 Embedded Databases

Product

Installs with…

Dashboard

HypersonicSQL database to store portlet and configuration information. It is necessary to configure the dashboard to use Oracle or SQL Server.

For more information about configuring a database for the dashboard, see the Operations Center 5.0 Dashboard Guide.

SQL Views

Apache Derby, a relational database implemented entirely in Java.

Operations Center Server

Object ODB which can be used for the Configuration Storage database.

4.3.3 JDBC Support in Data Integrator

Data Integrator features and functionality are fully supported. Because each deployment is end-user specific, a best level effort of support is provided on JDBC issues and definition deployments.

The Data Integrator supports JBDC drivers in general. Connection templates are provided for the following commonly used databases:

  • Apache Derby

  • IBM DB2

  • JTDS

  • MS SQL Server

  • MySQL

  • Oracle

  • Postgres

  • Sybase

  • Sybase JConnect