Skip to Content
avatar image
Former Member

ODP datasource on HANA View

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.

Questions:

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?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Hello,

    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).

    Thanks

    Anup

    Add comment
    10|10000 characters needed characters exceeded