5.1 Understanding the Identity Governance and Identity Reporting Databases

Identity Governance requires five different databases to function and one database for Identity Reporting. You can allow the Identity Governance installer to create and populate these databases for you or you can have your database administrator create and populate the databases for you using a SQL file that the installer generates. It depends on your IT policies of who can modify databases and as to whether you allow the Identity Governance installer to create and populate the databases or whether your database administrator creates and populates the databases.

Whether you allow the installer to create the databases or if you have your database administrator create the databases, you must have the databases installed and running before starting Identity Governance and Identity Reporting.

If you are allowing the installer to create the databases, the database must be installed but not contain any data for the installer to be able to properly create the databases. For more information, see Section 5.4, Using the Identity Governance Installer to Create and Populate the Databases.

If you are manually creating the databases, you must have all of the databases created with the proper names before starting the installation. For more information, see Section 5.6, Manually Creating and Populating the Databases.

The databases have specific names that the installer creates for you. If you are manually creating the database, you must use these specific names, as listed in the following table.

Table 5-1 The Identity Governance Databases

Database Function

Default Database Name

operations

igops

archive

igarc

data collection

igdcs

workflow

igwf

analytics

igara

Identity Reporting database

igrpt

For production environments, you must install one database server that hosts multiple Identity Governance databases. You can install the Identity Governance databases and the Identity Reporting database on the same database server. For more information about Identity Reporting, see Section 7.0, Installing Identity Reporting.

Each database performs a specific function. For example, the data collection database stores the catalog information for your identity sources and application sources. The administration console for Identity Governance displays these database names with the associated functions you must perform.