Install and Configure Your Database Software

This article describes the steps that are required to configure the CA UIM database before CA UIM installation. The following topics cover the information:
uim901
This article describes the steps that are required to configure the CA UIM database before CA UIM installation. The following topics cover the information:
2
2
If you have questions regarding which database vendor software is supported with CA UIM, refer to the Compatibility Support Matrix. For general database installation procedures, refer to the product documentation provided by your database vendor
Determine Your Database Creation Method
Determine the method that is used to create the UIM database before you run the UIM Server installer. Once you have chosen a creation method, follow the instructions for your database software.
Review the following information in this section:
  • UIM Server Installer Creates the Database schema 
  • Manual Creation of the Database Schema and User
UIM Server Installer Creates the Database Schema
The UIM Server installer can create the UIM database as part of the installation process. If you use this method, the UIM installer requires access to a database account with administrator privileges. Examples include:
  • root in MySQL
  • sa in Microsoft SQL Server
  • SYS in Oracle
When you run the installer, enter the credentials for designated account.
If you use this installation method, skip the
Manual Creation of the Database Schema (or Tablespace) and User
section for your database software.
Manual Creation of the Database Schema and User
If you do not want to give the UIM Server installer access to an administrator account, you can create the UIM database and associated user manually. We recommend manual database creation in environments that have a dedicated Database Administrator. Before you install UIM Server, verify that the created user is the schema owner in Oracle or MySQL instances, or the Database Owner (DBO) in Microsoft SQL Server instances. Also, verify that the user is granted all permissions for the schema. If you create the database and user in advance, click
Use existing database
when prompted by the CA UIM installer.
We recommend that you begin with a fresh database installation on a clean system. Using a pre-existing database can cause subtle configuration conflicts that are hard to diagnose.
Access Database-Specific Information
Access the appropriate section depending on your database: