SAP HANA - GS

Connect to SAP HANA and execute SQL queries

Execute Query

AI-generated

Summary

Execute a SQL query on a specified SAP HANA schema and return the query results in the chosen format.

Inputs

  • Schema (required) — Select the SAP HANA schema where the SQL query will be executed.
  • SQL Query (required) — Enter the SQL query to be run on the selected schema.
  • Return Mode (required) — Choose how to receive results: either each database row as a separate n8n item ('Rows as Items') or all database rows combined inside a single n8n item ('All Rows in One Item').

Output shape

a list of n8n items representing query results

If 'Return Mode' is 'Rows as Items', each database row is returned as an individual n8n item. If 'All Rows in One Item' is selected, a single n8n item containing the schema name, row count, and all rows as an array is returned. In case of query execution failure, and if 'Continue On Fail' is enabled, output will include items with error messages. Each input item is processed independently.

Links

Discussion