topic Re: Query SQL Server data based on talend's last run time in Talend Studio

Query SQL Server data based on talend's last run time

Anonymous — Sat, 16 Nov 2024 04:11:35 GMT

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!!)

Thank you!!

Re: Query SQL Server data based on talend's last run time

TRF — Fri, 01 Nov 2019 20:16:05 GMT

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.

Re: Query SQL Server data based on talend's last run time

Anonymous — Fri, 01 Nov 2019 20:33:21 GMT

Thank you for the prompt reply!

Is it possible to show me a screenshot of the above suggestion? I'm new to Talend and don't know how to structure that

Thank you!!