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, Identity Reporting, and the Workflow Engine.
If you are allowing the installer to create the databases, the databases must either be absent or not contain 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 installer creates databases with default names. If you are manually creating the database, you must use these default names, which are 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 |
|
workflow engine |
igaworkflowdb |
For production environments, you must install one database server that hosts multiple Identity Governance databases. You can install the Identity Governance databases, the Identity Reporting database, and the Workflow Engine 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.