Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon
No ratings
SB
Saviynt Employee
Saviynt Employee

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.
Comments
rushikeshvartak
All-Star
All-Star

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

SB
Saviynt Employee
Saviynt Employee

@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
All-Star
All-Star

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

SB
Saviynt Employee
Saviynt Employee

Yes, target column name can be any.

Version history
Last update:
‎02/03/2023 01:34 PM
Updated by:
Saviynt Employee