Skip to Content
Technical Articles
Author's profile photo Gordon Witzel

Data Integration with SAP BW/4HANA 2.0

Dear friends of SAP BW/4HANA,

I’m working for SAP since more than 12 years and as a member of the BW product management team I received a lot of questions from customers regarding new functionalities for integrating data into SAP BW/4HANA.

SAP BW/4HANA provides a multitude of innovations in various areas. One of the focus areas are extended and simplified ways to integrate non-ABAP – typically non-SAP – data structures as well as ABAP – SAP Systems – data structures into SAP BW.

Loading and persisting data from on-premise sources as well as Cloud Applications is and will be one of the key functionalities of an Enterprise Datawarehouse (EDW).

Loading and persisting data from Cloud Applications (e.g. SuccessFactors) in an SAP BW/4HANA data warehouse is possible in many ways.

To enable such scenarios, SAP BW/4HANA 2.0 provides new capabilities in the DataStore Objects to push data in the inbound table of the DataStore Object. With this new Setting in the DataStore Object in SAP BW/4HANA 2.0 it is possible to use tools such as Data Services or via SAP Cloud Platform Integration (CPI) to PUSH data into a DataStoreObject directly.

This property can be used for all types of standard DataStore object and staging DataStore object, but not together with Inventory enabled or Planning enabled DataStore Objects.

It is possible to use RFC or http data to load data into the DataStore object. There are two possible procedures:

  • Sending data without a request: For every call, a new internal request is opened
  • Sending data with a request: The following sequence is used to do this: Open Request, n times Send Data (with request and package), Close Request

SAP Cloud Platform Integration and SAP Process Integration equal or higher 7.5 SP15 (see SAP Note 2757524) can use this http (REST) interface for data integration to SAP BW/4HANA 2.0.

Please find more information in the documentation DataStore Object with Write Interface, in the What’s new with SAP BW/4HANA 2.0 (page 24) and in the SAP BW/4HANA Community.

This blog post describes the options SAP provides with SAP BW/4HANA 2.0 to push data into a write interface enabled DataStore Object.

The following options are described in detail in independent blogs posts:

Assigned Tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Roland Kramer
      Roland Kramer

      Hello

      DataHub is already shown in the Blog - DataHub Implementation with the SLC Bridge

      Best Regards Roland

      Author's profile photo Corvin Schindler
      Corvin Schindler

      Hello Gordon,

      a quick hint: the link DataStore Object with Write Interface is directed to a draft version, which I don't have access to.

      Best regards,

      Corvin

      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author

      Hi Corvin,

      good catch. I changed the link - should be working now.

       

      BR

      Gordon.

      Author's profile photo Arthur Chen
      Arthur Chen

      Hi Gordon

      This link still doesn't work, it shows "Not authorized".

      Is there any quick guide on the steps to set up the connection from DS to DSO with write interface?

      Cheers

      Arthur

      Author's profile photo Sparsh Mehrotra
      Sparsh Mehrotra

      Hi Gordon,

      Can you please share the link for Data Hub/Data Intelligence option blog for pushing data into a write interface enabled DataStore Object.

      Thanks and Regards,

      Sparsh

      Author's profile photo Rajeev Parimi
      Rajeev Parimi

      Hi Gordon,

       

      Link not working..

       

      Thanks,

      Rajeev

      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author

      Hi Rajeev,

       

      which link do you mean?

       

      BR
      Gordon.

      Author's profile photo Rajeev Parimi
      Rajeev Parimi

      Gordon,

      DSO with Write Interface..it still says that you are not authorized

       

      Thanks,

      Rajeev

      Author's profile photo Frank Riesner
      Frank Riesner

      Hi Rejeev,

      this is the URL to the current online help of BW/4HANA, and there directly to this specific ADSO type.

      https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.0/en-US/8127edbcf2fa488ba04dfc1751d5261d.html

      You should be able to access this, it is a public source.

      KR Frank

      Author's profile photo Andrei Dorfman
      Andrei Dorfman

      Rather short, but nevertheless useful post with a lot of relevant links! Thanks!

      Author's profile photo Praveen Boyapati
      Praveen Boyapati

      Hi Gordon,

      Is SAP Note/KBA 2865304 has been removed.Its for Data Tiering Optimization ,I am getting this message .

       

      Besr Regrds,

      Praveen

       

      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author

      Hi Praveen,

      SAP Note https://launchpad.support.sap.com/#/notes/2865304/E is not longer as this feature is GA since SAP BW/4HANA 2.0 SP07. https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.7/en-US/422c2c4d41004e09ab5eb7df1525d4dd.html?q=exceptional

      There is no longer a pilot program for the exceptional updates to cold stores needed.

      BR
      Gordon.

      Author's profile photo Gopal KS
      Gopal KS

      Hi Frank/Gorden,

       

      Can you please let me know how to update entries in active table instead of inbound table. we are able to post in inbound table. we would like to know to post in active table.

       

      Thanks,

      Gopal KS

      Author's profile photo Frank Riesner
      Frank Riesner

      Hi Gopal,

      the data cannot directly be pushed into the ADSO active table. It has to go via the inbound table, and then the activation process will push it to the active table. See details on how to achieve this here.

      KR Frank

      Author's profile photo Ayanaditya Mandal
      Ayanaditya Mandal

      Hi Gordon,

       

      We are using Data intelligence 3.1 along with BW4HANA 2.0, please share steps to load data into a

      write interface enabled ADSO from DI if any.

       

      Thanks

      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author

      Hi Ayanaditya,

       

      please find the required information in the SAP Help pages here:

      https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/97fce0b6d93e490fadec7e7021e9016e/c8095cfc4c704f4eb3cb0cd4cfd98791.html?locale=en-US

      BR

      Gordon.