[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Limitations of using Pro2 with CDC

[Valeriy Bashkatov]

Thank you for your reply! >>Pro2 Replication is currently designed to only capture the fact that records have changed. Ok. But in the documentation for Pro2 there is such thing as Audit Database. This means, if I understand correctly, it is possible to track each change and maintain an audit trail in the target database. Unfortunately, there is not much written about this in the documentation. As far as I understand, tmpl_mreplproc_restart_4audit.p and tplt_repltrig-raw.p templates are used for these purposes, which means that it is possible when using replication triggers. However, my customer wants to use the OpenEdge CDC instead of replicating triggers as a mechanism for capturing changes. Because the documentation says:

CDC Replication Process The CDC replication process is almost two times faster than using ABL triggers and can be managed online. This results in relatively low database downtime. The client application connection remains unchanged and there is no need to connect to the Repl database.

Continue reading...