Skip to Content
Technical Articles
Author's profile photo Christopher Kampmann

SAP Data Warehouse Cloud – Connecting local systems like SAP BW / 4HANA


The Data Warehouse Cloud (DWC) comes out-of-the-box with the option of uploading your own data in the form of flat files. This is sufficient for smaller demo scenarios, but for serious use the requirement to connect data from existing systems arises very quickly.

The connection of own systems takes place via Smart Data Integration (SDI), which is an integral part of the Data Warehouse Cloud. A data provisioning agent then creates the bridge to the SDI of DWC on premise.

Since the DWC is tenant-based software-as-a-service solution, the SDI component cannot simply be installed on the DWC side or configured using the usual means. Instead, DWC also offers the option of connecting local systems “as-a-service”, which only needs to be connected to the local components accordingly.


The SDI component of the own DWC tenant is defined as the end point of the local data provisioning agent. The ABAP and HANA adapters of the provisioning agent are currently supported by DWC. Future DWC releases may support additional adapter types. With the ABAP and HANA adapters, however, it is already possible to connect most SAP systems as a source system, including SAP BW (as ABAP system) and HANA as database. In this example, a SAP BW / 4HANA 2.0 will be connected to the DWC.

Since we assume a mixed model (BW and HANA modeling), the system should be connected via both ABAP and HANA adapters. This enables a connection on the DWC side both to the BW data models (ADSOs, composite providers, queries) and to the HANA data models (tables, views, calculation views).

Neccessary Components


  • A DWC tenant is available, the corresponding spaces, users and authorizations are set up
  • A SAP BW / 4HANA system is available on-premise
  • A network connection with appropriate routings and firewall settings allows access between the cloud (DWC) and on-premise (provisioning agent, SAP source systems)
  • A local machine with network access to the BW / 4HANA source system is available for installing the provisioning agent. In the following we assume that this is a Linux-based server. Attention: The installation of the provisioning agent directly on the source system (BW / 4HANA system) is technically possible, but not recommended!

Software needed

  • To install a local provisioning agent, the following software must be obtained from the SAP Marketplace and made available on the target machine for the provisioning agent: HANA DP AGENT 2.0,SP04 or newer


Procedure to connect the systems


1.1 Unzip and install the software downloaded from SAP.
Typically on the command line under Linux, i.e .:

1.2 Install the software. This is done using hdbinst

An operating system user must first be created for the agent. It should also be determined beforehand which free ports can be used for Agent Listener and Agent Administrator.

The manual of SAP for the preparation, planning and implementation of the installation also contains important information on requirements and procedures.


After the installation, the agent must be configured. To do this, we need information from our DWC tenant on the endpoint with which the local provisioning agent should communicate

2.1 Register a new data provisioning agent in the DWC with an admin user in the data sources area:

After entering the name for the new agent, an information window appears which contains important connection information for the agent to the DWC:

  • Server name (depending on where the DWC tenant is hosted)
  • Port
  • Username and password for connection

2.2 The local agent that has just been installed must now be connected to the DWC.

To do this, the DWC connection information is specified in the agent’s dpagentconfig.ini file:

The agent can now be started:

To do this, a new SAP HANA connection is specified (option 2 in the configuration menu):

See also: SAP-Notes.

2.3 Register the ABAP and HANA adapter in the DWC for this agent:

Edit the agent that has just been created in the DWC. Select both HANA and ABAP adapters.

The Provisioning Agent should now be registered and connected:


2.4 The local agent that has just been installed must now be connected to the DWC:

The registered agent is already communicating with the DWC, but a connection to a specific source system must first be created in the DWC and assigned to the respective spaces as a resource before the data of the on-premise systems can also be accessed via the agent.

Create a new connection under “Connections” (type ABAP or HANA)

Enter a name, select the Provisioning Agent you have just created, and enter the technical information on the source system (server, port, user, password).


Connections to BW / 4HANA (ABAP):

  • ABAP adapter
  • Specify host, instance, client as in SAPGUI connection
  • and then a valid BW user + password

Connections to the HANA DB:

  • HANA adapter
  • Host: Specify the host name of the HANA instance
  • Port: depending on which DB tenant is to be connected to. The corresponding JDBC port from the HANA configuration must be specified!
  • User + password then also dependent on the target DB tenant

See also SAP-Notes.

Conclusion: The Connection can now be used in the Space

The connection of your own on-premise systems to the DWC is quick and easy by providing the smart data integration component by simply setting up a central data provisioning agent on premise.

This then accesses the source systems on a representative basis and thus ensures a transparent connection to the DWC.

An individual connection of each individual system is not necessary.

At the moment, SAP systems in particular can be quickly integrated with the ABAP and HANA adapters. It is to be hoped that further adapter types will be supported.

Under this Link the article can also be found in german.

Assigned Tags

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

      Hi Christopher! Do you know what is the minimal version required for connect a ECC (Without HANA) system with DWC? Thanks for sharing this excellent content.


      Enio Terra

      Author's profile photo Christopher Kampmann
      Christopher Kampmann
      Blog Post Author

      Hi Enio,

      the technology behind the connection is Smart Data Integration. The ABAP Source System should support the ODP framework. I guess with ECC6.0 it could work.

      Important is the NetWeaver Version. The following Releases are minimum:

      SAP Note 1521883

      • 7.0 SPS 24
      • 7.0 EHP 1 SPS 9
      • 7.0 EHP 2 SPS 8

      SAP Note 1931427

      • 7.3 SPS 8
      • 7.3 EHP 1 SPS 5
      • 7.4 SPS 02

      See also SAP Note 1560241 for the release of a Data Source for ODP



      Best regards


      Author's profile photo Ashish Tiwari
      Ashish Tiwari

      Hi Christopher,

      Very informative post . Thanks for sharing your learnings!

      I might sound a bit naive while asking this but I am trying to learn more

      Can you point me to content to explain the below ?

      Since the DWC is tenant-based software-as-a-service solution, the SDI component cannot simply be installed on the DWC side or configured using the usual means.

      My interpretation
      As DWC is a tenant based SaaS solution why cant the provider group subscribers of this SaaS service who want an SDI component and make it available for all ?

      Author's profile photo sandeep karnati
      sandeep karnati

      Hello Christopher,

      Thank you  For  the Blog.

      1. could you please elaborate in scenarios i need to use the ABAP  and HANA  Adapters for respective connections
      2. Is that necessary to use DPA for ABAP connection's to DWC? can't i just use SAP Cloud Connector?
      3. if i can connect my backed system to DWC (ABAP connection) ,why do i need to use Hana Adapter ?


      Author's profile photo Sebastian Gesiarz
      Sebastian Gesiarz

      hi sandeep,

      did you get to know if

      1. Is that necessary to use DPA for ABAP connection's to DWC? can't i just use SAP Cloud Connector?


      I was wondering the same if Cloud Connector will be enough to connect BW/4 and SAC to DWC

      Author's profile photo sandeep karnati
      sandeep karnati

      Hello Christopher,

      after installing the DPA in our local network,inorder to register the DPA on DWC (DWC is in eu10) ,Do i need to expose DPA installed server IP to internet and whitelist that IP in DWC?