Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Entitlement Mapping with CSV for Disconnected Connection

navneetv
Regular Contributor II
Regular Contributor II

Hi Team,

We have a requirement where we are trying to create a disconnected connection. We are able to import the Account and Entitlement via a CSV while configuring the disconnected connection. However, there is no option available for another CSV to map the entitlement with the account.

Please guide or help, how to map the entitlement with account?

2 REPLIES 2

Raghu
Honored Contributor
Honored Contributor

@navneetv  you can mapp account associated  with entitlement

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Uploa...

Raghu_0-1714991450149.png

 

Based on query you get and prepare data and upload.

 

select distinct acc.name as 'ACCOUNT NAME', ep.ENDPOINTNAME as 'ENDPOINT', ev.ENTITLEMENT_VALUE as 'EntitlementTypeName'
from accounts acc, endpoints ep, entitlement_types et, entitlement_values ev, account_entitlements1 ae1
where acc.ENDPOINTKEY = ep.ENDPOINTKEY and ep.ENDPOINTKEY = et.ENDPOINTKEY and ae1.ACCOUNTKEY = acc.ACCOUNTKEY
and ae1.ENTITLEMENT_VALUEKEY = ev.ENTITLEMENT_VALUEKEY and et.ENTITLEMENTTYPEKEY = ev.ENTITLEMENTTYPEKEY
and ep.ENDPOINTNAME = 'XXX';

[This message has been edited by moderator to mask sensitive information from an image]

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

How are you importing accounts & Entitlements ?

  1. Via Sav file ? https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Uploa... 
  2. Manual Process -  https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Uploa... 

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.