Skip to Content
Technical Articles
Author's profile photo Dominik Kurz

BestPractice – How to use SAP Data Warehouse Cloud as source for SAP BW/4HANA

A frequent use case in hybrid data warehousing scenarios is to enrich existing data models in SAP BW/4HANA with analytical data models from SAP Data Warehouse Cloud.

Data from SAP Data Warehouse Cloud is to be transferred to SAP BW/4HANA to enrich the existing data flow in the on-premise system with public cloud data.

The following blog describes how data stored in the SAP HANA Cloud database of SAP Data Warehouse Cloud can be consumed in an on-premise SAP BW or SAP BW/4HANA system.


Overview about the Scenario

Useful Links: 


  • Certificate for SSL Connection to Remote sources is created and imported in SAP HANA Database under SAP BW/4HANA
  • IP Allowlist in SAP Data Warehouse Cloud Core is adjusted with relevant External IP from SAP BW/4HANA


In the first step, the space from which data is to be read must be opened in Space Management. There, a database user with Read Access authorization must be created.



Create Database User

In the second step, it is necessary to enable the property Expose for Consumption for the view that is to be used in SAP BW/4HANA.


Expose relevant View for Consumption


After the view has been activated for consumption, the Database Explorer can be used to check whether the view is accessible in SAP HANA Cloud in the corresponding schema and is supplying data. To do so, go back to Space Management and call the Database Explorer.


Database Explorer

In the next step, a remote source of type hanaodbc must be created in the SAP HANA database of SAP BW/4HANA. The credentials of the database user created in SAP Data Warehouse Cloud are used for this remote connection.


Remote source creation

The SQL code below can be used to create the remote source. The technical name, the SAP HANA Cloud Endpoint, and the credentials must be adjusted accordingly.


    CONFIGURATION ';ServerNode=<HANA_Cloud_endpoint>;
    WITH CREDENTIAL TYPE 'PASSWORD' USING 'user=<user_name>;password=<password>';


After the remote source has been successfully created, the objects exposed in SAP HANA Cloud of SAP Data Warehouse Cloud can be consumed in the on-premise SAP HANA database of SAP BW/4HANA.


Remote Source


In the next step, it is necessary to create a SAP HANA_SDA source system for the remote source to SAP HANA Cloud. For this source system, a DataSource must be created to consume the view exposed for consumption in Data Warehouse Cloud. This DataSource can be used to extract data into a DataStore object. Like this, data stored in SAP Data Warehouse Cloud can be reused in SAP BW/4HANA.


HANA_SDA Source System



As can be seen in the previous sections, existing analytical data models from SAP Data Warehouse Cloud can also be easily integrated into other SAP analytics products.As of today, we have not planned a standardized connection for SAP Data Warehouse Cloud as a source for SAP BW/4HANA. In SAP BW bridge, on the other hand, we are currently working on a solution for using SAP Data Warehouse Cloud as a source.;INNO=000D3AAADBCE1EEC8FC7403F8FE56994


Please let me know, if you have any detailed question!




Assigned Tags

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

      Great Blog Dominik - thanks for sharing!
      To clarify the details of the SQL command for creating the remote connection (as of SAP note 3145657 the only option in HANA Studio), find below another example with further explanation.
      KR Frank

      Author's profile photo Elson Simoes
      Elson Simoes

      Thanks for sharing Dominik!

      It is good to see good quality actionable content like this 🙂


      Author's profile photo Cemal Aslan
      Cemal Aslan

      Thank you Dominik for sharing, great Blog.

      Author's profile photo Jens Rottmann-Matthes
      Jens Rottmann-Matthes

      That is a well explained howto!

      Thank you Dominik!

      Author's profile photo Gary Rucker
      Gary Rucker

      Thanks for sharing!

      Author's profile photo Jennifer Hornbecks
      Jennifer Hornbecks

      Thanks for the information!