JDBC BuildMap not reflected in account aggregation

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

Hi,

I am writing a JDBC buildmap rule for remap all entitlements from a single table into seperate column.

Below is my code snippet

import sailpoint.connector.*;
import java.util.*;

    public boolean isNullOrEmpty(String str) {
        return str == null || str.isEmpty() || str.isBlank();
    }

        String ATTR_E_TYPE = "entitlement_type";
        String ATTR_E_NAME = "entitlement_name";

        String KEY_SECURITY_GROUP ...............

        Map map = JDBCConnector.buildMapFromResultSet(result, schema);
        String ent_type = (String) map.get(ATTR_E_TYPE);
        String ent_value = (String) map.get(ATTR_E_NAME);

        if(!isNullOrEmpty(ent_type) && !isNullOrEmpty(ent_value)){
		log.debug("[JDBCBuildMap - JDBC] for " + ent_type + " with value : " + ent_value);
            if(KEY_SECURITY_GROUP.equalsIgnoreCase(ent_type)){
				log.debug("[JDBCBuildMap - JDBC] - for " + KEY_SECURITY_GROUP + " with returned value : " + ent_type + ent_value);
                map.put(KEY_SECURITY_GROUP, ent_value);
            } else if (KEY_...............)


            map.remove(ent_type);
            map.remove(ent_value);
        }
        return map;

But based on ccg.log, I could not see whatever been set in BuildMap did not reflected in returnSet. (map)

2

Hi Joshua,
Are you executing the entitlement aggregation and changing the values in there ?

Thanks
Rakesh Bhati