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%20about%20the%20Scenario

Overview about the Scenario

Useful Links: 

Prereqisite:

  • 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

Step-by-step:

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%20Database%20User

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%20relevant%20View%20for%20Consumption

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%20Explorer

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%20source%20creation

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.

 

CREATE REMOTE SOURCE <HANA1> ADAPTER "hanaodbc" 
    CONFIGURATION 'Driver=libodbcHDB.so;ServerNode=<HANA_Cloud_endpoint>;
    encrypt=TRUE;'
    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%20Source

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%20Source%20System

HANA_SDA Source System

 

Conclusion:

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.

https://roadmaps.sap.com/board?range=FIRST-LAST&PRODUCT=73555000100800002141#Q4%202022;INNO=000D3AAADBCE1EEC8FC7403F8FE56994

 

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

 

Regards,

Dominik

Assigned Tags

      6 Comments
      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!
      One question. What you mean with "hanaodbc" is the default HANA driver provided by SAP HANA Smart Data Access (SDA), right?

      Thank you - 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!