igisql.properties
The igissql.properties file contains properties to define SQL queries using which data can be retrieved from SVG-Gov database.
Overview
Data can be retrieve from two types of ISVG-Gov supported databases: IBM DB2 and Oracle.
To retrieve data from IBM DB2, set this property. igi.dbtype=DB2
To retrieve data from Oracle, set this property. igi.dbtype=Oracle
The following table lists property names which can be helpful in retrieving the data. The default values of these properties are defined in the igisql.properties file. There are OOB queries defined for DB2 and Oracle to retrieve data for different entities and configurations. Depending on the type of DB being supported, please uncomment the queries in the corresponding section of the file.
The values of these properties can be updated with custom queries too. In that case, the names of the properties must remain the same.
| Property Name | Description |
| igi.user.sql.users | Fetch user details from AGC - Manage - Users. |
| Also fetches user accounts and populates those in the "eraliases" column. | |
| igi.user.sql.user-types | Fetch user type details which can be managed via AGC. |
| igi.user.sql.ume | Fetch UME details which can be managed via AGC. |
| igi.userconfig.sql.userattrmapping | Fetch user attribute mapping details from AGC - Settings - User Virtual Attributes. |
| igi.userconfig.sql.feed-userattrmapping | Fetch user attribute mapping details used in different feed files. |
| igi.userconfig.sql.useraccmapping | Fetch user to account mapping details. |
| igi.userconfig.sql.provconfig | Fetch provisioning configurations from AGC - Manage - Account Configurations - Creation Policy. |
| igi.userconfig.sql.targetattrs | Fetch target attributes from AGC - Manage - Account Configurations - Target Attributes. |
| igi.userconfig.sql.provconfigrules | Fetch rules used for provisioning accounts from AGC - Manage - Account Configurations - Creation Policy - Rule Flow. |
| igi.pwdconfig.sql.passwordconfig | Fetch password configurations from AGC - Manage - Account Configurations - Password Policy. |
| igi.pwdconfig.sql.dictwords | Fetch dictionary words defined in above password policies. |
| igi.pwdconfig.sql.passwordconfigrules | Fetch rules used for provisioning password policy from AGC - Manage - Account Configurations - Password Policy - Custom Construction Rule. |
| igi.service.sql.applications | Fetch application details from AGC - Manage - Applications. |
| igi.service.sql.ib-connectors | Fetch connector details from Enterprise Connectors - Manage - Details and Driver Configuration pages for connectors with type Identity Brokerage. |
| igi.service.sql.nonib-connectors | Fetch connector details from Enterprise Connectors - Manage - Details and Driver Configuration pages for connectors with type other than Identity Brokerage like different feed types, DB, LDAP, CSV etc. |
| igi.service.sql.profiles | Fetch details of the profiles uploaded in Enterprise Connectors - Manage - Profiles section. |
| Note: The actual profile jars are not exported here. | |
| igi.ou.sql.ou-types | Fetch OU type details which can be managed via AGC. |
| igi.ou.sql.ous-default-hierarchy | Fetch organization units/groups belonging to "ORAGANIZATIONAL_UNIT" hierarchy. These are managed under AGC - Manage - Groups. |
| igi.ou.sql.ous-custom-hierarchy | Fetch groups belonging to hierarchies other than "ORAGANIZATIONAL_UNIT" hierarchy. These are managed under AGC - Manage - Groups. |
| igi.ou.sql.ou-properties | Fetch properties defined for different organization units managed under AGC - Manage - Groups. |
| igi.ou.sql.hierarchy-details | Fetch hierarchy details from AGC - Configure - Hierarchy. |
| igi.roles.sql.organization-roles | Fetch business/organization roles from AGC - Manage - Roles - Business Roles. |
| igi.roles.sql.application-roles | Fetch IT/application roles from AGC - Manage - Roles - IT Roles. |
| igi.roles.sql.external-roles | Fetch external roles from AGC - Manage - Roles - External Roles. |
| igi.roles.sql.permissions | Fetch permissions from AGC - Manage - Roles - Permissions. |
| igi.roles.sql.admin-roles | Fetch administrative roles and permissions which are provided out of the box in IGI. These are managed from AGC - Manage - Roles. |
| igi.hierarchy.sql.rules.live-deferred | Fetches rules from AGC - Configure - Rules - Live Events and Deferred Events. |
| igi.hierarchy.sql.rules.advanced | Fetches rules from AGC - Configure - Rules - Advanced. |
| igi.hierarchy.sql.rules.accounts | Fetches rules from AGC - Configure - Rules - Account. |
| igi.hierarchy.sql.rules.attestation | Fetches rules from AGC - Configure - Rules - Advanced. |
| igi.hierarchy.sql.rules.hierarchy | Fetches rules from AGC - Configure - Rules - Hierarchy. |
| igi.hierarchy.sql.rules.password | Fetches rules from AGC - Configure - Rules - Password. |
| igi.certification.campaign.sql.details | Fetches details of certification campaign from AGC - Configure - Certification Campaigns. |
| igi.certification.dataset.sql.details | Fetches details of certification campaign from AGC - Configure - Certification Datasets. |
| igi.config.sql.email-notifications-configuration | Fetch email notification settings from AGC - Configure - Notifications - Notification Settings. |
| igi.config.sql.email-notifications-template | Fetch email notification template details from AGC - Configure - Notifications - Notification Templates. |
| igi.config.sql.email-notifications-campaign-config | Fetch email notification details for different certification campaigns from AGC - Configure - Certification Campaigns - Selected Campaign - Notification. |
| igi.config.sql.email-notifications-workflow-config | Fetch email notification details for different workflow from Process Designer - Manage - Process - Selected workflow - Configuration - Notification Widget. |
| igi.sql.risks | Fetch risk details from ARC - Manage - Risk Definitions. |
| igi.sql.buisness.activities | Fetch business activities details from ARC - Manage - Business Activities. |
| igi.sql.business.activities.permission | Fetch business activities to permission mapping from ARC - Manage - Business Activities - Linked Permissions. |
| igi.sql.risks.business.activities.without.hierarchy | Fetches the risk to business activity mapping without hierarchy from ARC - Manage - Risk Definitions - Selected Risk - Activity. |
| igi.sql.risks.buisness.activities.with.hierarchy | Fetches the risk to business activity mapping with hierarchy from ARC - Manage - Risk Definitions - Selected Risk - Activity. |
| igi.arc.sql.mitigation.controls | Fetches details of mitigation controls from ARC - Manage - Mitigation Controls |
| igi.arc.sql.applicable.mitigation.controls | Fetches the risk to applicable mitigation mapping details. |