Perform incremental import of users without UPDATE date/timestamp column in DB (SQL DB

[SB]

Question: 

We have a requirement where we need to perform Incremental Import of Users from SQL DB view as trusted source in DB connector, but there is no Update_Dat or Update_Timestamp column present in the view. Is it possible for Saviynt to perform the incremental import based on change tracking of data?

Is the incrementalcolumn" attribute in Saviynt mandatory to be the Last Update Date Column only?

Please suggest the ways to perform incremental import based on detection of change in data of any User attribute by Saviynt.

Response: 

Incremental import works on the last update date field. This date is ideally used in the query defined in the Connection to only fetch the records that were updated post the specified date in your target DB. Without the use of the date filed, it is ideally a full import because your DB query is ideally returning all records in the table.

[rushikeshvartak]

But this date column is hardcoded in code isn’t it

[SB]

@rushikeshvartak The internal date column is used for comparison. It is an identifier for the application to know when the last import job was run and then it compares this date to the lastupdatedate in Target db . Any records that were updated post the last job run date are picked.

Example: Last job run date - 1st Feb 2023 11:00 AM

In this case, saviynt will check for the records that were updated post this time in target DB and only bring those. 

[rushikeshvartak]

Target column name can be any? As in account import its hardcoded

[SB]

Yes, target column name can be any.