APPARATUS AND METHOD FOR GUARANTEEING EXACTLY ONCE DELIVERY OF CHANGE DATA EVENTS TO A DOCUMENT-ORIENTED DATABASE ON RECOVERY

A non-transitory computer readable storage medium has instructions executed by a processor to receive change data events from a data source. Ordered positions of the change data events are maintained using a system checkpoint. The change data events are written to a document-oriented data store including a change data event collection and a change data event target checkpoint collection. There is an identification when an ordered position of change data events at the system checkpoint is lower than an ordered position of change data events in the change data event target checkpoint collection. Data source records following a position of change data events at the system checkpoint are collected. Records up to the position of change data events in the change data event target checkpoint collection are discarded and de-duplicated for exactly once delivery.