How many data sources can I connect to iDBQuery?
You can connect many sources — there is no small fixed cap, and iDBQuery is designed to unify databases, spreadsheets, files and APIs together. It builds one live queryable model across all of them, so a single question can span many sources at once.
iDBQuery is built for the reality that answers live across many systems, not one, so connecting multiple sources is the core use case rather than an edge case.
- Mix source types freely. Databases, warehouses, MongoDB, Excel, CSV, Google Sheets, PDFs, folders of files and REST APIs can all be connected together.
- One live model. iDBQuery federates them into a single queryable model, so you are not switching tools per source.
- Cross-source questions. A single question can join, say, a production database, a finance spreadsheet and a marketing API at once.
The practical limit is your environment and access, not a small hard cap baked into the product — organisations connect anything from a couple of sources to a wide estate of systems. For example, an operations team might unify an orders database, a warehouse-management export, a supplier API and a costs spreadsheet, then ask 'which suppliers caused the most late deliveries this quarter, and what did it cost?' in one go. Because each figure is cited back to whichever source it came from, more sources means more coverage without losing traceability. So the answer to 'how many can I connect?' is: as many as you need to answer the question, unified into one place.
Updated 2026-06-22