Skip to content

Microsoft SQL Server analytics, without the export

SQL Server is where the ERP, the finance system and most line-of-business data sit in companies built on Microsoft.

Free plan. No credit card required.

What teams ask of Microsoft SQL Server

Typed the way you would say them. Each answer comes back with its chart, its numbers and the SQL that produced them, so it can be checked before anyone acts on it.

  • “What is AR ageing by customer and by business unit right now?”
  • “Which cost centres are over budget, and by how much?”
  • “How does this period compare with the same period last year?”
  • “Which transactions were posted outside the normal close window?”
  • “Which customers account for most of the revenue and most of the overdue balance?”

What it is combined with

The questions that matter rarely live in one system. An agent can hold more than one source: ask a question that spans them and Supaboard queries each one, then combines the results, so the comparison happens when the question is asked rather than in a pipeline project that has to be scoped first.

  • Snowflake — the ledger in the ERP, against the finance marts built from it.
  • PostgreSQL — what finance booked, against the accounts the product shows as active.

How the connection works

Microsoft SQL Server is one of the 12 databases and warehouses you can connect yourself. It connects directly and is queried when a question is asked, with nothing copied ahead of time, so setting up a first analysis takes about 5 minutes.

SSL is on by default, and the form takes a database and a schema so a connection can be scoped to one part of the server rather than all of it. Finance data is usually where the deployment question comes up: on Enterprise the whole platform runs inside your own VPC. Supaboard receives no platform data; inference follows the model endpoint you configure.

  • Database and warehouse queries are read-only. Changes to connected apps require your approval.
  • Credentials are encrypted at rest, scoped per workspace, never logged and never returned to a client.
  • On the Enterprise plan the whole platform runs inside your own VPC. Supaboard receives no platform data; inference follows the model endpoint you configure. See Enterprise.
  • A free plan with no credit card, then from $19 per editor per month — see pricing.

More sources

Other connectors with a guide:

Also in Databases & warehouses: PostgreSQL, MySQL, Oracle, MongoDB, Supabase, Snowflake, BigQuery, AWS Redshift, Databricks, ClickHouse, MotherDuck. See how files, databases and warehouses connect.

Weighing this against another tool? See the sourced comparison of 14 BI platforms, or what an AI data analyst does with a connection like this one.

Databases

Ask your first question from Microsoft SQL Server

Start FreeBook a 30-minute demo

Free plan. No credit card required.