Skip to Content
Product Information
Author's profile photo Suresh Vasudevan

Steps to create connection between SAP Datasphere and SAP HANA Cloud(BTP)

Business Need:

Sometimes there will be a need to connect to SAP HANA cloud and extract high volume data from remote Database.

Below we see steps that are required to create a connection between SAP Datasphere and SAP HANA Cloud(BTP)


Connect to SAP HANA Cloud (BTP) from SAP Datasphere

create a connection successfully!


1.Logon to SAP Datasphere and select “Connections” from the main menu.

2.Select Create option from Menu.

3.Select SAP HANA from the menu



a) Port No: 443

b) Host: We get Host information SAP HANA Database Explorer

5.Please provide SAP HANA Coud DB instance credentials (DBADMIN / Instance Name)

6.Provide connection name you want use


7.We can check the newly created connection

8.Final step to see the remote SAP HANA Cloud DB objects from SAP Datasphere


Following the above steps, we can establish a local connection and extract underlying tables and business data available on SAP HANA cloud.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Giri Raaj Ragupathi
      Giri Raaj Ragupathi

      Nice Blog Suresh.Very useful. Thanks for sharing.Great work!

      Author's profile photo Amlan Dhow
      Amlan Dhow

      Helpful documentation!

      Author's profile photo VANNIARAJAN CHIDHAMBARAM

      Nice blog!! Suresh. This is the Data Virtualization feature. Connecting to a data source and virtually accessing the objects without having to ingest the data.

      It would be great if you can add another connection to any other DB like Oracle or Azure Sql, or even a .xls and show federation..  

      I would love to see a second blog showing multiple connections and blending/federating data.

      This is a powerful feature we have been waiting since Business Objects Universe era. I'm glad to see this finally in DataSphere. SAP customers will get immensely benefited from this virtualization feature.  

      Author's profile photo Prashant Pasupuleti
      Prashant Pasupuleti

      Hi Suresh,

      Nice information, does it ask for any ssl certificate for the validation of the connection. If yes where to install the certificate.

      Author's profile photo Suresh Vasudevan
      Suresh Vasudevan
      Blog Post Author

      No SSL certificate information requested. connected from SAP Datasphere guided experience.