Skip to Content

HANA SDI ABAP Adapter - Real Time Using ODP from ECC

Hello,

We have a HANA system which we're using as a Data Warehouse. We have configured the ABAP Agent as we wish to pull data in real time using BW extractors from our source ECC system using the ODP framework.

We have been successful in initializing the load, but what we've noticed is that there is a 20 minute lag from the time a change happens in the extractor, to when it gets picked up and loaded into HANA.

Since we want the extractor load via ODP to be real time, I was wondering if there was a setting somewhere that defines the pull frequency into HANA, or if I possibly missed something when configuring the agent or specific extractor pull.

Appreciate your support.

Marcelo

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 10, 2018 at 06:49 AM

    Hi,

    Let me understand: from one side you have HANA.

    Is HANA as database and WH, or HANA is a database only and there is BW over that HANA?

    BR,

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Andrey,

      Our landscape is ECC on MSSQL -> HANA DB

      We don't have BW, we're using HANA as a DW, so using calculation views to create models to be exposed for reporting on the frontend (BOBJ).

      Thanks,

      Marcelo

  • Jun 10, 2018 at 11:04 PM

    There are LO extractors and other extractors whose delta update intervals have to be configured to populate the queue. It is NOT correct to assume that delta records always can be instantly ready to be consumed at the moment the transaction occurs. Please look into the configurations of your extractors or data sources.

    Add comment
    10|10000 characters needed characters exceeded

    • Apologies for not replying earlier. I will look into your suggestions here and see what I find. Unfortunately we've faced other roadblocks so we're switching entirely to SLT, so we might not face these issues there. I will keep you posted.

      I appreciate you taking the time to provide valuable input.

      Thanks,

      Marcelo