updating an attribute based on another SAP IDM

[pbadalinc]

Hi IDM ers

i have a custom text boolean(Presentation) attribute ZMX_CONTRACTOR whose value depends on if MX_FS_WORK_CONTRACT_ID is populated or not.

if populated value = 1 if empty value=0

I use it in the search user form as a checkbox for contractor search.

what would be best way to implement?

i tried below sql for attribute values >sql query . it doesnot update in IDM. the syntax is Oracle specific:

select count(*) from dual where exists (select * from idmv_VALlINK_EXT2 where MCATTRNAME = 'MXFS_WORK_CONTRACT_ID' )

any help would be appreciated

[alexanderbrietz]

Hi Prasad,

I am not sure how to answer your question, because I think it's somehow ambiguous.

First, you need to get your SQL sorted out. It should iterate on the apropriate entrytypes that should get this custom attribute. For these entrytypes you would need the MSKEYVALUE to work with in IDM. Also, the view VALLINK is not ideal for this. You should use a VALUE view instead for a value attribute.

Second, I would populate the custom attribute ZMX_CONTRACTOR using a job with a toIdentityStore-Pass. Source would be the SQL-statement used with SAP IDM DB. As Destination you would have MSKEYVALUE - %MSKEYVALUE%, changetype - modify, ZMX_CONTRACTOR - %<Value from your SQL as result>%.

Regards,

Alex

[pbadalinc]

Thanks a lot Alex. looks like i will have to go the route of creating a job.