JDBC source - account status not being mapped

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

Hi! I have just worked with other jdbc connectors, and having an IIQDisabled attribute with true/false value) is enough to let an account be enabled or disabled.

I have a connector which is configured with this pseudo-attribute:

image
image1204×554 35.2 KB

This is not working, as all accounts are apparing as Enabled. This is, an account that IIQDisabled evaluates to true:

image
image1367×668 23.9 KB

Strange that IIQDisabled appears without value. Is something I am missing? I compared with other jdbc source and can not find difference.

2

Hi @jsosa,

Try this:

case when ACCOUNT_STATUS=“LOCKED” then ‘true’ else ‘false’ end as “IIQDisabled”

1 Like
3

Thanks! Problem was double quotes on IIQDisabled.