HANA SQL for Delta/Full subscription creation in Operational Delta Queue (ODQ)
source link: https://blogs.sap.com/2022/11/01/hana-sql-for-delta-full-subscription-creation-in-operational-delta-queue-odq/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK