Database Guide › Introduction › Supported Databases

Supported Databases

The following table describes CA DataMinder database support:

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 the SP2 release.

• Microsoft SQL Server 2008
• Microsoft SQL Server 2008 R2
• Microsoft SQL Server 2008 Express Edition

  Not recommended for CMSs or FastStart base machines.

• Microsoft SQL Server 2012

Note: SQL Server is supported on Windows servers only. Verify that the SQL Server Browser service has started.

Hardware

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

Windows servers

On all Windows CMSs and gateways, you also need Microsoft Data Access Components (MDAC) 2.6 or higher.