hdbcli

What it is and what it does

hdbcli is the official SAP HANA Python client, implementing the PEP 249 database API standard to enable Python applications to connect to and query SAP HANA databases. It supports both SAP HANA Cloud (port 443 with automatic encryption) and on-premise deployments (port 3NN13/3NN15), and provides cursor-based query execution with parameterized statement binding (both positional and named parameters). The driver is distributed as compiled wheels for multiple platforms and architectures, with no additional runtime dependencies beyond Python itself.

The package is production-stable and actively maintained, with support for modern Python versions. A key deviation from PEP 249 is that autocommit is enabled by default rather than disabled, which may affect transaction handling expectations. It is licensed under SAP's proprietary Developer License Agreement, making it suitable for development and evaluation but requiring explicit license review for production or commercial use.

Use it for:

• Extract data from SAP HANA Cloud or on-premise databases for analytics, reporting, or ETL pipelines in Python applications.
• Build Python-based data integration layers that read from or write to SAP HANA as part of enterprise data workflows.
• Develop administrative or monitoring scripts that connect to HANA instances to execute DDL/DML operations programmatically.
• Prototype or test SAP HANA applications locally before deployment to production SAP environments.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

A PEP 249-compliant Python database driver for connecting to and querying SAP HANA databases, supporting both cloud and on-premise instances with parameterized queries and cursor-based result handling.

Yes, if you need to connect Python to SAP HANA and accept the proprietary license terms. The driver is stable, actively maintained, and has no external dependencies. However, verify license compliance for your use case (development vs. production) before committing to production deployments, and confirm Python version compatibility with your environment.

Install

hdbcli on PyPI

pip install hdbcli

uv add hdbcli

poetry add hdbcli

Installing hdbcli

Before you install

Medium install friction due to compiled binary wheels for specific platforms (macOS, Linux, Windows). Actively maintained with a recent release 36 days ago. No runtime dependencies simplifies integration.

License in practice

Licensed under SAP Developer License Agreement with proprietary terms. Use is restricted to development and subject to SAP's product use and support terms for on-premise customers. Commercial or production use requires explicit license compliance review.

Quickstart

pip install hdbcli

from hdbcli import dbapi
conn = dbapi.connect(address="hana-host", port=3MM, user="user", password="pass")
cursor = conn.cursor()
cursor.execute("SELECT * FROM table")
for row in cursor:
    print(row)

Requires a reachable SAP HANA instance (cloud or on-premise) with valid credentials and appropriate port access (443 for cloud, 3NN13/3NN15 for on-premise).

Verify before relying

• Whether the SAP Developer License Agreement permits use in production environments or only development.
• Specific Python version minimum requirement (classifiers list 3.10–3.14 but requires_python is unspecified).
• Whether autocommit-by-default behavior differs from PEP 249 in ways that affect existing code patterns.

Package facts

Evidence: hdbcli-2.29.25-cp310-abi3-macosx_13_0_arm64.whl; hdbcli-2.29.25-cp310-abi3-macosx_13_0_x86_64.whl; hdbcli-2.29.25-cp310-abi3-manylinux2014_aarch64.whl; hdbcli-2.29.25-cp310-abi3-manylinux2014_ppc64le.whl; hdbcli-2.29.25-cp310-abi3-manylinux2014_x86_64.whl; hdbcli-2.29.25-cp310-abi3-musllinux_1_2_x86_64.whl; hdbcli-2.29.25-cp310-abi3-win32.whl; hdbcli-2.29.25-cp310-abi3-win_amd64.whl

Keywords: SAP, HANA, client, in-memory, database, SQL, cloud, business, application, intelligent, enterprise, AI, artificial, intelligence, analytics, experience

Tags

More Python Modules packages