Technical Articles
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:
- SAP Cloud Platform Integration
- SAP Process Integration (PI)
- 3rd Part Tool (SEEBURGER BIS)
- SAP Data Intelligence -> coming soon
Hello
DataHub is already shown in the Blog - DataHub Implementation with the SLC Bridge
Best Regards Roland
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
Hi Corvin,
good catch. I changed the link - should be working now.
BR
Gordon.
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
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
Hi Gordon,
Link not working..
Thanks,
Rajeev
Hi Rajeev,
which link do you mean?
BR
Gordon.
Gordon,
DSO with Write Interface..it still says that you are not authorized
Thanks,
Rajeev
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
Rather short, but nevertheless useful post with a lot of relevant links! Thanks!
Hi Gordon,
Is SAP Note/KBA 2865304 has been removed.Its for Data Tiering Optimization ,I am getting this message .
Besr Regrds,
Praveen
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.
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
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
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
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.