To connect SAP Datasphere with SAP HANA Cloud in SAP Business Technology Platform (BTP), you'll typically follow these main steps:

High-Level Overview

You connect SAP Datasphere to SAP HANA Cloud via a Data Integration connection, using Cloud Connector, Data Provisioning Agent, or a direct BTP native connection depending on where your systems reside.

✅ Step-by-Step Guide

1. Prerequisites

• You must have: SAP Datasphere tenant access SAP HANA Cloud instance (provisioned in BTP) Role assignments for administration & modeling Database user credentials for HANA Cloud

2. Get Connection Details from HANA Cloud

In SAP BTP Cockpit:

1. Navigate to Your Subaccount > Instances and Subscriptions
2. Find your SAP HANA Cloud instance
3. Click Actions > Open in SAP HANA Cloud Central
4. Copy: Host name (e.g. xxxx.hanacloud.ondemand.com) Port (usually 443) Database name User credentials (technical DB user, e.g., DBADMIN)

3. Create a Connection in SAP Datasphere

In SAP Datasphere:

1. Go to Connections > Create Connection
2. Choose SAP HANA Cloud as the connection type
3. Fill in: Connection Name (e.g., HANA_Cloud_Prod) Host: <your-host>.hanacloud.ondemand.com Port: 443 User / Password Database Name (same as in BTP HANA Cloud)
4. Select Connection Type: usually SAP HANA Cloud (not HANA on-prem)
5. Optional: Set up SSL/TLS configuration (usually pre-configured for HANA Cloud)

4. Test & Save Connection

• Click Test Connection
• If successful, click Create

If the test fails:

• Check firewall settings (if IP whitelisting is required)
• Ensure user permissions in HANA Cloud
• Use the Cloud Connector if HANA is hosted in a private network

5. Use the Connection in Data Builder

After connecting:

• Go to Data Builder
• Create a new Remote Table or SQL View
• Use your HANA Cloud connection as the source
• Browse schemas and tables
• Import or replicate as needed

🔐 Security Notes

• Prefer using technical users with minimal required privileges
• Monitor access via SAP BTP cockpit
• Enable TLS and IP whitelisting

Call us on +91-84484 54549

Mail us on contact@anubhavtrainings.com

Website: Anubhav Online Trainings | UI5, Fiori, S/4HANA Trainings