Data Ingestion
SAP HANA
Data Ingestion
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
| Parameter | Required | Description |
|---|---|---|
| Name | Yes | A unique identifier for your SAP HANA source |
| Host | Yes | The hostname or IP address of your SAP HANA server |
| Port | Yes | The port number on which SAP HANA is running (default: 30015) |
| User | Yes | Username with appropriate permissions to access the database |
| Password | Yes | Password for the specified user |
Required Permissions
The SAP HANA user account needs the following permissions:
SELECT- For reading data from tables and viewsCATALOG 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:
- Create extracts to specify which tables or views to ingest
- Configure scheduling for recurring extracts
- Integrate the source into your data pipelines
For more information about working with extracts and pipelines, refer to their respective documentation sections.