Skip to main content

[en] Microsoft SQL Server 2012, 2014, 2016, and 2019

[en] Connection Type

[en] ODBC, OLEDB (64-bit)

[en] Driver Details

[en] Bulk write support is available for standard and in-database workflows.

[en] In-Database processing requires 64-bit database drivers.

[en] Type of Support

[en] Read & Write, In-Database

[en] Validated On

[en] Database version: 10, 11, 12, 13

[en] Client version: ODBC Driver 11, 13, 13.1, 17, and 18; OleDB - SQL Server Native Client 10, 11

[en] Alteryx tools used to connect

[en] Standard workflow processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database workflow processing

[en] Connect In-DB Tool

Blue icon with database being plugged in.

[en] Link

[en] Data Stream In Tool

Blue icon with a stream-like object flowing into a database.

[en] Link

[en] Connecting to SQL Server

[en] See Connect to a SQL Server Database.

[en] FileTable Support

[en] For writing to a Microsoft SQL Server FileTable, see Microsoft Excel - Alteryx Driver.

[en] Limitations

[en] Database Version: 8.00

  • [en] Maximum Columns In Table: 1024

  • [en] Maximum Column Name Length: 128 characters

  • [en] Maximum Row Size: 8060 bytes ( does not include LOB size )

[en] ODBC (Client Version: 6.01.7601.17514)

[en] LOB data must all be at the end of the select. If the user enters a SQL statement that doesn't have them at the end of the statement they get an error, "This ODBC driver requires that all BLOB fields be at the end of the select.". A "select * from table" will move all the LOBs to the end.

[en] Limit for SQL Server for varchar(max)

[en] There is a limit for SQL Server for varchar(max) of 16777216 characters (read and write). Data above this limit is truncated.

: