Skip to main content

SAP HANA

Category: OData · 🏅 Official partner

SAP HANA in-memory database. Official partner. Connects via OData and a direct ODBC/BDC connection.

Connection requirements​

No additional connection details needed in this setup.

Where to find these​

SAP HANA connects via a direct ODBC connection or via an XS OData service.

  • Host and SQL port — For an ODBC connection you need the HANA server hostname and the SQL port. The SQL port follows the pattern 3<instance>15 (e.g. 30015 for instance 00); for a tenant database (MDC) this is 3<instance>13 for the system DB or a tenant-specific port. A SAP/HANA administrator can confirm these.
  • Database user — A HANA DB user with password and read authorization (SELECT) on the relevant schemas/objects.
  • OData alternative — If data is published through an XS OData service, use the service URL https://<host>:<port>/<path>.xsodata.

Official docs: Connect to SAP HANA via ODBC (SAP Help Portal).

See also: Integration catalog · All data source requirements · Integrations — overview