Problem Disabling Accounts in JDBC Source

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

We have created a string field called IIQDisabled in the schema and added it in the SELECT statement as follows:

SELECT * ,case when laboralState=‘ACTIVE’ then ‘false’ else ‘true’ end as IIQDisabled FROM database.table

This is based on the documentation we found here: Loading Single Account Group in JDBC. The query works correctly when executed directly in the database. However, when performing the aggregation, the IIQDisabled field remains empty, and I fear this is why the relevant accounts are not being disabled. Any ideas on why this is happening?

Thanks and regards,
Antonio

2

Hi @AntonioGvtt
I recommend you to use jdbcbuildmap rule instead.
map.put(“IIQDisabled”, “true”); → use this in rule

3

Thank you, @gourab ! I have created the rule, but should this rule be placed within some connector attribute in the source? Or how is the rule inserted into the source, as I have never used it before?

4

You need to use api (source patch) to attach the rule to the source itself. You can check here for more details: Connector Executed Rules | SailPoint Developer Community

5

By implementing the jdbcBuildMap rule, the issue has been resolved.

Thanks @gourab

1 Like