We are now part of Eviden, discover more...

After looking at Enterprise Data Glue – OData in the Enterprise World, we now look at a common request of how OData can be used to extract data from an ECC system to another target. In this example, we are going to look at how an extractor is enabled for OData and how delta records can be fetched in an OData feed. This blog does not cover the consumption of the same – the consumption could be handled in a separate middleware or the target system in itself.

Extracting Delta Data from ECC Extractors using OData.

Extracting delta records via OData from SAP

For the purpose of demonstration, let’s see how ODP 0CUSTOMER_ATTR is consumed via OData and delta changes are captured.

Expose ODP as OData using SAP Gateway Service Builder:
Extracting Delta Data from ECC Extractors using OData.

The generated service has 2 entity sets, EntityOf<ODP> and DeltaLinksOfEntityOf<ODP> and URL for accessing the service usually looks like https://<Host>:<Port>/sap/opu/odata/sap/<Service Name>/<EntitySetName>

Extract Delta records using the OData service

Delta extraction can be performed by using the delta enabled entity set DeltaLinksOfEntityOf<ODP> along with the necessary request headersThe delta initialization along with dataset is requested using the entity set EntityOf<ODP>. This is similar to “Init with Data transfer” concept in extraction via info-package in BW. Delta initialization request will provide the initial dataset based on the query parameters along with a deltatoken, which is the key for subsequent delta load at the fag end of the request response.

Here is how the initial request header and response would look like:

Extracting Delta Data from ECC Extractors using OData.

The deltatoken received in the above request response is then used in subsequent delta request to fetch delta records. Sample of delta request header and response:

Extracting Delta Data from ECC Extractors using OData.

“Results” array would contain the actual data as shown below.

Extracting Delta Data from ECC Extractors using OData.

The delta token received at the end of the delta request can further be stored and used to request the next delta data. Please view the video below for a demonstration of how this works:

Read more blogs from Business Intelligence category here.

Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!