Total Pageviews

Monday, September 30, 2019

Sailpoint iiq configuration with ms Sql Server



Sailpoint Configuration Steps:

  • Create an \idenityiq directory under the Tomcat webapps directory: for example, C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq
  • Unzip the identityiq-7.3.zip file.
Copy iidentityiq.war file to the C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq
Run below command to extract identityiq.war
jar -xvf C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq\identityiq.war
  • Create the database schema:
    • In the command prompt window, change to the C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq\WEB-INF\bin   directory
    • Enter iiq schema to create the schema
  • Create the database from the schema
    • In the command prompt window, change to the C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\WEB-INF\database   directory
    • Log in to SQL Server thru "Sql Server Management Studio" and click on the new query and 
      copy contents from  source create_identityiq_tables.sqlserver
    • Run this command to load the schema into SQL Server:
        Check that the database was created by typing  show databases; You should see identityiq listed among the databases (there will be other databases listed; these don't matter for IdentityIQ).
  • Type quit to exit SQL Server.
  • Navigate to the \tomcat\webapps\identityiq\WEB-INF\bin directory
  • Launch the iiq console by running this command:  iiq console
    Allow the console a few moments to launch. The console is running when you see a > symbol in the command prompt.
  • In the IdentityIQ console, run this command:  
import init.xml
Import init-lcm.xml
  • When the import is complete, type quit to exit from the IdentityIQ console.
  • Restart Tomcat Server

Login to Identity IQ at http://localhost:8080/identityiq/ with spadmin/admin credentials

1 comment:

  1. would you be able to share the identityiq installer?

    ReplyDelete