Skip to main content
Question

Any one using cdata to incrementally replicate data from Epicor

  • April 22, 2026
  • 0 replies
  • 8 views

We are working on various solutions to incrementally replication Epicor data.  The challenge is Epicor does not allow cdc and while some tables have fields indicating last change date and another one for time but it is not consistent.  We attempted to create a trigger solution to capturing any time a row changed but this would cause deadlocks and system performance issues.  Epicor also has a trigger option but this will cause significant performance issues on the front end.  Our last resort maybe to replicate the server and set up cdc on the replicated server.  While viable there has to be a better solution than this and I thought maybe someone could help me here.