Account Status

For the Flat File source, to set an account as enabled or disabled based on the values inside a specific column, you can add the IIQDisabled (string) attribute in the source account schema. For more information on editing the account schema, refer to Managing Source Account Schemas.

The following SQL query can be used to set up the state for the account:

select ... case when Active=1 then 'false' else 'true' end as IIQDisabled from ...

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.