Ability to pass filter parameters in the SAP Extractor for OData connection

Related products: Extractors

I finally got the SAP Extractor working to extract data from S/4HANA using the OData APIs. The extractor is easy to configure as you can simply provide the Service Root and Resource URI in the config file. The program maps the extracted data with the OData schema to create the Raw table. It even supports the incremental extracts. 

However, I found that we cannot provide the filter parameters in the config file, and it is a huge barrier to adoption. In most cases. we want to limit the data for a set of Maintenance Plants. So, it would be great enhancement for the SAP Extractors to provide the ability to specify filter parameters while using the OData connectivity. 

 

 

 

Thank you for sharing one more your insightful reflection, Dinesh! 

We greatly appreciate your contribution and stay tuned for updates on how we plan to proceed.


Hi @dinesh.makked thanks for your feedback. 

I am a bit puzzle by your feature request, given that the option to filter is already part of the extractor. It is referred in the documentation under the Endpoints as: 

I wonder if there is anything else you are referring to? If yes, it would be very beneficial to get more details. 

Thanks and Regards

Elka

filter

Enter the filter query string. The $filter system query option allows clients to filter a collection of resources from the target SAP OData endpoint. This is an optional parameter.


Hi @Elka Sierra,

Thanks for your reply! 

You are right about the $filter parameter. If I recall correctly, this option wasn’t available when I originally submitted the feature request. I am glad that we do have the capability to specify the filter parameters now. 

Having said the above, I would like to retract my feature request. 

I appreciate your help with this matter.

 

Regards,

Dinesh

 


Hi @dinesh.makked , very happy to hear we are already covering the request in the product. 

Please do not hesitate to reached out if you have any other request. 

Thanks and regads

Elka