Hello!
Case is that customer would like to replicate data from OpenEdge to Oracle database. Oracle data is like a master data, where all the data have to remain forever. Using OpenEdge database, customer will remove some old data time to time, but data have to remain in Oracle database always. Can we handle this case with Pro2 so that Pro2 will not delete the data from Oracle database, even it's not exists anymore on OpenEdge database?
Thanks!
Jarmo
Hi Jarmo
PRO2 is written in ABL... so everything should be possible.
So the data created , updated should be propagated to the Oracle Database... but the Delete events should not be applied..
I guess Terry Mays could give a formal answer...
Laurent
Hi Jarmo,
Are you talking about auditing maybe? If that is available in the Oracle database you might consider that. If you're just talking about marking records as deleted you could definitely customize the Pro2 code to do that. Like Laurent says, it's ABL.
You would have to make sure you re-implement your changes in future releases. In the meantime you could log an Enhancement Request (Idea) for a feature that would allow automatically marking records as deleted in the target.
Presently there is an auditing feature in Pro2 which avoids deleting the replication queue record in order to post it again to a second target, but this will still apply the deletion to both targets.
The below article tells you how to log an Idea:
knowledgebase.progress.com/.../P11255
Best Regards,
Ken McIntosh
Hi Jarmo,
I think you're talking about Logical Deletes in Pro2.
From Pro2 User Guide:
Logical Deletes
There are times when auditing is not required however it is desired to maintain records in the target database after they are deleted from the source database. In this case, instead of being deleted, rows are designated as “logical” deletes (via PRROWID modification) and the data is kept in the source database.
Here's an article on how to do it
https://knowledgebase.progress.com/articles/Article/pro2-how-to-configure-logical-deletes
Best regards,
Valeriy
Hi Satya,
[quote user="Satya Prasad"]
2) When LOGICAL_DELETE_TABLES is enabled and a record is deleted from the source table, the corresponding record will remain in the foreign database table but is flagged as deleted via its PRROWID. For example,
Original :
0x0000000000000356
PRROWID after record is deleted from the source table:
D-0x000000000000035620180504-56806