Do I need a data warehouse to use iDBQuery?
No — you do not need a data warehouse to use iDBQuery. It connects directly to your databases, spreadsheets, files and APIs and builds one live queryable model across them, so there is no warehouse to build, no ETL pipelines and no data-engineering project first.
One of the most common blockers to analytics is 'first we need a warehouse'. iDBQuery removes that step.
- Connect what you already have. Point iDBQuery at MySQL, PostgreSQL, MongoDB, Excel, CSV, Google Sheets, PDFs, folders of files, REST APIs or an existing warehouse.
- It federates for you. iDBQuery builds one live model across those sources, so a single question can join a database with a spreadsheet and an API without moving anything.
- No ETL or pipelines. Because it queries in place, there is nothing to extract, transform and load, and nothing to keep in sync with brittle jobs.
That means a small team with a production database and a few spreadsheets can start getting cited answers today — no cloud warehouse bill, no pipeline maintenance, no waiting on data engineering. If you do already have a warehouse, iDBQuery happily connects to it as one more source and queries it alongside the rest. For example, you could answer 'orders from our Postgres database vs targets in this spreadsheet' in one question. iDBQuery meets your data where it is, so you get value before any warehouse project would even be scoped.
Updated 2026-06-22