Pushdown to ECC while using Extractors

[former_member707621]

Hi All,

I am using ECC ODP Objects (extractors) to pull the data from ECC in BODS job. For performance optimization can I use pushdown when extracting data using ECC extractors?

[werner_daehn]

Yes, the ODP supports pushdown, in regular data flows and ABAP dataflows. The main difference is that in ABAP dataflows you can do post processing of the data while still on the ABAP side.

But keep in mind, ODP is not SQL like. It depends on what condition types, fields and combinations the API supports and the ODP "table" has activated. Most basic should work. You can proof that by looking at the "display optimized SQL" under the debug menu.

(I hope I did not confuse that and it was implemented in Hana SDI ABAP Adapter only, but not in the BODS engine)

[Private_Member_467521]

Hi venkata.praveen,

You can use pushdown in an ABAP data flow, where Data Services generates the ABAP that calls ODP API.

Here is the reference of SAP Help

https://help.sap.com/viewer/df959412681b4619a38f03ff90207e6b/4.2.12/en-US/5776d3f76d6d1014b3fc9283b0...

And this is the Real-Time Data Warehousing with SAP NetWeaver Business Warehouse

https://blogs.saphana.com/wp-content/uploads/2013/11/RDP300.pdf

Hope it sheds a light to your topic.

Cheers,

Luis 🙂