Can I connect IBM Db2 to iDBQuery?
Yes. iDBQuery connects to IBM Db2 as a standard SQL database, so you can ask questions in plain language and get cited answers straight from your Db2 tables. It reads Db2 through its database connector using the connection details and read-only credentials you provide.
IBM Db2 (on Linux/Unix/Windows, z/OS, or Db2 on Cloud) is a mature relational database, and iDBQuery treats it as a standard SQL source rather than a bespoke branded connector. You point iDBQuery at Db2, it introspects the schema, and its semantic layer decodes cryptic column and table names so you don't have to.
From there you just ask:
- Plain-language questions like 'total settled claims by region last quarter' — iDBQuery writes the SQL, runs it read-only against Db2, and returns a number, chart, or table.
- Cited answers — every figure links back to the exact Db2 rows it came from, so nothing is a black box.
- One live model — join your Db2 data with spreadsheets, a Postgres database, or a REST API in a single answer, with no ETL or staging warehouse.
A typical example: a bank runs core ledgers on Db2 for z/OS. An analyst asks 'which branches missed their fee target this month?' and gets a ranked table in seconds, each row traceable to the Db2 record.
Because iDBQuery can query in place and deploy in your own VPC, on-prem, or air-gapped, your Db2 data never has to leave your network. Give it a dedicated read-only user and it can never write or delete.
Updated 2026-06-22