JinJin48
JinJin48
SAP Consultant | BTP · S/4HANA · US Global Rollout
· 15 min read

Cover: SAP HANA Cloud Architecture and Use

TL;DR
  • SAP HANA Cloud is BTP’s core in-memory database, combining OLTP, OLAP, multi-model engines (relational, graph, spatial, JSON, vector), and a managed data lake in a single cloud-native service available in 40+ regions.
  • Production-ready for transactional and analytical workloads; native multitenancy (Q4 2024), automated HA/DR, and SAP-managed backups reduce operational overhead significantly — but connection pool sizing, data residency planning, and HDI container governance must be addressed before go-live.
  • Shift your mindset from “database migration” to “data platform decision”: HANA Cloud is not just a hosted HANA — it changes how you license, govern, and integrate data across BTP services.

Where This Article Sits

IDCategoryComponentScope
BTP-C01OverviewData and AnalyticsOverview and Capability Map
BTP-C02Architecture and UseHANA CloudArchitecture and Use (this article)
BTP-C03Architecture and UseSAP DatasphereArchitecture and Use
BTP-C04Architecture and UseSAP Analytics CloudArchitecture and Use
BTP-C05Architecture and UseData IntegrationArchitecture and Use
BTP-C06Architecture and UseData GovernanceArchitecture and Use

References

ResourceURL
SAP HANA Cloud — Getting Started Guide (BTP Integration)help.sap.com →
SAP HANA Cloud Multitenancy — Introductionhelp.sap.com →
SAP HANA Cloud — Backups and Recoveryhelp.sap.com →
SAP HANA Cloud — HDI Container Referencehelp.sap.com →
SAP HANA Cloud Features (Product Page)sap.com →

1) The Data and Analytics Landscape

Hub-and-spoke diagram showing HANA Cloud at the center of the Data and Analytics landscape with Datasphere, SAC, Data Intelligence, and Data Governance

The L2-C domain covers the services that store, move, model, and visualize data within SAP BTP. Each component plays a different role, and they are designed to complement each other. Source: SAP HANA Cloud Features.

CapabilityWhat it doesPrimary user
SAP HANA CloudIn-memory database platform for transactional and analytical workloads; multi-model data engineApp developer, data engineer, DBA
SAP DatasphereFederated data layer for enterprise-wide data modeling and semantic layer managementData architect, BI developer
SAP Analytics Cloud (SAC)Reporting, planning, and predictive analytics front-endBusiness analyst, finance controller
SAP Data Intelligence / IntegrationData pipeline orchestration and integration across cloud and on-premise systemsData engineer, integration specialist
Data GovernanceMetadata catalog, data quality, and lineage for trusted data assetsData steward, compliance officer

They are not substitutes. HANA Cloud is the persistence and compute layer; the others depend on it, sit beside it, or consume from it.

2) How It Connects to S/4HANA

Hub-and-spoke diagram of HANA Cloud multi-model engines: relational, graph, spatial, JSON, vector, and data lake

Layered stack showing data flow from S/4HANA through replication into HANA Cloud and up to CAP applications

SAP S/4HANA in any deployment model (Public Cloud Edition, Private Cloud Edition, or on-premise) generates transactional data that BTP-hosted services consume. SAP HANA Cloud sits at the center of this integration.

┌─────────────────────────────────────────────────────────────────┐
│                        SAP BTP Subaccount                        │
│                                                                   │
│  ┌────────────┐    BTP Service     ┌──────────────────────────┐  │
│  │  CAP App   │◄──── Binding ─────►│   SAP HANA Cloud         │  │
│  │ (Node/Java)│   (VCAP_SERVICES)  │   - Relational Store     │  │
│  └─────┬──────┘                    │   - Document Store       │  │
│        │                           │   - Graph Engine         │  │
│        │ OData / REST              │   - Vector Engine        │  │
│        ▼                           │   - Spatial Engine       │  │
│  ┌─────────────┐                   └───────────┬──────────────┘  │
│  │  SAP BTP    │                               │                  │
│  │  Cockpit /  │                    HDI        │  Data Lake IQ    │
│  │  HANA Cloud │◄──── Admin ───────►Containers │  (petabyte-scale │
│  │  Central    │                               │   analytics)     │
│  └─────────────┘                   ┌───────────▼──────────────┐  │
│                                    │   SAP Data Lake Files     │  │
│                                    │   (Azure/AWS/GCP object   │  │
│                                    │    storage, SAP-managed)  │  │
│                                    └──────────────────────────┘  │
└─────────────┬───────────────────────────────────────────────────┘
              │
     Replication / Virtualization
              │
┌─────────────▼───────────────────────────────────────────────────┐
│  SAP S/4HANA (on-premise / PCE / Public Cloud)                   │
│  SAP ECC / non-SAP sources                                       │
└─────────────────────────────────────────────────────────────────┘

Data flows from SAP and non-SAP source systems into HANA Cloud through replication (SLT, SDI) and virtualization services ( SAP HANA Cloud Getting Started Guide). Applications built with SAP Cloud Application Programming Model (CAP) receive database credentials automatically at runtime via BTP service binding (VCAP_SERVICES), eliminating manual credential management. HDI containers provide schema-per-tenant isolation within the same HANA Cloud instance.

Key point: HANA Cloud is not an isolated database — it is the data persistence hub for the entire BTP application and analytics ecosystem, and its provisioning decisions (region, size, multitenancy model) affect every downstream service.

3) Maturity Map

Checklist-style maturity map showing production-ready, ready-with-prerequisites, and early-adopter capabilities of HANA Cloud

CapabilityMaturityNotes
Core relational OLTP/OLAP✅ Production-readyColumn-store in-memory engine; up to 10,000x speed improvement cited for specific workloads ( SAP HANA Features)
Multi-model engines (graph, spatial, JSON)✅ Production-readyRelational, document, geospatial, knowledge graph, and time-series engines all generally available; vector engine added in recent releases
Native multitenancy (database-level)✅ Production-readyGA since Q4 2024; each tenant encrypted with customer-specific keys; tenant-level admin, backup, and recovery supported ( SAP TechEd 2025)
Data Lake (IQ + Files)✅ Production-readyElastic storage in 1TB increments; current limit 90TB (expandable on request); no pre-provisioning required
HA/DR (System Replication)✅ Production-readyRPO = 0 seconds, RTO in minutes; synchronous and asynchronous replication options ( HA/DR blog)
AI-driven query agents (Discovery / Data Agent)⚠️ Ready with prerequisitesNatural-language to SQL query generation introduced in early 2026; requires careful governance of which data is exposed ( SAP TechEd 2025; What’s New March 2026)
Detailed performance tuning for multi-tenant workloads🔶 Early adopterWorkload classes available for resource management; sizing guidance for high-concurrency multi-tenant deployments is still maturing

4) Requirements Checklist

Tenant and contract prerequisites

Checklist of seven tenant and contract prerequisites for HANA Cloud deployment

Checklist itemWhy it matters
BTP global account and subaccount confirmed with Data & Analytics entitlementHANA Cloud cannot be provisioned without the entitlement assigned at subaccount level
Cloud Foundry or Kyma runtime enabled in target subaccountService bindings are delivered through CF or Kyma; runtime choice affects credential injection
Target deployment region confirmed and data residency signed offOnce provisioned, migrating regions requires a full service copy — not a reconfiguration
Sizing estimate (memory / storage / vCPUs) reviewed against workload profileCredit-based licensing means over-sizing increases cost directly; under-sizing causes performance degradation
Credit consumption model understood by budget ownerAll engines (graph, spatial, etc.) are included; cost driver is compute and storage size, not feature selection
Multitenancy model decided (single-tenant vs. native multi-tenant)Native multitenancy (Q4 2024 GA) allows logical isolation within one instance; schema separation recommended for most balanced tradeoffs ( Multitenancy docs)
HANA Cloud Administrator role collection assigned to named operations teamWithout explicit role collection assignment in BTP, no one can provision or manage instances

Data integration and source system readiness

Checklist of six data integration readiness items including replication, connectivity, and backup policies

Checklist itemWhy it matters
Source systems and replication mechanisms identified (SLT, SDI, CDS extraction)Integration method determines latency profile; real-time replication has different infrastructure prerequisites than batch
On-premise HANA connectivity confirmed (if applicable)Federation requires Cloud Connector or HANA smart data integration; network topology needs security approval before project start
Non-SAP source access scoped and owner identifiedEach non-SAP source requires a separate integration agreement; ownership gaps delay go-live more than technical issues
Data classification and sensitivity levels documented for all source datasetsDetermines encryption requirements and whether Data Lake Files can be used for that data type
Backup retention policy aligned with recovery requirementsDefault is 14 daily backups (RPO ≤ 15 minutes for log backups); extended retention must be explicitly configured ( Backups and Recovery)
Point-in-time recovery requirement confirmedRecovery beyond 14 days requires retention period extension that must be budgeted explicitly

Application and HDI container governance

Layered stack showing HDI container lifecycle from design-time to runtime with governance controls

Checklist itemWhy it matters
HDI container naming and ownership convention established before development beginsUncontrolled proliferation makes lifecycle management unmanageable in multi-team projects
Design-time (DTC) and runtime container (RTC) lifecycle documentedHDI always creates DTC/RTC pairs; deployment pipelines must account for both ( HDI Reference)
Database object scope confirmed: HDI deploys only DB objects (no JS, OData, UI layers)Developers new to CAP often expect HDI to deploy application logic; this misunderstanding wastes sprint capacity
BTP service binding strategy confirmed per applicationCredential injection method must match the runtime; mistakes cause authentication failures
Connection pool size reviewed per application tier (CAP Java defaults to HikariCP max 10)Under-sized pools cause connection exhaustion at production load; must be validated against concurrent user estimates ( Connection pool sizing)
Workload class definitions planned for mixed OLTP/OLAP usageWithout workload classes, a runaway analytical query can starve transactional workloads ( Workload Classes)

Security and compliance

Checklist itemWhy it matters
Encryption at rest confirmed as default (communication, backup, and data-at-rest included)Confirm with security team whether customer-managed keys are required via SAP Data Custodian
Customer-managed key (BYOK) requirement assessedRoot keys can be stored in Instance SSFS or SAP Data Custodian; BYOK adds operational complexity and must be scoped early
Access control model designed (privilege levels, HDI container owners, schema separation)Cross-tenant access requires explicit grants and must be documented for audit purposes
Regional compliance requirements mapped to available BTP regionsData residency constraints may eliminate some of the 40+ regions; confirm before locking in subaccount structure

5) Decision Criteria

The three questions to ask first

Three-column comparison of the three key decision questions: measurable inefficiency, data residency, and budget sponsor

Q1. What measurable inefficiency or performance bottleneck does this solve?

Define the pain point in numbers: query latency (current vs. target), reporting delay (batch window vs. real-time requirement), or data silo count. If the answer is “we want to modernize the data platform” without a specific metric, the project scope is not ready to proceed. HANA Cloud’s in-memory architecture eliminates the need for separate OLTP and OLAP systems, but this benefit is only realized when both workloads have been quantified.

Q2. Where does the data live today, and who owns residency decisions?

HANA Cloud region selection is effectively irreversible after initial provisioning — moving to a different region requires a full data copy, not a configuration change ( SAP HANA Cloud Getting Started Guide). Data residency approvals from legal and compliance must be in hand before subaccount and instance creation. For EU data residency requirements, confirm which region option applies and verify that the cloud infrastructure provider (Azure, SAP Cloud Infrastructure, AWS, or Google Cloud) meets the applicable standard.

Q3. Is there an internal sponsor with budget authority and a committed go-live date?

HANA Cloud’s credit-based pricing means ongoing cost accrues from the moment an instance is running ( SAP Tutorials — HANA Cloud vs. On-Premise). Projects that start provisioning without signed cost approval face forced downsizing or instance deletion mid-development, losing environment state and adding re-setup cost. Confirm budget holder sign-off before any instance is provisioned in a productive or near-productive subaccount.

Domain selection by project context

Spectrum diagram showing project contexts from CAP apps to analytics mapped to recommended HANA Cloud capabilities

Project contextRecommended starting capability
New CAP application needing persistent storage on BTPSAP HANA Cloud (single-tenant or multi-tenant depending on isolation requirement)
Analytics layer on top of S/4HANA data without replicationSAP Datasphere (virtual federation) + HANA Cloud for local aggregation
Petabyte-scale historical data with infrequent accessSAP HANA Cloud Data Lake IQ
Semi-structured or document-like data alongside relationalHANA Cloud Document Store (JSON) within existing HANA Cloud instance
Highly connected data (org hierarchies, network analysis)HANA Cloud Graph Engine within existing HANA Cloud instance
Location-based business logic (delivery routes, proximity search)HANA Cloud Spatial Engine within existing HANA Cloud instance
No clear pain point identified yetStop. Go back to Q1.

Licensing and cost

Three-column comparison of HANA Cloud base, Data Lake, and on-premise licensing models

CapabilityLicensing modelKey question to ask
SAP HANA Cloud (base instance)Credit-based consumption; feature-inclusive — all engines included; cost driven by compute and storage size ( SAP Tutorials)What is the baseline vCPU and memory configuration, and what is the expected monthly credit consumption?
SAP HANA Cloud Data LakeCredit-based; storage scales in 1TB increments; no pre-provisioning costWhat is the expected data volume at steady state and growth trajectory over 12 months?
On-premise SAP HANA (comparison)Traditional license: upfront purchase + annual maintenance + customer-managed infrastructureIf migrating from on-premise, what is the total infrastructure ownership cost being eliminated?
Native multitenancyIncluded in base subscription; no per-tenant licensing feeHow many application tenants are planned, and does schema separation fit the isolation requirements?

6) Common Failures

2x2 matrix of common HANA Cloud implementation failures covering region lock-in, HDI sprawl, pool sizing, and governance gaps

Failure 1: Region lock-in from premature instance provisioning

A subaccount and HANA Cloud instance provisioned before data residency approval forces a choice between a costly migration and a compliance violation. Migrating to a different region after provisioning requires a full data copy. Make region confirmation a formal gate before any instance is created.

Failure 2: Treating HANA Cloud as a drop-in replacement for on-premise HANA

HANA Cloud shares a common SQL codebase with on-premise HANA ( SAP Tutorials), but the operational model is fundamentally different. OS-level access, manual backup configuration, and custom kernel parameter tuning are unavailable. Projects that assume these capabilities exist on the cloud version discover the limitation late, when redesign is expensive.

Failure 3: HDI container proliferation without governance

In multi-team projects, HDI containers multiply when there is no naming convention or ownership model. Each container is a DTC/RTC pair with a dedicated schema owner. Uncontrolled proliferation makes it impossible to track what is deployed where and complicates upgrade sequencing. Establish the HDI container governance model at project kick-off.

Failure 4: Connection pool sizing omitted from non-functional requirements

CAP for Java defaults to a HikariCP pool with a maximum of 10 connections. In production with hundreds of concurrent sessions, this causes connection exhaustion and cascading timeouts. Pool sizing — per service, per expected concurrent load — must appear in the requirements checklist and be validated in load testing before production cutover ( Connection pool sizing insight).

Failure 5: Data governance and classification delayed until after provisioning

When data sensitivity levels are not defined before integration pipelines are built, the team discovers mid-project that certain datasets cannot be placed in the selected region or require customer-managed encryption keys. Each discovery requires architectural rework. Data classification is a business responsibility — assign an accountable owner before design begins.

Failure 6: Workload isolation not designed for mixed OLTP/OLAP

Without workload class definitions, a long-running analytical query can consume all available threads and starve transactional processes. Projects that deploy mixed workloads without configuring workload classes will experience unpredictable latency spikes in production. Workload class design belongs in the requirements phase.

Failure 7: Budget approval deferred while development instances accrue cost

HANA Cloud credits accrue from instance start time. Development environments left running without stop/start automation generate unplanned cost. Confirm the stop/start policy for non-production instances, and ensure continuous-run cost is explicitly approved before provisioning.

FAQ

Q: Can we use SAP HANA Cloud for an S/4HANA on-premise extension project, or does it only apply to cloud deployments?

HANA Cloud is suitable for S/4HANA extension scenarios regardless of deployment model (Public Cloud Edition, Private Cloud Edition, or on-premise). Extensions built with CAP on BTP can federate or replicate data from an on-premise S/4HANA system via Cloud Connector and SAP HANA smart data integration. The key prerequisite is network connectivity between the BTP subaccount and the on-premise landscape, which requires security team approval before project design is finalized.

Q: How is HANA Cloud licensing different from on-premise HANA, and what should I communicate to the CFO?

On-premise HANA uses a traditional upfront license purchase plus annual maintenance, with the customer owning all infrastructure. HANA Cloud uses a credit-based consumption model — no upfront license purchase, but ongoing credits accrue based on the size of the running instance. The practical message for finance: no large upfront capital expenditure, but the operating cost is perpetual and tied to instance size and run-time hours. Stopping non-production instances outside working hours reduces cost; right-sizing matters more than it does on-premise.

Q: When should we descope HANA Cloud from a project and use a different persistence option?

Descope HANA Cloud if the workload is pure object storage (unstructured files only, no SQL queries), if the budget does not support ongoing credit consumption, or if the use case can be fully served by a standard database in the target cloud provider. HANA Cloud’s value is highest when the workload combines transactions, analytics, and multi-model data in a single system. If the project is purely analytical with no transactional requirement and petabyte-scale volumes, evaluate whether SAP HANA Cloud Data Lake alone is sufficient and more cost-effective.

Q: How do I document the HANA Cloud requirement properly for a solution proposal or blueprint?

The requirement document should specify: (1) workload type (OLTP, OLAP, or mixed), (2) expected data volume at go-live and 12-month growth, (3) concurrency profile (peak simultaneous users and query types), (4) data residency and encryption requirements, (5) HA/DR tier required (backup-only vs. system replication), and (6) multitenancy model (single-tenant vs. native multi-tenant with schema separation). These six parameters map directly to the sizing, region, and configuration decisions that determine both technical fit and cost.

Q: Is SAP HANA Cloud the same as SAP S/4HANA Cloud?

No. SAP HANA Cloud is the database and data platform service within SAP BTP. SAP S/4HANA Cloud is the ERP application (successor to SAP ECC), which runs on top of an SAP HANA database. The two are related — S/4HANA Cloud uses HANA internally — but they are different products with different licensing, administration, and integration points. In the BTP context, “HANA Cloud” means the standalone database service, not the ERP.

Q: What administration tools are available for HANA Cloud, and do we need separate training?

HANA Cloud uses three layered tools: SAP HANA Cloud Central (instance-level administration shared with Analytics Cloud and Data Lake), SAP HANA Cockpit (database-level monitoring and administration), and SAP HANA Database Explorer (SQL query execution and catalog inspection). Cockpit and Database Explorer functionality is being progressively integrated into HANA Cloud Central ( Admin Tools). Administrators familiar with on-premise HANA Cockpit will find the cloud equivalents recognizable; the main learning curve is BTP-level access management (role collections, subaccount structure).

Summary

Hierarchy tree summarizing HANA Cloud as the BTP data foundation with key architectural decisions branching out

SAP HANA Cloud is the persistence and compute foundation for the SAP BTP Data and Analytics domain. Its in-memory column-store engine, multi-model support (relational, graph, spatial, JSON, vector), native multitenancy, and SAP-managed HA/DR make it production-ready for a wide range of workloads. The shift from on-premise HANA to HANA Cloud is primarily operational: SAP manages infrastructure, backups, and patching, while the customer’s responsibility moves to sizing, data governance, HDI container lifecycle, and connection pool management. The most common project failures happen at the requirements stage — when region, data residency, and workload class decisions are deferred. Treat HANA Cloud provisioning decisions as architectural commitments, not configuration details.

IDCategoryComponentScope
BTP-C01OverviewData and AnalyticsBTP-C01: Data and Analytics: Overview and Capability Map
BTP-C02Architecture and UseHANA CloudBTP-C02: HANA Cloud: Architecture and Use (this article)
BTP-C03Architecture and UseSAP DatasphereBTP-C03: SAP Datasphere: Architecture and Use
BTP-C04Architecture and UseSAP Analytics CloudBTP-C04: SAP Analytics Cloud: Architecture and Use
BTP-C05Architecture and UseData IntegrationBTP-C05: Data Integration: Architecture and Use
BTP-C06Architecture and UseData GovernanceBTP-C06: Data Governance: Architecture and Use