Use Case / Problem Statement
Some Target System has admin value in account attribute like
"Site Admin": True
We would like to get this info into one of the customproperty and using Saviynt for Saviynt (Sav4Sav) we would like to add membership by accounts import from the database. Do we need to join the entitlement_value / entitlement_type /account_entitlement table like how we are making it work in the analytics report?
or like what was explained in the guide, can we just list all attributes and only from accounts required?
Solutions
Below JSON mapping can be used in connection.
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name" >
<![CDATA[
SELECT DISTINCT
a.name AS name,
a.accountid AS accountid,
'AccessLevel' AS ettypename,
a.accounttype AS entvalue,
'SAP Litmos' AS systemname,
'SAP Litmos' AS endpointname,
from
accounts
where (statuskey like '1' or status like 'Manually Provision') and endpointkey = 27
]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" accountnotinfileaction="suspend" deleteaccountentitlement="true" ifusernotexists="noaction" incrementalcolumn="updatedate" dateformat="timestamp">
<mapfield saviyntproperty="accounts.name" sourceproperty="name" type="character"/>
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="systemname" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointname" type="character"/>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="ettypename" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entitlementvalue" sourceproperty="entvalue" type="character"/>
<mapfield saviyntproperty="accounts.accountid" sourceproperty="accountid" type="character"/>
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
Reference
