Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
04/12/2022 01:03 PM
Even if I use the "Users Import (Incremental) from Database (UserImportIncrementalJob)" job with the incremental column specified with 'dateformat' set to timestamp I do not get the incremental run. When ever I run the job I get all the users present in the database reconciled into Saviynt.
Do I need to specify additional configurations to enable the incremental reconciliation for database.
PS: I am using this as a trusted source reconciliation.
Thank you.
Solved! Go to Solution.
04/12/2022 02:16 PM
Hi Nilesh,
No Additional Configuration is required for incremental reconciliation through DB Connector. Could you please use any 'datetime' field as 'incrementalcolumn' in the mapper and also map that field against saviynt property and try to recon.
If the issue still persist, please share the xml you are using with logs.
Thanks,
Ranjan
04/12/2022 02:16 PM
Hi Ranjan,
Thanks for your response. Below is the XML which I have configured.
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[SELECT * FROM HR_DATA ]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" defaultrole="ROLE_ENDUSER" dateformat="timestamp" incrementalcolumn="LAST_UPDATED">
<mapfield saviyntproperty="USERNAME" sourceproperty="UID" type="character"></mapfield>
<mapfield saviyntproperty="EMPLOYEEID" sourceproperty="EMPLOYEEID" type="character"></mapfield>
<mapfield saviyntproperty="FIRSTNAME" sourceproperty="FIRST_NAME" type="character"></mapfield>
<mapfield saviyntproperty="MIDDLENAME" sourceproperty="MIDDLE_NAME" type="character"></mapfield>
<mapfield saviyntproperty="LASTNAME" sourceproperty="LAST_NAME" type="character"></mapfield>
<mapfield saviyntproperty="STARTDATE" sourceproperty="HIRE_DATE" type="date"></mapfield>
<mapfield saviyntproperty="ENDDATE" sourceproperty="TERMINATION_DATE" type="date"></mapfield>
<mapfield saviyntproperty="TERMDATE" sourceproperty="TERMINATION_DATE" type="date"></mapfield>
<mapfield saviyntproperty="COMPANYNAME" sourceproperty="COMPANY" type="character"></mapfield>
<mapfield saviyntproperty="DEPARTMENTNAME" sourceproperty="DEPTNAME" type="character"></mapfield>
<mapfield saviyntproperty="DEPARTMENTNUMBER" sourceproperty="DEPTID" type="character"></mapfield>
<mapfield saviyntproperty="EMAIL" sourceproperty="EMAIL" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
04/12/2022 02:16 PM
Please refer the mapping XML configuration pasted below. As can be seen I have mapped the LAST_UPDATED column in the DB to CUSTOMPROPERTY65. However I do not understand how the criteria is devised from this information.
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[SELECT * FROM HR_DATA ]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" defaultrole="ROLE_ENDUSER" dateformat="timestamp" incrementalcolumn="LAST_UPDATED">
<mapfield saviyntproperty="USERNAME" sourceproperty="UID" type="character"></mapfield>
<mapfield saviyntproperty="EMPLOYEEID" sourceproperty="EMPLOYEEID" type="character"></mapfield>
<mapfield saviyntproperty="FIRSTNAME" sourceproperty="FIRST_NAME" type="character"></mapfield>
<mapfield saviyntproperty="MIDDLENAME" sourceproperty="MIDDLE_NAME" type="character"></mapfield>
<mapfield saviyntproperty="LASTNAME" sourceproperty="LAST_NAME" type="character"></mapfield>
<mapfield saviyntproperty="STARTDATE" sourceproperty="HIRE_DATE" type="date"></mapfield>
<mapfield saviyntproperty="ENDDATE" sourceproperty="TERMINATION_DATE" type="date"></mapfield>
<mapfield saviyntproperty="TERMDATE" sourceproperty="TERMINATION_DATE" type="date"></mapfield>
<mapfield saviyntproperty="COMPANYNAME" sourceproperty="COMPANY" type="character"></mapfield>
<mapfield saviyntproperty="DEPARTMENTNAME" sourceproperty="DEPTNAME" type="character"></mapfield>
<mapfield saviyntproperty="DEPARTMENTNUMBER" sourceproperty="DEPTID" type="character"></mapfield>
<mapfield saviyntproperty="EMAIL" sourceproperty="EMAIL" type="character"></mapfield>
<mapfield saviyntproperty="CUSTOMPROPERTY65" sourceproperty="LAST_UPDATED" type="timestamp">
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
Thank you.
04/12/2022 02:16 PM
Hi Nilesh,
Could you please try with the below xml and revert with logs if it does not work :
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[SELECT * FROM HR_DATA ]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" defaultrole="ROLE_ENDUSER" dateformat="timestamp" incrementalcolumn="LAST_UPDATED">
<mapfield saviyntproperty="USERNAME" sourceproperty="UID" type="character"></mapfield>
<mapfield saviyntproperty="EMPLOYEEID" sourceproperty="EMPLOYEEID" type="character"></mapfield>
<mapfield saviyntproperty="FIRSTNAME" sourceproperty="FIRST_NAME" type="character"></mapfield>
<mapfield saviyntproperty="MIDDLENAME" sourceproperty="MIDDLE_NAME" type="character"></mapfield>
<mapfield saviyntproperty="LASTNAME" sourceproperty="LAST_NAME" type="character"></mapfield>
<mapfield saviyntproperty="STARTDATE" sourceproperty="HIRE_DATE" type="date"></mapfield>
<mapfield saviyntproperty="ENDDATE" sourceproperty="TERMINATION_DATE" type="date"></mapfield>
<mapfield saviyntproperty="TERMDATE" sourceproperty="TERMINATION_DATE" type="date"></mapfield>
<mapfield saviyntproperty="COMPANYNAME" sourceproperty="COMPANY" type="character"></mapfield>
<mapfield saviyntproperty="DEPARTMENTNAME" sourceproperty="DEPTNAME" type="character"></mapfield>
<mapfield saviyntproperty="DEPARTMENTNUMBER" sourceproperty="DEPTID" type="character"></mapfield>
<mapfield saviyntproperty="EMAIL" sourceproperty="EMAIL" type="character"></mapfield>
<mapfield saviyntproperty="CUSTOMPROPERTY65" sourceproperty="LAST_UPDATED" type="date">
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
Thanks,
Ranjan