SAP HANA Snap Pack

Overview

SAP HANA is an in-memory data platform for processing high volumes of operational and transactional data.

Use Snaps in this Snap Pack to:
  • Execute SQL statements to delete, update, select, or insert data within a specified table.
  • Invoke stored procedures with parameters from input documents.
  • Perform bulk operations with batch processing support.
  • Create and manage database tables dynamically.
The Snap Pack contains the following Snaps:
  • SAP HANA - Delete: Executes an SQL DELETE statement to remove records from a SAP HANA table based on the configured properties.
  • SAP HANA - Execute: Executes arbitrary SQL statements (such as SELECT, INSERT, UPDATE, DELETE) against a SAP HANA database.
  • SAP HANA - Insert: Executes an SQL INSERT statement using the input document's keys as columns and its values as the values to insert.
  • SAP HANA - Select: Fetches data from a SAP HANA database by specifying a table name and configuring the connection.
  • SAP HANA - Stored Procedure: Executes a stored procedure in the SAP HANA database and writes any parameters or results to the output view.
  • SAP HANA - Table List: Outputs a list of tables in a SAP HANA database in topological order based on foreign key dependencies.
  • SAP HANA - Update: Executes an SQL UPDATE statement for each input document to update records in a SAP HANA table.
  • SAP HANA - Upsert: Inserts or updates records in a SAP HANA table using the MERGE statement, based on the specified key columns.

Supported versions

This Snap Pack is tested against SAP HANA version 2.00.040.00.1553674765.