> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datazone.co/llms.txt
> Use this file to discover all available pages before exploring further.

# SAP HANA

> SAP HANA is an in-memory, column-oriented, relational database management system.

# Overview

SAP HANA is a high-performance in-memory database platform that provides real-time analytics and transaction processing capabilities. Datazone offers native integration with SAP HANA, enabling you to efficiently extract and process data from your SAP HANA instances.

## Connection Parameters

Set on the source when you create it. Names match the API and CLI payload.

<ParamField path="name" type="string" required>
  **Name** — a unique identifier for your SAP HANA source.
</ParamField>

<ParamField path="host" type="string" required>
  **Host** — hostname or IP address of your SAP HANA server.
</ParamField>

<ParamField path="port" type="string" required>
  **Port** — port the SAP HANA SQL interface listens on. Typically `30015`.
</ParamField>

<ParamField path="user" type="string" required>
  **User** — database username with read permission on the tables and views you intend to extract.
</ParamField>

<ParamField path="password" type="string" required>
  **Password** — password for the specified user. Stored encrypted.
</ParamField>

## Extract Parameters

Set per extract, in `source_parameters`. See [Shared Extract Parameters](/reference/sources/overview#shared-extract-parameters) for `mode`, `replication_key`, and `schema_mapping`.

<ParamField path="table_name" type="string" required>
  **Table Name** — the table or view to extract. Since the source carries no schema, qualify it here as `SCHEMA.TABLE` — for example `SAPABAP1.MARA`.
</ParamField>

<ParamField path="batch_size" type="integer" default="1000000">
  Rows fetched and written per batch.
</ParamField>

<ParamField path="select_clause" type="string" default="*">
  Columns to read, as a comma-separated list.
</ParamField>

<ParamField path="filter_clause" type="string">
  Row filter pushed down to SAP HANA, written without the `WHERE` keyword — for example `MANDT = '100'`.
</ParamField>

## Required Permissions

The SAP HANA user account needs the following permissions:

* `SELECT` - For reading data from tables and views
* `CATALOG READ` - For accessing system views and metadata

## Limitations

Be aware of the following limitations when working with SAP HANA sources:

* Supported SAP HANA versions: 2.0 and above

## Next Steps

After configuring your SAP HANA source:

1. Create extracts to specify which tables or views to ingest
2. Configure scheduling for recurring extracts
3. Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.