Database User Import incremental job

[Community_User]

Originally posted on October 23 2020 at 02:25 UTC

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.

[Community_User]

Originally posted on October 27 2020 at 11:05 UTC

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

[Community_User]

Originally posted on October 27 2020 at 22:21 UTC

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>

[Community_User]

Originally posted on October 28 2020 at 03:02 UTC

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.

[Community_User · Accepted solution]

Originally posted on October 28 2020 at 11:06 UTC

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