How to Set Up SailPoint IdentityIQ (IIQ)

Setting up SailPoint IdentityIQ involves installing and configuring a few key components. Below is a step-by-step guide to get your environment ready.

---

1️⃣ Required Software

To set up SailPoint IIQ, you need the following software:

• Java JDK (e.g., JDK 11)

• MySQL Server (e.g., MySQL 8.0)

• Apache Tomcat (e.g., Tomcat 9)

• SailPoint IIQ JAR/WAR files (e.g., SailPoint IIQ 8.4)

💡 You may also use Oracle, PostgreSQL, or SQL Server instead of MySQL, but MySQL is commonly used and well-supported. Similarly, SailPoint supports other servers like Oracle WebLogic, IBM WebSphere, or JBoss EAP — however, Apache Tomcat is lightweight, efficient, and widely adopted, so we'll use it for this setup.

---

2️⃣ Java Configuration

• Download a JDK version compatible with your IIQ version.

• Extract it and configure the following environment variables:

  • JAVA_HOME: Set to your JDK installation folder

  • Add %JAVA_HOME%\bin to your system PATH variable

• Verify installation by running java -version in the terminal.

---

3️⃣ MySQL Server Setup

• Download and install MySQL Server.

• Configure the environment variables:

  • Add the MySQL bin directory to your system PATH.

---

4️⃣ Apache Tomcat Server Setup

• Download and extract the Apache Tomcat version of your choice.

• Configure environment variables:

  • CATALINA_HOME: Set to the Tomcat root directory.

---

5️⃣ Deploy SailPoint IIQ

1. Download the SailPoint IIQ installation ZIP from the official site.

2. Extract it to a folder inside the Tomcat directory (e.g., IIQ_Installation).

3. Copy identityiq.war into Tomcat’s webapps folder.

4. Start Tomcat — it will automatically extract the WAR and create an identityiq directory.

5. Stop Tomcat and delete the identityiq.war to avoid re-extraction.

---

6️⃣ Generate Database Scripts

1. Start both Tomcat and MySQL servers.

2. Open the command prompt and navigate to:

    bashCopyEdit<TOMCAT_HOME>/webapps/identityiq/WEB-INF/bin
   

3. Run the following command:

    graphqlCopyEditiiq schema
   

   This will generate SQL scripts inside WEB-INF/database.

---

7️⃣ Create SailPoint IIQ Database

1. Navigate to the WEB-INF/database folder.

2. Open MySQL CLI:

    >mysql -u root -p
   

3. Run:

    >source create_identityiq_tables.mysql;
   

4. Verify the database creation:

    >show databases;
   

---

8️⃣ Import SailPoint Modules

1. Open the IIQ console:

    >cd <TOMCAT_HOME>/webapps/identityiq/WEB-INF/bin
    iiq console
   

2. Import the initialization files:

    >import init.xml
   

   You can also import other modules:

   • init-lcm.xml → Life Cycle Manager

   • init-pam.xml, init-ai.xml, init-cam.xml, init-rapidsetup.xml

---

✅ Final Tip

Make sure you restart the Tomcat server after completing the setup and importing modules. You're now ready to log in to the SailPoint IdentityIQ application!