Extracting SAP data using the CDC connector

JLouw,

regarding the error you're getting in RODPS_REPL_TEST, there are two ways to resolve this:

1) with the same source object selections, click the "Reset Delta" button - this will reset the CDC process and allow you to start from scratch

OR

2) select "Recovery of Previous Delta" and fill the delta pointer (the timestamp you got in the error message) into the "Read Open Pointer" field. Then execute.

Another important point: in RODPS_REPL_TEST,  the first run with replication mode "Extraction of Last Delta" will do a delta initialization AND by default give you an initial snapshot (in ADF "Full on the first run, then incremental" behaves the same way). [To skip the initial snapshot, select "Without Data Transfer" in the Output section of RODPS_REPL_TEST.]
If you do a full load, followed by a delta extraction, ODP would either

- give you another full snapshot with delta extraction (unless you choose NOT to read the inital snapshot), or

- you might miss some delta records: changes that fall into the timeframe between the full load and the delta initialization are most likely lost.

One more thing regarding SAP BW/4HANA: please check if SAP note "3076927 - No Call destination BACK" is relevant for your system.

Hope that helps,

Ulrich