Skip to Content
Author's profile photo Tammy Powlas

SAP HANA Cloud Integration for Data Services – an ASUG Webcast

Ben Hofmans, HANA Cloud Integration product owner, more specifically for Data Services provided this ASUG webcast.   As background you can  read Dick Hirsch’s blog and comments What if HANA Cloud Integration was already productive and nobody knew (or cared)

Another blog is SAP HANA Cloud Integration, First Thoughts by Pim de Wit

HANA Cloud Integration is an on demand version of Data Services.  The usual disclaimer applies – things discussed below are subject to change.  Please note these are my notes and I am not a subject matter expert in this area.


Figure 1: Source

Figure 1 shows that there different kinds of clouds

Integration is important in all cloud types

On the left of Figure 1 is the Managed Cloud where SAP provides hosted version of software  – HANA Enterprise Cloud is an example – you get a HANA box – it is not in your network, you don’t acquire hardware or maintain.  It is by SAP in the managed cloud.

In the middle blue box – LOB applications – SuccessFactors, ByDesign, Sales & Operations Planning, Travel on Demand – you don’t have access to HANA database but the UI’s to connect to cloud applications.

Third area is Marketplace – launched at SAPPHIRE – you buy SAP applications – mainly Amazon and other partner clouds provided later

There are many clouds. Integration is an important service, says Ben.


Figure 2: Source: SAP

LOB (“line of business) users is on the left and the right is IT with their requirements – for integration between on premise and in cloud

LOB users want a single source of truth and master data synchronization – one master system for employees, customers .

LOB needs more real-time business process integration

IT’s main concern is data security.


Figure 3: Source: SAP

On premise in the cloud and on premise systems and third party solutions

SAP HANA Cloud integration includes process integration and data integration

NetWeaver PI & Data Serivces for data integration – the Cloud brings these two together, with real time process integration.

It has pre-packaged integration flows from SAP system on premise, with a  place to share content

SAP HANA Cloud Integration (Data Services)

The same development team who works on premise works on the cloud offering.

This is Data Services in SAP HANA Cloud, which is a new solution, new architecture, for multi-tenant cloud environment


Figure 4: Source: SAP

SOP is Sales & Operations Planning and since last December is live and GA

It can move data from on premise (ERP APO) and load to HANA hosted in cloud – where SOP planning is built.

SOP  enables organizations to align supply & demand in real-time


Figure 5: Source: SAP

The SuccessFactors application is used to manage employee performance

For business execution use BizX

You can get data from on premise or the other way around, as shown in Figure 5.


Figure 6: Source: SAP

You can access SAP HANA box and SAP HANA marketplace, with your HANA database, data services

You can use this to extract data from on-premise (Business Suite, or data bases) and load to Hana database


Figure 7: Source: SAP

Figure 7 shows Data Services on Demand, available today.  It provides a role based user interface

Data Services extractors that work for on premise also work for Cloud, said Ben.


Figure 8: Source: SAP

Figure 8 shows that there is a lightweight installation inside – where to install, which user to install

The agent packages and sends through https to the cloud

You do not need to open firewall  – the request is from on premise to the cloud


Figure 9: Source: SAP

Ben said you do not need a hard core development.  It offers an HTML5 interface as shown in Figure 9.

You can drag and drop to model data flows from on premise to the cloud or the other way

During this webcast, Ben provided a demo of


Figure 10: Source: SAP

Later this year they plan to offer a license not tied to an SAP cloud application

Limited ETL – only focused on what cloud applications needed (this does not include unstructured)


Figure 11: Source: SAP

Ben said Figure 11 was presented at SAPPHIRE.

SAP Lumira is the new BI on demand solution – need to load to cloud – Hana cloud will play a role for delta loads

Subset of Question & Answer

Q:  Is “Data Services On Demand” only applicable when loading data onto the SAP cloud, or could be used to load data onto an on premise SAP system ?

  A:  For the moment, the Cloud needs to be one end of it. It can load into the on premise system.


Q:  Does this provide integration for SAP BW and SF Workforce Analytics?

A:  Workforce Analytics is in pilot. Not GA yet.

A:  Currently it is not available yet for SAP BW


Q:  SAP Cloud for Travel – we are very close to purchasing Travel On Demand – should we ask our SAP sales person about whether HCI would be the way to integrate with on-premise ERP?  I assume it would be included in ToD pricing?

A:  Definitely worth enquiring.


Q:  How is performance of the data loading ensured?

A:  There are 3 parts that influence performance: (1) extraction, (2) data transfer to the cloud and (3) inserts in the HANA target database.

The onPremise agent is based on the SAP Data Services engine, so has a long history of optimizing extraction from various sources through native protocols (RFC, business content extractors and ABAP generation, as well as native database access for non-SAP systems).

For the data transfer to the cloud, the onPremise agent will compress the data before sending it to the cloud. This is also the part of the overall loading time where bandwidth between the customer’s network and the cloud plays a major role.

Once the data is received by the HCI server component, a dedicated HANA loader will take care of high performance inserts/updates in the HANA database in the cloud.


Q:  In which country is the cloud data stored?

A:  SAP has Data Centers across the world.


Q:  I assume Hana Cloud Integration can schedule tasks, can one task call another task? Resulting in the triggering of Tasks, based on other task completion.

A: Yes, HCI can schedule tasks.

Scheduling is currently time-based only, it is not possible to set dependencies between tasks, or launch one task from another task.

Special thanks to Ina Felsheim for setting up this ASUG webcast and Ben Hofmans for providing it.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks so much for this Tammy - it is really useful for me as I'm focusing my IT Masters on cloud integration at the moment and am really interested in SAP HCI.


      Please let me know if there is another similar SAP HCI webcast/webinar soon?  I'm already following Ben Hofman in this SAP Community.


      Many thanks once again,

      Szu Hill

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Thank you for reading and replying


      I am not aware any another HCI webcast coming soon, but please check the ASUG.COM calendar




      Author's profile photo Louis de Gouveia
      Louis de Gouveia

      Nice post Tammy. Thanks.

      Author's profile photo Former Member
      Former Member

      Very informative, Tammy. Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Hi Tammy, tnx for this blog. I'm not really an expert on Data Services am more into the process integration part of HCI. Since current NetWeaver Pi is not this close integrated with current BO data services 'm curious. I do know that within BO portfolio SAP is also positioning this for Data migration. So i'm curious on two things:

      • Does SAP deliver standaard Business content with HCI Data services for Non-SAP systems. And will it be possible for partners to build this?
      • Will HCI Data services, in your opinion, be a future tool to support customers to migrate Cloud offerings (Like from workday to Succesfactors of form Salesforce to SalesOnDemand?



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author


      Thank you for reading and commenting.


      To be honest, I don't know the answers to your questions, but I will forward to our ASUG point of contact who set this webcast up.


      Thank you,


      Author's profile photo Richard Hirsch
      Richard Hirsch



      Regarding the integration of non-SAP sources, you may want take a look at a comment that Chris Purpura  (VP and GM Cloud Integration - MuleSoft) made on my last HCI blogs:



      Author's profile photo Former Member
      Former Member

      I've read the comment and i'm aware of the Mulesoft proposition. I fact it's also positioned in the SAP slides (as referred to in my blog). However in current NetWeaver PI SAP delivers an integrated Adapter Engine. This is currently not the case with HCI (and it's not in the roadmap) Message integration in HCI is now limited to iDoc, sFTP and SOAP. I can't imagine that SAP is going to position other (cloud based) integration platform if customers have additional requirements. More logical would be that HCI get's a adapter engine extension.

      Author's profile photo Matthias Steiner
      Matthias Steiner

      Thanks for sharing Tammy! Is there a recording available by chance?

      Author's profile photo Ina Felsheim
      Ina Felsheim

      There is a recording on the ASUG website: . It requires login and the WebEx ARF player.

      Author's profile photo SrinivasuluReddy T
      SrinivasuluReddy T

      Thanks for sharing Nice Information Tammy.


      I need to know one thing


      Can we connect other cloud Services other than HCI  ?


      Is there any Connectors to connect Lumira Cloud, Sales Force etc.?


      Best Regards


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Srinivas - I don't know - please ask this question in the discussion area.

      Author's profile photo Rajagopal Sampath
      Rajagopal Sampath



      We are planning SAP-HR system connected to SuccessFactor through HCI.


      When I searched, I could see only SAP Data Services agent and installed in Windows Server ( similar to Fig-8).


      Another option in Scenario-2 (Fig-5) shows only HCI agent on-premise to connect to  Successfactor.


      How is it different from SAP Data Services agent ? I see agent could be created in HCI which is located in SAP side. Not sure, HCI-agent on-premise side.


      If HCI-agent is preferable, how to get this downloaded from SMP ?


      Would appreciate your feedback on this,





      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Raj - thank you for reading


      I don't know the answers to these questions


      Please post these questions in the discussion area and hopefully you will get a response.

      Author's profile photo Former Member
      Former Member

      Hi Raj,


      I think there's some confusion here between the 2 flavors of HCI we have. We have HCI for process integration use cases (HCI-PI) and HCI for data services use cases (HCI-DS). Your scenario looks more like a process integration use case - there is even some out of the box content available for this, see: . For the HCI-PI  there is no onPremise agent, your onPremise SAP HR system will send the data to the cloud directly though the HCI-PI middleware.


      This blog post is about the HCI-DS flavor. In that case we allways need an agent onPremise that will pull the data from onPremise systems (SAP or non-SAP) to load to the cloud application.


      Hope this helps.


      Ben Hofmans

      Product owner SAP HANA Cloud Integration for data services