- Source
- Databases
- Alpha
Move MS SQL Server data anywhere it matters.
Move MS SQL Server data into your warehouse, lake or AI app.
Source
MS SQL Server
Snowflake
BigQuery
Postgres
Databricks
Claude
- Destinations
- 50+
- Certified support
- 5.1.1
Overview
What is the Airbyte MS SQL Server connector?
The Airbyte MS SQL Server connector extracts data from MS SQL Server and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.
- 01
Sync to your warehouse
Land MS SQL Server data in 50+ destinations on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
Change data capture
Stream inserts, updates and deletes straight off the MS SQL Server write-ahead log.
- 04
One authorization
Authenticate MS SQL Server once and Airbyte keeps every scheduled sync running on it.
Setup
Live in three steps
Get your MS SQL Server credentials from the vendor dashboard or developer settings.
Configure the source in Airbyte with the required connection fields.
Pick a destination, choose streams, set full refresh or incremental, and schedule syncs.
Configuration fields
| Field | Type | Description |
|---|---|---|
| database* | string | The name of the database. |
| host* | string | The hostname of the database. |
| port* | integer | The port of the database. |
| replication_method* | object | Configures how data is extracted from the database. |
| additionalProperties | object | Not documented. |
| check_privileges | boolean | When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. |
| checkpoint_target_interval_seconds | integer | How often (in seconds) a stream should checkpoint, when possible. |
| client_id | string | Application (client) ID of a Microsoft Entra ID service principal. When provided together with Client Secret, Entra ID authentication is used instead of username and password. |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
Related connectors
FAQ
MS SQL Server connector questions
What data can I sync from MS SQL Server with Airbyte?
The MS SQL Server connector syncs the tables and events published in Airbyte docs.
Does the MS SQL Server connector support incremental sync?
Yes. The MS SQL Server connector supports incremental sync on selected streams, and full refresh on every stream.
Where can I run the MS SQL Server connector?
Run the MS SQL Server connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start syncing MS SQL Server in minutes.
Free 14-day trial. No credit card needed.