Skip to Content
Technical Articles
Author's profile photo Subhendu Ghanty

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%20Query

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%20snapshot

ODQMON subscription

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sreekanth Surampally
      Sreekanth Surampally

      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).