- Destination
- Databases
- Generally available
Connect MS SQL Server data with any data source.
Load data from any Airbyte source into MS SQL Server on the schedule you choose.
- Sources
- 590+
- Certified support
- 2.2.23
Overview
What is the Airbyte MS SQL Server connector?
The Airbyte MS SQL Server connector loads data from 590+ Airbyte sources into MS SQL Server, with full refresh and incremental sync on a schedule you control.
- 01
Load from any source
Move data into MS SQL Server from 590+ Airbyte sources on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
Cloud or self-hosted
Run the MS SQL Server connector on Cloud, OSS, Hybrid.
Setup
Live in twelve steps
Aggregate Data into Bulk Files: Data is written to Blob Storage in batches, reducing overhead.
Perform Bulk Ingestion: MSSQL uses BULK INSERT to directly load these files, typically resulting in faster performance compared to conventional row-by-row inserts.
A Microsoft SQL Server Instance - Compatible with on-premises SQL Server or Azure SQL Database.
Azure Blob Storage Account - A storage account and container (e.g., bulk-staging) where data files will be placed.
Permissions - Blob Storage: ability to create, read, and delete objects within the designated container. - MSSQL: ability to create or modify tables, and permission to execute BULK INSERT.
Create a Storage Account & Container - In the Azure Portal, create (or reuse) a Storage Account. - Within that account, create a container (e.g., bulk-staging) for staging your data files.
Establish Access Credentials - Use a Shared Access Signature (SAS) scoped to your container. - Ensure the SAS token or role assignments include permissions such as Read, Write, Delete, and List.
(Optional) Create a Master Encryption Key If your environment requires a master key to store credentials securely, create one: sql CREATE MASTER KEY ENCRYPTION BY PASSWORD = '';
Create a Database Scoped Credential Configure a credential that grants MSSQL access to your Blob Storage using the SAS token: sql CREATE DATABASE SCOPED CREDENTIAL WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = '';
Create an External Data Source Point MSSQL to your Blob container using the credential: sql CREATE EXTERNAL DATA SOURCE WITH ( TYPE = BLOB_STORAGE, LOCATION = 'https://.blob.core.windows.net/', CREDENTIAL = ); You’ll reference when configuring the connector.
MSSQL Connection Details - The server hostname/IP, port, database name, and authentication (username/password).
Bulk Load Data Source - The name of the external data source you created (e.g., ).
Configuration fields
| Field | Type | Description |
|---|---|---|
| database* | string | The name of the MSSQL database. |
| host* | string | The host name of the MSSQL database. |
| load_type* | object | Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration. |
| port* | integer | The port of the MSSQL database. |
| schema* | string | The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". |
| ssl_method* | object | The encryption method which is used to communicate with the database. |
| user* | string | The username which is used to access the database. |
| jdbc_url_params | string | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). |
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 load into MS SQL Server with Airbyte?
Airbyte moves data from any supported source into MS SQL Server on a schedule you control, with full refresh and incremental sync where the destination supports it.
Does the MS SQL Server connector support incremental sync?
Yes. The MS SQL Server destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.
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 loading data into MS SQL Server in minutes.
Free 14-day trial. No credit card needed.