How to invoke SAP HANA stored procedures from Data Services
With SAP HANA, logic is often written in stored procedures as they give various advantages over writing plain SQL.
- They are pre-compiled which gives a performance gain
- Complex logic can be encapsulated in an easy to consume form
- They support writing logic in various languages
- Certain features are only supported in stored procedures (CE functions for example)
Data Services has support for HANA stored procedures. This document shows how to invoke HANA stored procedures with various signatures.