Fivetran supports SQL Server database as a destination. Integrating your SQL Server as a destination is the same as integrating it as a database.
See our SQL Server database documentation for more information.
Supported implementationslink
Fivetran supports connecting with four different SQL Server implementations:
IMPORTANT: We only support the Enterprise and Standard editions of SQL Server.
Type transformation mappinglink
The data types in your SQL Server database follow Fivetran’s standard data type storage.
We use the following data type conversions:
| Fivetran Data Type | Destination Data Type |
|---|---|
| BOOLEAN | BIT |
| SHORT | SMALLINT |
| INT | INTEGER |
| LONG | BIGINT |
| FLOAT | REAL |
| DOUBLE | DOUBLEPRECISION |
| BIGDECIMAL | DECIMAL |
| LOCALDATE | DATE |
| INSTANT | DATETIMEOFFSET |
| LOCALDATETIME | DATETIME2 |
| STRING | NVARCHAR |
| JSON | NVARCHAR |
| BINARY | VARBINARY |
Setup guidelink
Follow our step-by-step setup guides for specific instructions on how to set up your SQL Server database as a destination:
Primary key column limitationslink
Fivetran has the following limitations on the size of primary key columns:
-
Fivetran imposes a limitation on the maximum size of a single STRING primary key column at 256 bytes.
-
SQL Server imposes limitations on the key columns. See Microsoft’s documentation for a complete list of maximum capacity specifications for SQL Server.
Data load costslink
Whether you are self-hosting SQL Server or using a managed service, you will not be charged extra when we load data into your database.