Example DB connector configuration for data reconciliation only

[Community_User]

Originally posted on February 20 2020 at 16:52 UTC

Any Example DB connector configuration please - just for reconciling data i.e. importing accounts and entitlements from the target application.

I'm going through the documentation but it's always helpful to have a 'Hello World' kind of examples 🙂

Example SQL queries and the mapping with required Saviynt fields will be very much appreciated. I want to see how it works for accounts with multiple entitlements.

Data import sequence:

1. Entitlements import

2. Account import - includes accounts mapping with Entitlements.

Note - We are not making any changes in the target system from Saviynt, so the properties such as GRANTACCESS can be excluded

[Community_User · Accepted solution]

Originally posted on February 21 2020 at 11:37 UTC

You can refer below mappings. If you face any issue let us know

For Entitlement Import

<dataMapping>

<before-import>

</before-import>

<sql-query description="This is the Source DB Query">

<![CDATA[

SELECT ent_name, ent_value, ent_glossary, ent_description, ent_status, 'HR App Security System' as securitysystemname, 'HR App Endpoint' as endpoint FROM entitlement_tbl

]]>

</sql-query>

<mapper description="This is the mapping field for Saviynt Field name" deleteentitlementowner="true">

<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="securitysystemname" type="character"></mapfield>

<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"></mapfield>

<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="ent_name" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="ent_value" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.entitlement_glossary" sourceproperty="ent_glossary" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.description" sourceproperty="ent_description" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="ent_status" type="number"></mapfield>

<mapfield saviyntproperty="entitlementvalues.entitlementid" sourceproperty="ent_value" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.displayname" sourceproperty="ent_value" type="character"></mapfield>

</mapper>

<after-import description="EMAIL,BATCH,SQL">

</after-import>

</dataMapping>

For Account and associated Entitlements

<dataMapping>

<before-import>

</before-import>

<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name" >

<![CDATA[

SELECT usertbl.UserID as accountname, roletabl.ROLENAME as entitlementvalue, 'Role' as entitlementtype, 'DB App Security System' as securitysystem, 'DB App Endpoint' as endpoint, '1' as status

FROM Users usertbl, UserRole roletabl

WHERE usertbl.UserID = roletabl.ROLEUSER

]]>

</sql-query>

<mapper description="This is the mapping field for SAviynt Field name" ifusernotexists="noaction" CHECKRULES="true">

<mapfield saviyntproperty="accounts.name" sourceproperty="accountname" type="character"/>

<mapfield saviyntproperty="accounts.accountid" sourceproperty="accountname" type="character"/>

<mapfield saviyntproperty="accounts.status" sourceproperty="status" type="character"/>

<mapfield saviyntproperty="users.username" sourceproperty="accountname" type="character"/>

<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="securitysystem" type="character"/>

<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"/>

<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entitlementtype" type="character"/>

<mapfield saviyntproperty="entitlementvalues.entitlementvalue" sourceproperty="entitlementvalue" type="character"/>

</mapper>

<after-import description="EMAIL,BATCH,SQL">

</after-import>

</dataMapping