Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert
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 Datasphere.

Data from SAP Datasphere 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 Datasphere 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 Datasphere 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 Datasphere 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 Datasphere 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 Datasphere. This DataSource can be used to extract data into a DataStore object. Like this, data stored in SAP Datasphere 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 Datasphere can also be easily integrated into other SAP analytics products.As of today, we have not planned a standardized connection for SAP Datasphere 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 Datasphere as a source.;INNO=000D3AAA...


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