Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Use multiple columns as Reconciliation Field while importing Users from DB

sdey_2023
Regular Contributor
Regular Contributor

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.
2 REPLIES 2

rushikeshvartak
All-Star
All-Star

You can do concat and try.

Currently only single attribute is supported in userReconcillationField


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

dgandhi
All-Star
All-Star

I dont think this would be possible but if you find any workaround or solution then please update this thread for benefit of everyone.

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.