Skip to main content

​
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.
​
string
required
Name — a unique identifier for your SAP HANA source.
​
string
required
Host — hostname or IP address of your SAP HANA server.
​
string
required
Port — port the SAP HANA SQL interface listens on. Typically 30015.
​
string
required
User — database username with read permission on the tables and views you intend to extract.
​
string
required
Password — password for the specified user. Stored encrypted.

​
Extract Parameters

Set per extract, in source_parameters. See Shared Extract Parameters for mode, replication_key, and schema_mapping.
​
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.
​
integer
default:"1000000"
Rows fetched and written per batch.
​
string
default:"*"
Columns to read, as a comma-separated list.
​
string
Row filter pushed down to SAP HANA, written without the WHERE keyword — for example MANDT = '100'.

​
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.