Previous Topic: Database GuideNext Topic: Log Files for Support


About Databases

Before installing the CMS or a gateway server, your chosen database engine must already be installed and correctly configured on the target server. This guide contains guidelines for setting up your Oracle or SQL Server database engine. Later chapters provide general indexing advice and instructions for setting up database purges.

The key database requirements are:

Oracle

You must set up a database for CA DataMinder, a service name for the database, and Oracle accounts for CA DataMinder itself. You must also configure the listener and edit the sqlnet.ora file.

SQL Server

You must set up the correct method of server authentication and create logins for CA DataMinder. You also need to edit the database properties to prevent excessive use of disk space.

This section contains the following topics:

Log Files for Support

Supported Databases

Configuring Your Database

Upgrading Your Database

Database Roles

Security Models

Review Queue