What does iDBQuery mean by one live queryable model?
One live queryable model means iDBQuery joins all your sources — databases, spreadsheets, PDFs and APIs — into a single thing you can question, without copying them into a warehouse. It reads each source in place and queries them together, so one question can span everything you've connected at once.
Normally, asking one question across many systems means building a data warehouse: extracting data, transforming it, loading it into a central store, and maintaining pipelines so it stays fresh. That's weeks of work and ongoing upkeep.
iDBQuery's one live queryable model skips all of that. When you connect a source, iDBQuery learns its structure and makes it part of a unified model you can query as if it were one place — but the data stays where it lives. Behind the scenes it queries each source in place and combines the results.
What this gives you:
- One question, many sources — join a MySQL table to an Excel sheet to a PDF table in a single ask
- Always live — answers reflect the current state of your sources, not a stale nightly copy
- No pipelines — nothing to build, schedule, or babysit
- No duplication — your data isn't hauled into a separate store you then have to secure
The model is also smart about meaning: a semantic layer maps cryptic column names to plain concepts, so the model understands what "acct_dt_flg" actually represents. The result feels like one tidy database, even when it's really a dozen messy sources.
Updated 2026-06-22