The following sections provide information about supported database management systems for Operations Center components, embedded databases, and JDBC driver support for Data Integrator deployments:
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.
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. |
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