Showing results for 
Search instead for 
Did you mean: 

How to extract data from B4HANA to other databases for staging ?

0 Kudos


We have a requirement to extract BW4HANA data to other databases such as oracle, Postgres, Aurora etc for downstream consumption. The reason for this to blend with other data and then eventually it in the reporting tool.

I am exploring what are the options available ( SAP Data Intelligence, APIs etc., and how others are doing it.

Thank you !

View Entire Topic
0 Kudos

Hello Rajavelu,

You can use the open hub destination to extract data to non-SAP systems. Various APIs allow you to connect a third-party tool to the SAP BW∕4HANA system and to distribute the data to other non-SAP systems.

Please find more information here.

Open Hub Destination

The other option would be ODP based data extraction via OData.

Hope this helps.

Thanks & Regards,