Question Incremental Data Export Logic

[philippoommen1]

Hi ,

Can you please suggest a Logic/Design to Export the data to another software in an incremental manner when a scheduler Runs. Ex:- In Item Master , if 2 records got changed after the last upload then next time only those 2 records to upload .

1.This is a new integration Project
2.We are not allowed to change any existing Schema for this purpose. Only because 3 versions down should support
3.Some of the tables does not have any time stamp

TIA
-Philip-

 

[Cringer]

Version 11.7 has a new feature coming:
OpenEdge Change Data Capture (CDC) is a new tracking mechanism that enables applications to determine the changes made to user tables in a database. The changes that result from INSERT, UPDATE, and DELETE operations in a user table are tracked, captured and stored in relational tables called change tables. By using CDC in OpenEdge you can choose individual fields of a table for which you want to capture the changes and publish the data to an external data source, avoiding replicating the entire database and resulting in better management of the captured data.
If moving to 11.7 when it's available is an option then wait for that as it will solve a lot of hurt.

 

[Fabio]

There's no magic solution to do if you can't change anything on source database.

Can you create at least a trigger on tables that you need to export?

 

[Rob Fitzpatrick]

Export the data to another software in an incremental manner

This is pretty vague so we don't know exactly what you're looking for.

Have a look at OpenEdge Pro2; it might meet your needs.
OpenEdge Pro2 Fast, reliable, efficient data replication