idea Re: Provide an API call which will give record commit timestamp at source & target end. in Suggest an Idea

Provide an API call which will give record commit timestamp at source & target end.

CAH123 — Wed, 04 Nov 2020 08:32:52 GMT

HI Team,

We are facing data mismatch issue in our replication tasks. We want to make sure correct data is replicating from source to target and that's why we are focusing on commit timestamp for record at source & target end.

If we get this information from API call then we will use such API call in our python script and use it to match records in source and target without going into database.

Thank you

CAH

Re: Provide an API call which will give record commit timestamp at source & target end.

bobvecchione — Mon, 16 Nov 2020 14:30:06 GMT

Currently reviewing.

Re: Provide an API call which will give record commit timestamp at source & target end. - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Mon, 25 Jan 2021 14:10:38 GMT

Could you share the type of source systems? We are planning on adding a header column for the commit timestamp in the source database system - would this satisfy your need if it was available?

Re: Provide an API call which will give record commit timestamp at source & target end.

Shelley_Brennan — Wed, 12 May 2021 13:19:43 GMT

Could you share the type of source systems? We are planning on adding a header column for the commit timestamp in the source database system - would this satisfy your need if it was available?

Re: Provide an API call which will give record commit timestamp at source & target end.

cah_admin — Mon, 23 Aug 2021 16:23:19 GMT

Hi Shelly,

Is this Head column for the source system only?

What about in Target system , We want to know when last change has been applied in Target system as well.

We are currently using below Source systems:

SAP HANA

ORACLE

SQL SERVER

DB2 LUW

DB2 iSeries

MY SQL

Please let me know if you have any questions.

Regards,

Venkata

Re: Provide an API call which will give record commit timestamp at source & target end.

Shelley_Brennan — Tue, 21 Sep 2021 17:52:41 GMT

Thank you for the additional details here. We will let you know when we have any updates to share for the sources you listed.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:55:43 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Provide an API call which will give record commit timestamp at source & target end. - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:55:45 GMT