Query SQL Server data based on talend's last run time
Hi!
New to Talend here, we are running an integration between MSSQL data to Salesforce.
In the MSSQL table we have a column called "insert_date". I want to use that date and the last run time of that job in talend to determine which rows to be included for data transfer.
Is this possible? (I know it is, but just don't know how!!)
Store the last_run date somewhere (in your db or in a file) then at next run, get this date knto a global variable and reuse it to build the appropriate where clause for your select (which can be constructed dynamically by strings concatenation). You just have to deal with date format conversion.
Store the last_run date somewhere (in your db or in a file) then at next run, get this date knto a global variable and reuse it to build the appropriate where clause for your select (which can be constructed dynamically by strings concatenation). You just have to deal with date format conversion.
