Skip to Content

ODP datasource on HANA View

Dec 07, 2016 at 01:46 PM


avatar image
Former Member

Hi experts

We need to connect BW on HANA datasources (views, ADSO, etc.) via SAP BODS to an non-SAP Datawarehouse (MS SQL). Using ODP on an HANA view or ADSO should create a delta queue ODQ. This delta queue should be used by BODS to extract the deltas for the target system.


1. I didn't find any information for ODP datasources on HANA views or ADSOs (except note 2195306 ). How does ODP manage the delta logic on HANA views? Any experiences to share?

2. ODQ table for BODS. Any experiences if ODQ tables can be connected to BODS?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 13, 2017 at 05:17 PM


If not solved already, below points should help you.

  1. Not all ODP providers are delta enabled (as far as I know, only CDS views, BW datasources can handle delta). Calculation views are definitely not.
  2. In BW, there is one ODP context called ODP BW which is exclusively meant for export data sources of BW. Please check if BODS can extract from this BW context.
  3. If above doesn't work, you might want to consider SLT (provided your database is supported as target system for SLT).



10 |10000 characters needed characters left characters exceeded