CA Identity Manager Configuration Guide › Relational Database Management › Organization Management › Configure Organization Support in the Database

Configure Organization Support in the Database

Follow these steps:

1. Open one of the following SQL scripts in an editor:
   • Microsoft SQL Server databases:

     ims_mssql_rdb.sql

   • Oracle databases:

     ims_oracle_rdb.sql

     These files are placed in the following location:

     admin_tools\directoryTemplates\RelationalDatabase

     admin_tools refers to the installed location of the Administrative Tools, which are installed by default in one of the following locations:

     Windows: C:\Program Files\CA\Identity Manager\IAM Suite\tools

     UNIX: /opt/ca/IdentityManager/IAM_Suite/Identity Manager/tools

2. In the SQL script, search for and replace <@primary organization table@> with the name of the primary table for the organization object. Save the SQL script.
3. Run the SQL script against the database.