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 three different SQL Server implementations:
Type transformation mappinglink
The data types in your SQL Server warehouse 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 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 warehouse.