Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

How to import multiple entitlement type using DB Connection

MJ
New Contributor III
New Contributor III

I am trying to import multiple entitlement types using DB connection.

only 1 entitlement type can be imported by using the below XML in ENTITLEMENTVALUEIMPORT.

i tried to add the new entitlementtypes.entitlementname line in XML, but it did not work.

how can I import to multiple ents from DB?

"'iAccounting DB'">
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="securitysystem" type="character"></mapfield>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"></mapfield>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="AREACODE" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="Menu" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entowner1" sourceproperty="dataowner1" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entitlement_glossary" sourceproperty="Menu" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.description" sourceproperty="Menu" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="number"></mapfield>
<mapfield saviyntproperty="entitlementvalues.customproperty1" sourceproperty="Menu" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.customproperty2" sourceproperty="BUKRS" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL"></after-import>

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

Entitlement Type should from target if not you can use union function like

select applicationname,endpointname,'Privilege' as entitlementtype,entitlementvalue,status from db_import_prv

union

select applicationname,endpointname,'Role' as entitlementtype,entitlementvalue,status from db_import_role

 

Link to Documentation : https://saviynt.freshdesk.com/support/solutions/articles/43000617705-database-connector-guide 

<dataMapping>
<sql-query description="This is the Source Database Query">
<![CDATA[select applicationname,endpointname,entitlementtype,entitlementvalue,status from db_import_ent]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" deleteentitlementowner="true" entnotpresentaction="noaction" createentitlementtype="true">
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="applicationname" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointname" type="character"/>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entitlementtype" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="entitlementvalue" type="character"/>
<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="number"/>
</mapper>
</dataMapping>


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

MJ
New Contributor III
New Contributor III

Great, it worked.