Extending IdentityIQ Database (Provisioning Simulator)

[abartkowski (Adam Bartkowski)]

To illustrate how to easily extend the database for IdentityIQ (IIQ), I will use the example of expanding the database for the Provisioning Simulator.

This guide will walk you through the necessary steps to implement changes related to the new spt_provisioning_record table, ensuring a smooth and efficient deployment process.

As part of the upcoming deployment for any environment, it is necessary to implement changes to the database, specifically related to the new spt_provisioning_record table. Please follow these steps carefully:

1. After deploy:

• Navigate to the /bin directory with IdentityIQ (IIQ) console:

2. Execute Schema Changes:

• Once inside the IIQ console, execute the schema update command:
• ./iiq schema

3. Locate Database Scripts:

• Open the WEB-INF/database/ directory.
• Find the file named create_identityiq_tables.sqlserver. (without iiq version in the file name)

4. Identify Table Commands:

• Use the following command to search for the spt_provisioning_record table commands within the create_identityiq_tables.sqlserver file:
• cat create_identityiq_tables.sqlserver | grep -20 spt_provisioning_record
• This command will display the relevant database scripts for creating the table, indexes, constraints, etc.

5. Handle Existing Table:

• If the spt_provisioning_record table already exists, you must remove the existing table along with any associated indexes and constraints.

6. Create the New Table:

• Use the scripts identified in step 4 to create the new spt_provisioning_record table, along with its indexes and constraints.

7. Restart Tomcat:

• Finally, restart the Tomcat server to apply the changes.

[ASuska (Anna Suska)]

It helped me so much! Thank you for sharing that @abartkowski