We've just started with ADF and are using the SAP_CDC connector to connect to generic data sources in ODP. This all works but one time the update in Azure failed yet the ODP request was flagged as confirmed. Our only option seemed to be to reinitialise the data source by deleting the subscription in ODQMON and dropping the table in Azure.
In BODS we're able to specify a timestamp to repeat extraction from and there is SAP doco on this (2399296 - How to recover a delta load for ODP Extractor in Data Services).
My questions are:
- Is it possible to repeat a delta request in ADF
- In ODQMON the subscription only appears as the technical/timestamp - there is no descriptive label, and the icon next to the subscription is missing (greyed out).
Will appreciate any answers. Thank you.
Is it possible to repeat a delta request in ADF?
In my view Yes, it brings last delta records (which are not pulled thru last delta info pack) and latest delta records as well - given in MS Q&A 861785 by @KranthiPakala-MSFT.
In ODQMON the subscription only appears as the technical/timestamp - there is no descriptive label, and the icon next to the subscription is missing (greyed out).
As per my analysis on referring to @PremShanker article in this blog it appears as timestamp.
Refer to the MS Doc1 for the SAP CDC connector in Azure Data Factory and Doc2 for frequent debugging issues!