SAP HANA Database (hdb)


SAP HANA is an in-memory 1) database (db) that can be deployed:

  • on premise (on a machine)
  • or on demand (in the cloud)

Use case

Use case - Master Guide

  • Data Mart
  • Data Provisioning
    • Extraction-Transformation-Load (ETL) based data replication uses SAP Data Services (also called Data Services) to load relevant business data from SAP ERP to the SAP HANA database.
    • Smart Data Integration: SAP HANA smart data integration and SAP HANA smart data quality load data, in batch or real-time, into HANA (on premise or in the cloud) from a variety of sources using pre-built and custom adapters.
    • SAP HANA Direct Extractor Connection (DXC). provides SAP HANA with out-of-the-box foundational data models based on SAP Business Suite entities, and is a data acquisition method as well.
    • Log-Based Replication (SAP Replication Server)
    • Trigger-Based Replication (SAP Landscape Transformation Replication Server - SLT)
  • Smart Data Access: SAP HANA smart data access enables remote data to be accessed as if they were local tables in SAP HANA, without copying the data into SAP HANA.
  • Development Platform
  • Sap NetWeaver-Based App


A running SAP HANA system consists of multiple communicating processes (services).

Sap Hana Architecture

Index server

The main SAP HANA database management component is known as the index server, which contains:

  • the actual data stores
  • and the engines for processing the data.

The index server processes incoming SQL or MDX statements in the context of authenticated sessions and transactions.


The SAP HANA database has its own scripting language named SQLScript.

The SAP HANA Business Function Library (BFL) and the SAP HANA Predictive Analytics Library (PAL) functions can be called directly from within SQLScript.

SAP HANA also supports the development of programs written in the R language.

Preprocessor server

The index server uses the preprocessor server for analyzing text data and extracting the information on which the text search capabilities are based.

Name server

The name server owns the information about the topology of SAP HANA system. In a distributed system, the name server knows where the components are running and which data is located on which server.


SAP HANA Extended Application Services (XS) are a set of Hana embedded services for Web-based applications:

  • a lightweight web server,
  • configurable OData support (declarative way to present the data model),
  • server-side JS execution
  • and full access to SQL and SQLScript.

The SAP HANA XS server provides:

  • SAP HANA Extended Application Services
  • also system services (The search service is an example of such a system application).


Sap Hana Components

Development Language

Sap Hana Developement Language

Documentation / Reference

All data is available in main memory
Task Runner