Previous Topic: CMS and iConsole RequirementsNext Topic: Primary User Requirements for Dashboard


Database Requirements

The reports and dashboard reports.msi support the following databases:

Database

CA DataMinder servers need sufficient memory and processing power to run your chosen database application. See your database documentation for details. The supported databases are:

Oracle 10g (10.2.0.4) or 11g (11.1.0.7), 11g Release 2, or later.

Oracle 10g users may see improved search and report performance by applying the following Oracle fix 5765456:7. See the following My Oracle Support (formerly Oracle Metalink) notice: "Bug 5040753 Optimal index is not picked on simple query / Column group statistics."

Microsoft SQL Server 2005

We recommend SQL Server 2005 SP2.

Microsoft SQL Server 2005 Express Edition

(Not recommended for CMSs)

Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2

Note: SQL Server is supported on Windows servers only. Also, for SQL Server 2005, verify that the SQL Server Browser service has started. See the Database Guide for details.

Note: If you want to set up your CA DataMinder primary user before installing a new CMS, you can find instructions in the Database Guide on manually creating Oracle users and SQL Server logins. See the 'Oracle Guidelines' and 'SQL Server Guidelines' chapters respectively.