Technical Articles
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
(‘<PropertyGroup name=”__DP_TABLE_OPTIONS__”>
<PropertyGroup name=”T”>
<PropertyEntry name=”extractionmode”>D</PropertyEntry>
<PropertyEntry name=”extractionname”>ADRC</PropertyEntry>
</PropertyGroup>
</PropertyGroup>’);
SQL Query
Here extractionmode can be D (Delta) or F (Full).
Once we execute the query above it will create a subscription in ODQMON.
ODQMON subscription
Thank you, I am trying to extract data into HANA with Delta extraction mode, but I don't want to process data source data into the target. How do I configure that? with the above setting of delta extraction mode, I get delta pointer set and all the existing data in the source is loaded to target which I don't want to do that.(I have 200 million records).