Integrating SailPoint IIQ with application using JDBC connector

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Sailpoint IIQ 8.3

Share all details about your problem, including any error messages you may have received.

I am integrating SailPoint IIQ with application using JDBC connector. We have account statuses captured in the database table column name STATUSKEY which represents the value 0/1 for active/Inactive accounts. How do I use it to show the account status as active/Disabled in SailPoint IIQ?

2

Hi @Mahejabeen_Navidgi Please see if this helps - JDBC Connector - Display account as "Disabled" - #2 by kevinwoodbury

Thanks,

Pallavi

2 Likes
3

Hello @Mahejabeen_Navidgi You can achieve this using the Build Map rule. Below is an example code snippet, please try it and let me know the results.

import sailpoint.connector.JDBCConnector;
import sailpoint.connector.Connector;
import java.util.HashMap;

HashMap map = JDBCConnector.buildMapFromResultSet(result);

if (schema.getObjectType().compareTo(Connector.TYPE_ACCOUNT) == 0) {
    String statusKey = (String) map.get("STATUSKEY");

    if ("0".equals(statusKey)) {
        map.put("IIQDisabled", false);
    } else {
        map.put("IIQDisabled", true);
    }
} else if (schema.getObjectType().compareTo(Connector.TYPE_GROUP) == 0) {
}
return map;

Thanks,

Raju :expert_ambassador:

6 Likes
4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.