We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

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.