PlatformPlatformDelivered with a runtime rather than published. Nothing versions it independently and there is nothing to adopt or avoid — it is simply what the platform gives you.See every one →What this type is →by SAPby SAPPublished by SAP itself. A visible facet, never an input to a reading — a dormant official plugin reads exactly like a dormant independent one.See every one →
SAP HANA
SAP’s relational database platform, which stores application data and executes SQL and SQLScript in the database, available on-premise and as the managed service SAP HANA CloudSAP HANA CloudThe managed database under most of this: CAP's default target, the store Datasphere and Analytics Cloud sit on, and a service with plans and components.sap official, btp.
Stores application data and executes SQL and SQLScript in the database. On ABAP, AMDP procedures and functions execute SQLScript on SAP HANA. SAP HANA CloudSAP HANA CloudThe managed database under most of this: CAP's default target, the store Datasphere and Analytics Cloud sit on, and a service with plans and components.sap official, btp is the managed cloud service; SAP HANA also exists as an on-premise database.
Where it sits
Lives in
Provides
Database connectorsCAPBTPABAPDatabase connectorsConnecting an application’s data model and queries to a database, including the differences in supported queries, types and schema management between database implementations. Changing an existing schema belongs to [schema evolution](capability:schema-evolution).
Before choosing this
Conditions
PracticalFunctional boundary
For provisioning a managed database on BTP, see SAP HANA CloudSAP HANA CloudThe managed database under most of this: CAP's default target, the store Datasphere and Analytics Cloud sit on, and a service with plans and components.sap official, btp. Features differ between HANA versions; an on-premise deployment and a cloud instance are not interchangeable without compatibility checks.
LicenceSAP Developer License Agreement 3.2 CAP§ 1from Database connectorsA covered CAP application uses a connector to copy or persist SAP product data in a non-SAP database product.
- § 1 License. Productive customer applications are limited to SAP BTP or another SAP-licensed platform, and mass extraction to a non-SAP product is restricted except where solely required for SAP interoperability.
The connector itself does not decide the licence boundary. Section 1 makes the destination and purpose of extraction relevant, including the scoped exception for interoperability with an SAP product.
SAP Developer License Agreement 3.2 CAP →What it declares
Every artifact
- Type
- Platform
- Origin
- By SAP
Connections
Group by12 of 12 connections
NodeRelationBasis
Functional
Database connectorsDatabase connectorsConnecting a data model and its queries to a databaseSAP and community, narrow by design
provides
stated
provides Database connectors
Provides the SQL database applications connect to, including on-premise HANA deployments. SQLScript procedures and functions execute in the database; ABAP can manage and call them through AMDP.
“This tutorial demonstrates a migration from an on-premise SAP HANA database to an SAP HANA Cloud database.”“Currently, AMDP only supports database procedures and functions from the SAP HANA database.”
Connecting a data model and its queries to a database
Technical
Cloud ConnectorCloud ConnectorSAP's on-premises agent linking SAP BTP to customer-network systemssap official, btp
connected from
derived
connected from Cloud Connector
Connecting on-premises database or BI tools to [SAP HANA](artifact:sap-hana) databases running on SAP BTP.
“You can use the Cloud Connector to connect on-premises databases or BI tools to SAP HANA databases in the cloud.”
SAP's on-premises agent linking SAP BTP to customer-network systems
hxe-hibernate-google-app-enginehxe-hibernate-google-app-engineJava demo running Spring and Hibernate against SAP HANAsap official, btp
connected from
derived
connected from hxe-hibernate-google-app-engine
running the application's standard SQL and its geospatial queries against the HANA instance named in the JDBC connection properties of the Maven build.
“In addition to standard SQL queries this application also contains examples for geospatial queries. The geospatial queries are sent to the database via the HANA Hibernate Spatial dialect and executed by SAP HANA's geospatial engine.”“Edit the file `pom.xml` and adjust the properties `jdbc.username`, `jdbc.password`, `jdbc.host`, and `jdbc.port` to match the connection data of your SAP HANA instance.”
Java demo running Spring and Hibernate against SAP HANA
open-steamgateopen-steamgateLocal ABAP server serving /IWBEP/ OData v2 without an SAP systemindependent, abap
connected from
derived
connected from open-steamgate
`STG_DB=hana` selects HANA as the backend
Open SQL and AMDP bodies run against a real HANA through the eleven-method database seam, over the npm driver `hdb`
“Built 2026-09-18, `tools/hana-client.mjs`, `STG_DB=hana`. **Both suites reach”“a `DatabaseClient` (eleven methods, the npm
driver `hdb`, the same shape as `tools/duckdb-client.mjs`)”
Local ABAP server serving /IWBEP/ OData v2 without an SAP system
sap-knowledge-pipelinesap-knowledge-pipelinePython library turning OData or HANA records into chunked documentsindependent, btp
connected from
derived
connected from sap-knowledge-pipeline
the HANA adapter is configured; the OData client reaches a service instead
Reads the rows a recipe allow-lists by running a parameterised SELECT and streaming it in bounded pages, over a certificate-validated connection.
“Explicit, parameterized HANA `SELECT` datasets streamed in bounded pages.”“Certificate-validated SAP HANA connections through the optional SAP `hdbcli` driver.”
Python library turning OData or HANA records into chunked documents
s4hana-hana-audit-policiess4hana-hana-audit-policiesSQL templates for HANA audit policies of an S/4HANA tenantsap official, btp
needed by
derived
needed by s4hana-hana-audit-policies
the database the SQL files are run against: the HANA tenant the S/4HANA system uses.
“This project provides HANA audit policy templates for the SAP HANA database tenant used by SAP S/4HANA.”
SQL templates for HANA audit policies of an S/4HANA tenant
cds-cachingcds-cachingCAP caching plugin for query results and remote service responsesindependent, cap
optionally used by
derived
optionally used by cds-caching
When store: "hana" is selected.
Cache storage through keyv-hana; other store modes do not require this backend.
“SAP HANA | `"hana"` | Direct HANA connection | `keyv-hana`”
CAP caching plugin for query results and remote service responses
open-steamgateopen-steamgateLocal ABAP server serving /IWBEP/ OData v2 without an SAP systemindependent, abap
optionally used by
derived
optionally used by open-steamgate
`STG_DB=hana` selects HANA as the backend
the data layer when an AMDP body is to run where it belongs and `sy-dbsys` is to read HDB; the maintainer records it as an option and never the default, and HANA Express is the image the compose file starts
“An AMDP body runs where it belongs, on HANA, or portably on DuckDB. The SQLScript front end lowers to three dialects and refuses a silently wrong translation”“**HANA can be the data layer, as an option, and never as the default.**”
Local ABAP server serving /IWBEP/ OData v2 without an SAP system
sap-basis-opssap-basis-opsRunbook skills for Basis operations at the OS and database layerindependent, abap
optionally used by
derived
optionally used by sap-basis-ops
the system's database type (dbms_type) is hdb
running the HANA-specific start, stop, connect and status commands when the SID's database is SAP HANA
“| SAP HANA | `hdb` | [references/sap-hana.md](references/sap-hana.md) | ✅ complete |”
Runbook skills for Basis operations at the OS and database layer
Supply Chain RescueSupply Chain RescueCAP and SAPUI5 demo of recovery from a supply disruptionindependent, cap
optionally used by
derived
optionally used by Supply Chain Rescue
the Recall Rescue part is run
The trace: HANA Graph follows the defective cell lot through the battery genealogy, in openCypher over ADBC.
“HANA Graph in the SAP system A4H traces it through the battery genealogy (cell lot > module > pack > motorcycle > customer or storage location), over current links only.”“openCypher runs through ADBC (native SQL, classic ABAP only): AMDP rejects it, and ADBC is not released for ABAP Cloud.”
CAP and SAPUI5 demo of recovery from a supply disruption
hana-ml-sampleshana-ml-samplesCode examples for predictive and ML scenarios on SAP HANAsap official, btp
used by
derived
used by hana-ml-samples
the database environment the samples run against; its AFL component is what ships the Predictive Analysis Library the SQL examples call.
“In order to "run" the provided sample codes, a SAP HANA database environment is required with the AFL-component installed, which includes the Predictive Analysis Library (PAL).”
Code examples for predictive and ML scenarios on SAP HANA
hxe-hibernate-google-app-enginehxe-hibernate-google-app-engineJava demo running Spring and Hibernate against SAP HANAsap official, btp
used by
derived
used by hxe-hibernate-google-app-engine
the database the application stores its incident and address data in and runs its SQL and geospatial queries against.
“A SAP HANA database instance, for example, a SAP HANA, Express Edition instance which can be obtained via the”
Java demo running Spring and Hibernate against SAP HANA
Download
Learn more
Readings
- Bridging Python and SAP HANA: Inside the sqlalchemy-hana Open-Source DialectBridging Python and SAP HANA: Inside the sqlalchemy-hana Open-Source DialectA Devtoberfest 2026 data-track session (DAT-21) in which one of the maintainers of sqlalchemy-hana, the open-source SQLAlchemy dialect published in SAP's GitHub organisation, opens up what sits between Python and SAP HANA. It walks the five dialect classes that render statements, types, DDL, identifiers and sequences, and the HANA specifics they absorb: the FROM DUMMY a bare SELECT needs, a limit injected when only an offset is given, string compiled to NVARCHAR, and quoted case-sensitive identifiers against Python's lowercase. The rest covers schema migrations with Alembic on HANA's transactional DDL, the recently added async support and vector types, and that HANA Cloud and HANA 2 are supported while HANA 1 is not.SAP Developers, published 2026-09-29SAP Developers, YouTube — SAP Developers playlists
- Analyze and optimize ABAP Cloud model apps built on core data servicesAnalyze and optimize ABAP Cloud model apps built on core data servicesPerformance anti-patterns in data models built with ABAP CDS under ABAP Cloud applications, and the tools that find them: the abstract names ABAP cross trace, the SQL analyzer (PlanViz) in Visual Studio Code and the SAP HANA database explorer as what the session uses to follow a bottleneck from the application to the database. The anti-patterns are taken from real business applications, which is where the data modelling edge holds; which ones are shown is not in the abstract. A TechEd 2026 session (Tuesday 27 October, Berlin), presented by Ingo Braeuninger, Robert Werlich, Steffen Siegmund and Thomas Fiedler, written here from SAP's abstract; the recording is not yet published.SAP TechEd — session catalogue
Others providing
Compare all 22 on the Database connectors page →Database connectorsDatabase connectorsConnecting an application’s data model and queries to a database, including the differences in supported queries, types and schema management between database implementations. Changing an existing schema belongs to schema evolution.SAP and community, narrow by design
- SAP HANA CloudSAP HANA CloudThe managed database under most of this: CAP's default target, the store Datasphere and Analytics Cloud sit on, and a service with plans and components.sap official, btpManaged SAP HANA database service on BTP
- PostgreSQL on SAP BTP, hyperscaler optionPostgreSQL on SAP BTP, hyperscaler optionA managed PostgreSQL from the underlying hyperscaler — AWS, Azure, Google Cloud or Alicloud — consumed through a BTP service binding.sap official, btpManaged PostgreSQL from the hyperscaler via a BTP service binding
- com.sap.cds:cds-feature-hanacom.sap.cds:cds-feature-hanaThe CAP Java feature that wires a Maven application to SAP HANA Cloud, the production default among CAP's supported databases.sap official, capSAP HANA Cloud datasource for CAP Java applications
- com.sap.cds:cds-feature-jdbccom.sap.cds:cds-feature-jdbcConnects the CAP Java runtime to JDBC databases through the CDS4j JDBC runtime: H2 and SQLite, which capire names for local development and CI tests rather than enterprise use.sap official, capJDBC runtime for H2 and SQLite in CAP Java
- com.sap.cds:cds-feature-postgresqlcom.sap.cds:cds-feature-postgresqlThe CAP Java feature that wires a Maven application to PostgreSQL as its datasource beside SAP HANA, with limitations capire lists: schema evolution first, and no multitenancy or extensibility yet.sap official, capPostgreSQL datasource for CAP Java applications
- com.sap.cds:cds-services-bomcom.sap.cds:cds-services-bomThe Maven bill of materials for CAP Java, pinning every com.sap.cds module in a release, from the API and core runtime to the Spring Boot starters and the CQN engine, to the same version.sap official, capMaven bill of materials pinning CAP Java module versions
- @cap-js/db-service@cap-js/db-serviceThe base every CAP database service is built on: the shared query translation and pooling that SQLite, PostgreSQL and HANA specialise rather than reimplement.sap official, capBase service shared by CAP's SQLite, PostgreSQL and HANA services
- @cap-js/hana@cap-js/hanaThe HANA database service — the production default, on the same streamlined architecture as the SQLite and PostgreSQL services.sap official, capSAP HANA database service for CAP
- @cap-js/postgres@cap-js/postgresThe PostgreSQL database service — the production option for running CAP off HANA, sharing the base service with the other three.sap official, capPostgreSQL database service for CAP
- @cap-js/sqlite@cap-js/sqliteThe SQLite service, in memory during the inner loop — which is why a CAP project runs before anyone has provisioned a database.sap official, capSQLite database service for CAP, in memory during development
- cap-postgres-btp-connectivitycap-postgres-btp-connectivityConnects a CAP Node.js application to a PostgreSQL database that is not publicly reachable, tunnelling through BTP Connectivity and the Cloud Connector.independent, capTunnels CAP Node.js to a private PostgreSQL via Cloud Connector
- cds-mongodbcds-mongodbMongoDB as a native CAP database service, through Mongoose — CQN reads and writes, managed associations as ObjectId references, $expand resolved by populate, and cds deploy --to mongoose.independent, capMongoDB as a CAP database service through Mongoose
- @cds-pgroll/postgres@cds-pgroll/postgresThe destructive half of PostgreSQL schema evolution — DROP and RENAME, which CAP's own schema_evolution: alter will not perform — driven from the command line beside @cap-js/postgres.independent, capCLI for DROP and RENAME schema changes beside @cap-js/postgres
- @neoimpulse/cap-js-restore-model-defined-types@neoimpulse/cap-js-restore-model-defined-typesA CAP plugin that casts values back to the types the CDS model declares after a READ, for the entities you name, where the database driver returned them as strings.independent, capCAP plugin casting read values back to CDS model types
- @quadrio/cds-db2@quadrio/cds-db2A DB2 adapter for CDS, so a CAP model can be deployed to and served from DB2, last released July 2023 and still on npm while the repository it was published from has been deleted.independent, capDB2 adapter for CDS
- @sap/cds-hana@sap/cds-hanaThe SAP Cloud Application Programming Model's database adapter for SAP HANA, the package a CAP project adds to run its model on a SAP HANA database.sap official, capDatabase adapter for SAP HANA in CAP
- @sap/cds@sap/cdsThe CAP Node.js runtime, which compiles the CDS model, serves the services declared in it, answers generic requests before any handler runs, and loads every cds-plugin.sap official, capCAP Node.js runtime
- @sap/hana-client@sap/hana-clientSAP's own Node.js driver for SAP HANA: connect, run SQL and prepared statements, synchronously, through callbacks or as promises, over native client libraries npm installs per platform.sap official, btpSAP's Node.js driver for SAP HANA
- cds-pgcds-pgA PostgreSQL adapter for SAP CDS, built by the SAP Mentors community, which gave CAP a Postgres persistence option years before @cap-js/postgres shipped.independent, capPostgreSQL adapter for SAP CDS from the SAP Mentors community
- cap-snowflakecap-snowflakeA CAP database adapter for Snowflake with OData V4 support, which the maintainer marks as early development, so its contract is expected to move.independent, capCAP database adapter for Snowflake with OData V4 support
- cds-mysqlcds-mysqlA MySQL and MariaDB database adapter for CAP that connects to a database instance and translates incoming CQL/CQN requests to it; the repository the package declares has been deleted.independent, capMySQL and MariaDB database adapter for CAP
Details
Sources
Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.
Compatibility and provenance
discovered viaAdded by hand
first seen in the atlas
ecosystem and domainbtp, data-and-persistence
History in the atlas
- First seen.
For your agent
- Ref
artifact:sap-hana- JSON
- /artifacts/sap-hana.json
- MCP
- Connecting an agent