What is a one live model?
A one live model is a single, always-current queryable layer built across all your connected sources at once, so one question can span databases, spreadsheets, documents and APIs together. iDBQuery builds this model without copying your data into a warehouse or running ETL pipelines.
Most analytics setups force you to first move everything into one place — a warehouse — before you can ask a question that touches more than one system. A one live model skips that step. iDBQuery reads the structure of each source you connect and stitches them into a single virtual model you can query as if it were one database.
"Live" is the key word. The model reflects the current state of your sources rather than a stale nightly copy, so the answer you get is the answer as of now.
With a one live model you can:
- Join across systems — ask a question that combines, say, a sales database, a finance spreadsheet and a PDF contract in one go.
- Skip the pipeline — no warehouse project, no ETL jobs to build and maintain before you get value.
- Stay current — query against the latest data, not last night's snapshot.
Under the hood, iDBQuery uses data federation to query each source in place and bring the pieces together, while a semantic layer helps it understand what each table and column actually means. The result is that you connect your sources once and immediately ask cross-source questions in plain language — no modelling project required.
Updated 2026-06-22