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:

Here is the relevant part:

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,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 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:



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


    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2018 at 12:43 PM

    Hello Marc / Jan,

    My understanding is that Jan is trying to use this:

    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 ?



    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13 at 11:49 AM


    I am facing the same issue trying to configure a Push real time mechanism.

    My datasource shows the 'Streaming can be triggered' option. I configured the process chain trigger as 'External start only', if I check transaction ODQMON in the source system, I can see the changes within the used dadatsource So I would expect the process chain to trigger, this does not happen.

    Did any of you get to know how to achieve the Push mechanism?


    Juan Manuel

    Add comment
    10|10000 characters needed characters exceeded