Hi @noob_iiq,
-
Is a new record necessary in source table to trigger joiner event ?
The Joiner workflow in SailPoint IIQ is typically triggered based on Lifecycle Events. Generally, when a new identity record is aggregated from the source system into SailPoint, it meets the condition for the Joiner event, which then initiates the Joiner workflow. So yes, a new record in the source table is usually required to trigger this event, assuming the lifecycle configuration is set up correctly. -
Is there any way (please tell step by step) how I can insert all identities in Target_employee table
There are two main ways to achieve this, depending on how your application (e.g., MySQL) is configured:
Option 1: Manual Request via Manage Access
Navigate to Manage Access in the SailPoint IIQ UI.
Select Manage Account.
Choose the required Identity.
Click on Request Account.
Select the target application (e.g., MySQL).
Submit the request to provision the account.
Option 2: Role-Based Provisioning
Define Business Roles and/or IT Roles that include provisioning to the MySQL application.
Assign the appropriate role(s) to the identities you want to provision.
Once the role is assigned and approved, the provisioning process will create the accounts in the target application (Target_employee table).
In both cases, ensure that a Create Provisioning Policy is properly configured for the application (MySQL). This policy defines the attributes and logic used during account creation.
In both cases, ensure that a Create Provisioning Policy is properly configured for the application (MySQL).
- Is Java mandatory to learn first to write any rules before exploring any IIQ topics ?
You don’t need to master Java before exploring SailPoint IIQ, but basic Java knowledge is definitely helpful, especially when working with rules.
It’s recommended to first get familiar with IIQ’s features and workflows. Once you understand the platform, you can gradually learn the Java basics needed to write and customize rules.
Getting Started with SailPoint IIQ Development this blog will help you to learn the IIQ development.