Reltio Connect

I have RIH recipes that import SQL Server records by passing a last updated parameter.  To be sure I don't miss any records, I would like to pass a date that is the most recent created or updated date for the particular SQL Server source in the Reltio tenant. How can I get that date and pass it to the RIH task Run Custom SQL in SQL Server?

------------------------------
Susan Ribe
CleanChoice Energy
------------------------------

Hi Susan,

If i understand correctly, you want to get the date time of last successful job.

To achieve this you can create a lookup table in RIH and whenever the job starts have a variable with current time. If the job is successful have the date time updated to lookup table and next time retrieve the same date time from lookup and for some reason if the job fails do not update in lookup table. So that the date time in lookup table reflects last successful job run date time.

Update us if the requirement is different.

I forgot to mention that RIH in fact has the field now

Which you can make use of

------------------------------
Sheshadri V
Fresh Gravity

Original Message:
Sent: 06-16-2023 11:02
From: Susan Ribe
Subject: Find most recent update date by source in RIH

I have RIH recipes that import SQL Server records by passing a last updated parameter.  To be sure I don't miss any records, I would like to pass a date that is the most recent created or updated date for the particular SQL Server source in the Reltio tenant. How can I get that date and pass it to the RIH task Run Custom SQL in SQL Server?

------------------------------
Susan Ribe
CleanChoice Energy
------------------------------

Yes this is what I want to do. How to create a lookup table, and keep it updated with last successful job run?

Hi Susan,

If i understand correctly, you want to get the date time of last successful job.

To achieve this you can create a lookup table in RIH and whenever the job starts have a variable with current time. If the job is successful have the date time updated to lookup table and next time retrieve the same date time from lookup and for some reason if the job fails do not update in lookup table. So that the date time in lookup table reflects last successful job run date time.

Update us if the requirement is different.

I forgot to mention that RIH in fact has the field now

Which you can make use of

------------------------------
Sheshadri V
Fresh Gravity

Original Message:
Sent: 06-16-2023 11:02
From: Susan Ribe
Subject: Find most recent update date by source in RIH

I have RIH recipes that import SQL Server records by passing a last updated parameter.  To be sure I don't miss any records, I would like to pass a date that is the most recent created or updated date for the particular SQL Server source in the Reltio tenant. How can I get that date and pass it to the RIH task Run Custom SQL in SQL Server?

------------------------------
Susan Ribe
CleanChoice Energy
------------------------------

Hi Susan,

If i understand correctly, you want to get the date time of last successful job.

To achieve this you can create a lookup table in RIH and whenever the job starts have a variable with current time. If the job is successful have the date time updated to lookup table and next time retrieve the same date time from lookup and for some reason if the job fails do not update in lookup table. So that the date time in lookup table reflects last successful job run date time.

Update us if the requirement is different.

I forgot to mention that RIH in fact has the field now

Which you can make use of

------------------------------
Sheshadri V
Fresh Gravity

Original Message:
Sent: 06-16-2023 11:02
From: Susan Ribe
Subject: Find most recent update date by source in RIH

I have RIH recipes that import SQL Server records by passing a last updated parameter.  To be sure I don't miss any records, I would like to pass a date that is the most recent created or updated date for the particular SQL Server source in the Reltio tenant. How can I get that date and pass it to the RIH task Run Custom SQL in SQL Server?

------------------------------
Susan Ribe
CleanChoice Energy
------------------------------

Sheshadri, where can I find the 'New recurring event' as in the screenshot above? Thanks.

Hi Susan,

If i understand correctly, you want to get the date time of last successful job.

To achieve this you can create a lookup table in RIH and whenever the job starts have a variable with current time. If the job is successful have the date time updated to lookup table and next time retrieve the same date time from lookup and for some reason if the job fails do not update in lookup table. So that the date time in lookup table reflects last successful job run date time.

Update us if the requirement is different.

I forgot to mention that RIH in fact has the field now

Which you can make use of

------------------------------
Sheshadri V
Fresh Gravity

Original Message:
Sent: 06-16-2023 11:02
From: Susan Ribe
Subject: Find most recent update date by source in RIH

I have RIH recipes that import SQL Server records by passing a last updated parameter.  To be sure I don't miss any records, I would like to pass a date that is the most recent created or updated date for the particular SQL Server source in the Reltio tenant. How can I get that date and pass it to the RIH task Run Custom SQL in SQL Server?

------------------------------
Susan Ribe
CleanChoice Energy
------------------------------