Can I connect SAP HANA to iDBQuery?

Yes. iDBQuery connects to SAP HANA as a standard SQL database, so you can query your HANA tables and views in plain language and get cited answers. It reads HANA through its database connector using the connection details and read-only credentials you provide.

SAP HANA is an in-memory columnar database, and iDBQuery treats it as a standard SQL source through its database connector rather than a bespoke SAP-branded integration. You provide the connection details, iDBQuery introspects the schema, and its semantic layer helps translate HANA's technical table and column names into terms your team actually uses.

Then it just works like the rest of iDBQuery:

  • Plain-language questions against your HANA tables, calculation views, and analytic views.
  • Cited answers — each figure traces back to the exact HANA rows, so there's no guesswork.
  • One live model — combine HANA data with a CSV budget, a Postgres app database, or a REST API in a single answer, with no pipeline to build.

Example: a manufacturer runs operational reporting on SAP HANA. A plant manager asks 'which materials went below safety stock last week?' and gets a ranked list in seconds instead of raising a report request.

Because SAP data is usually sensitive and heavily governed, iDBQuery can query in place and deploy inside your own VPC, on-prem, or fully air-gapped, so nothing leaves your walls. A dedicated read-only user ensures iDBQuery can read but never modify your HANA data. It reads the tables and views you expose — you decide the scope.

Updated 2026-06-22