Hi Team,
We have a requirement to use two columns together as the reconciliation field while importing Users to Saviynt from MS SQL DB view. The unique field is a composite key at the DB side, could you please confirm on how to achieve the same.
Here is the code we are using:
<dataMapping>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="userid">
<![CDATA[
SELECT firstname,lastname,workemailaddr,person_type, appname,personnumber
FROM mytable
]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<userNotInFileAction>NOACTION</userNotInFileAction>
<generateEmail>true</generateEmail>
<checkRules>TRUE</checkRules>
<generateSystemUsername>TRUE</generateSystemUsername>
<userReconcillationField>customproperty2</userReconcillationField>
</importsettings>
<mapper description="This is the mapping field for Saviynt Field name" dateformat="timestamp" incrementalcolumn="lastupdateddt">
<mapfield saviyntproperty="firstname" sourceproperty="firstname" type="character"></mapfield>
<mapfield saviyntproperty="lastname" sourceproperty="lastname" type="character"></mapfield>
<mapfield saviyntproperty="email" sourceproperty="workemailaddr" type="character"></mapfield>
<mapfield saviyntproperty="employeeType" sourceproperty="person_type" type="character"></mapfield>
<mapfield saviyntproperty="customproperty1" sourceproperty="appname" type="character"></mapfield>
<mapfield saviyntproperty="customproperty2" sourceproperty="personnumber" type="character"></mapfield>
</mapper>
</dataMapping>
The requirement is that we need to use the "employeeType" and the "customproperty2" together as the reconciliation field.