Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Subhendu
Explorer
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

2 Comments
Labels in this area