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

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

      Author's profile photo Subhendu Ghanty
      Subhendu Ghanty
      Blog Post Author

      Hi Sreekanth, in the above SQL statement SQL query you can append another where clause ( select count(*) from “ZEXI_S4H_ADRC” T where 1=0 ) and it will suffice your need.