HANA SQL for Delta/Full subscription creation in Operational Delta Queue (ODQ)
Recently I have been working on a POC in HANA Cloud & S/4HANA for one of the product client, I got an opportunity to explore this new feature of SDI flowgraph and I like to share few interesting information on the same.
The conventional way to create a subscription is navigating to the Data Source of a SAP HANA SDI Flowgraph and then clicking on Custom Parameter option then providing the Extraction name.
Now as an alternate approach of the above step we can write a HANA SQL statement for that like below
select count(*) from “ZEXI_S4H_ADRC” T
with dataprovisioning parameters
Here extractionmode can be D (Delta) or F (Full).
Once we execute the query above it will create a subscription in ODQMON.