Explore with AI
ChatGPTClaudeGeminiPerplexity
Microsoft SQL Server
§ Connector · Popular
Microsoft SQL Server

Connect Microsoft SQL Server to your Definite lakehouse in minutes.

Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.

Have multiple Microsoft SQL Server accounts? Analytics across multiple Microsoft SQL Server accounts →

§ What you get

Everything Microsoft SQL Server exposes, modeled and queryable.

Extracts data from Microsoft SQL Server databases, discovering tables and views in the specified database and syncing them via SQL queries. Supports full and key-based incremental replication, batch JSONL output, stream maps, and optional schema flattening. Handles MSSQL-specific types (NUMERIC/DECIMAL, MONEY/SMALLMONEY, BIT, ROWVERSION/TIMESTAMP, VARBINARY/BINARY/IMAGE, XML). Enables centralizing operational and transactional SQL Server data for analytics, reporting, and data warehousing.

Sync cadence
Hourly or faster
CDC
Native where supported
Auth
OAuth / API key
Row-level security
Yes

Tables & streams

12 objects
user

Core identity records representing individual end-users of the application; supports cohort analysis, activation funnels, retention tracking, and user-level KPI attribution.

account

Organization or company entities that group users under a single billing and permissions boundary; enables account-level revenue analysis, expansion tracking, and segmentation.

subscription

Recurring billing agreements linking accounts to plans; drives MRR/ARR calculations, churn analysis, upgrade/downgrade tracking, and renewal forecasting.

invoice

Billing documents issued for subscription periods or one-time charges; supports revenue recognition, collections analysis, and accounts-receivable reporting.

payment

Individual monetary transactions tied to invoices; enables cash-flow analysis, payment-method mix reporting, failure-rate tracking, and reconciliation.

order

Purchase transactions capturing line items, quantities, and totals; powers GMV reporting, average-order-value analysis, and fulfillment metrics.

product

Catalog items or SKUs available for purchase or subscription; supports product-mix analysis, attach rates, pricing optimization, and inventory tracking.

plan

Pricing tiers or packages that define feature sets and billing amounts; enables plan-distribution analysis, upgrade-path modeling, and pricing experiments.

event

Timestamped application activities such as clicks, page views, and API calls; drives engagement scoring, funnel analysis, and behavioral segmentation.

session

Grouped sequences of user events bounded by inactivity timeouts; supports session-duration analysis, bounce-rate tracking, and conversion-path modeling.

team

Collaborative groups within an account that share workspaces or permissions; enables team-level adoption metrics, seat-utilization analysis, and collaboration tracking.

project

Discrete workstreams or initiatives created by users or teams; supports project-velocity reporting, resource-allocation analysis, and feature-usage attribution.

Authentication

Connects using your SQL Server username and password, or uses Azure Entra ID (DefaultAzureCredential) to obtain an access token for Azure SQL

Requirements

Requires a Microsoft SQL Server account to connect.

Analyze with Fi

Operational data, performance metrics, and business insights.

Domainsgeneral_dataoperations
§ How it works

Three steps. One afternoon.

01
Connect

Authenticate Microsoft SQL Server in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.

definite connect microsoft-sql-server
02
Sync

We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.

→ microsoft sql server.raw (synced hourly)
03
Query

SQL, dashboards, or ask Fi in plain English. Your Microsoft SQL Server data lives next to every other source — ready to join.

SELECT * FROM microsoft_sql_server.*
*
Don't see yours?
Any API becomes a Definite connector in minutes.

Build your own with the Definite SDK, or ask us — we add new connectors every week.

Request a connector

Your answer engine
is one afternoon away.

Book a 30-minute call. We'll build your first dashboard on the call — or you can stop paying us.