Can I connect Azure Synapse Analytics to iDBQuery?

Azure Synapse Analytics exposes a SQL endpoint, and iDBQuery connects to it as a standard SQL data warehouse through its warehouse/database connector — not a bespoke Microsoft-branded integration. You provide the Synapse SQL endpoint, database, and credentials, and iDBQuery introspects the schema.

What you get:

• Plain-language questions over your Synapse tables and views, with iDBQuery writing the SQL for you.
• Cited answers — every figure links to the exact rows in Synapse.
• Query in place — iDBQuery runs against Synapse rather than copying it out, so governed data stays where it is.

Because Synapse warehouses hold curated, enterprise-scale data, iDBQuery pushes aggregation down to Synapse and returns only the result — a number, chart, or live dashboard — keeping answers responsive even over large tables.

Example: a retailer's central warehouse lives in Synapse. A regional manager asks 'which stores are below plan this quarter and by how much?' and gets a ranked, cited table in seconds instead of waiting for a BI request.

You can also blend Synapse with an operational database, a spreadsheet forecast, or a REST API in a single answer — one live model across sources. Deploy iDBQuery in your own Azure VPC and use a read-only account so access stays inside your network and strictly read-only.