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

[Jan_van_Ansem]

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/1f36dde4acd747139654f3f0dec5...

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.

[former_member442641]

Hello Juan,

were you able to successfully create a streaming process chain as am facing the same issue as you have described.

if you were able to achieve the expected result, pls share the steps (not sure what am i missing)

Thanks,

Hari

[former_member252788]

Hi,

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?

Thanks,

Juan Manuel

[miguel_peredozurcher]

Hello Marc / Jan,

My understanding is that Jan is trying to use this:

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

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

[Jan_van_Ansem]

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.

[former_member93896]

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/4ed3819b17aa41a5850031feb7b...

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

Best,

Marc

Product Management SAP HANA DW