Skip to Content

BW/4HANA real-time ADSO from HANA table as a source - using 'Push'

Hello BW/4HANA experts,

I have a HANA table which I want to replicate and persist in BW/4HANA, with some transformations applied to it on the way in.

There is a requirement to do this in 'real-time' - or as much real-time as possible. Due to the nature of the data, the changes should be 'pushed' to BW from HANA, rather than 'Pulled'.
According to the help, this is a supported scenario:

https://help.sap.com/viewer/dd104a87ab9249968e6279e61378ff66/11.0/en-US/1f36dde4acd747139654f3f0dec5387e.html

Here is the relevant part:
Streaming

A data transfer process, which extracts deltas from a table or view of the local SAP HANA schema, can trigger a streaming process chain, provided that specific prerequisites are met for the delta-relevant field. These prerequisites are listed in SAP Note 2372534

I checked the SAP note and found all requirements are met.

Despite this, the datasource says that streaming cannot be triggered from the datasource.

When I schedule a process chain (streaming mode) with start with option 'External Start only' it does not pick up any changes.
The process chain works when I set it to 'immediate start' - it goes in listening mode and changes do come through every minute.

However, that is still a 'pull' rather than a 'Push'... what do I need to do to get the process chain started by the DTP / a data change event in the HANA table?

Thanks in advance for your help,

Jan.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 15, 2017 at 02:57 PM

    Hello Jan,

    I think what you want is described in the following section about real-time replication in the documentation:

    https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.6/en-US/4ed3819b17aa41a5850031feb7bb40bf.html

    https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.6/en-US/2c6673f9b1b94800a7e22410577d56df.html

    Best,

    Marc

    Product Management SAP HANA DW

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 11:21 PM

    Hi Marc,

    Many thanks for this. I got a bit further, using a different datasource (from the Twitter Adapter).

    In the definition of this Twitter datasource it does show that 'Streaming can be triggered':

    I also have the options to create remote subscriptions - as per the help links you mentioned above.

    - When I run a process chain in normal 'batch' mode it works fine.
    - When I put the process chain in streaming mode, and schedule it manually, it works fine.
    - When I try to get HANA to trigger the process chain.... nothing happens.

    Perhaps I don't understand correctly what it means that 'Streaming can be triggered'.
    My expectation is that when I schedule the process chain, with start event set to 'External start only', it will run as soon as there is a data change in the source. That is not happening.....


    So am I doing something wrong or is my understanding of what is supposed to happen incorrect?

    I would love to see a true 'push' mechanism at work....

    Jan.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25 at 12:43 PM

    Hello Marc / Jan,

    My understanding is that Jan is trying to use this:

    https://help.sap.com/viewer/2e90b26cf7484203a523bf0f4b1bc137/7.5.6/en-US/ac029de05e164a12ac1ce08d16180f05.html

    And from there this option:

    Push-based (with API)DTP on a (real-time ) ODP DataSource

    (message from ODQ daemon event)

    Also in my datasource it reads:

    "streaming cannot be triggered from the datasource"

    Does anybody know a link or note that explain when this: "Push-based (with API)" is available ?

    Thanks,

    Miguel

    Add comment
    10|10000 characters needed characters exceeded