How to import multiple entitlement type using DB Connection

[MJ]

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>

[rushikeshvartak · Accepted solution]

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>

[MJ]

Great, it worked.