Guides

SAP HANA

Suggest Edits

Connector Details

Connector AttributesDetails
NameSAP HANA
DescriptionSAP HANA (High-Performance Analytic Appliance) is an advanced, in-memory database platform developed by SAP that combines transactional and analytical data processing capabilities. Leveraging its unique architecture, SAP HANA stores data in-memory rather than on traditional disk storage, allowing for lightning-fast data retrieval and processing. This technology enables real-time analytics and applications to process large volumes of data with unprecedented speed and efficiency. SAP HANA supports various data types and sources, offering robust features for data integration, management, and analytics, making it a cornerstone for enterprises seeking to harness the power of big data and drive digital transformation.
Connector TypeClass D

Features

Feature NameFeature Details
Load StrategiesFull Load , Incremental Load
Metadata ExtractionSupported
Data AcquisitionSupported
Data PublishingNot Supported
Automated Schema Drift HandlingSupported

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringSAPHANA Connector
UsernameStringService account username
PasswordStringService account password
Server NodeStringserver name.clientname.org:30015
Bronze Schema (Optional)String
Silver Schema (Optional)String

Connector Specific Configuration Details

  1. SAP HANA connector has optional values such as Bronze Schema and Silver Schema

  2. Create a service account and grant it read access to the desired objects to be extracted using the connector.

  3. Install the ODBC driver from SAP on the Integration Runtime (IR) used for connecting to the SAP source. The ODBC driver is provided by the SAP system administrator.

  4. Configure firewall rules and whitelist the Integration Runtime (IR) IP address in SAP HANA is important step to make this connector work.

Connection attrbutes are provided below 
Username : Service account user name
Password : Service account password
Server Node : SAP HANA server name

Screenshot To Use Connector

Updated 12 days ago