Microsoft SQL Server 2012, 2014, 2016

Version:
2021.3
Last modified: August 11, 2021
Connection Type

ODBC, OLEDB (64-bit)

Driver Details

Bulk write support is available for standard and in-database workflows.
In-Database processing requires 64-bit database drivers.

Type of Support

Read & Write, In-Database

Validated On

Database version: 10, 11, 12, 13
Client version: ODBC Driver 11, 13, 13.1; OleDB - SQL Server Native Client 10, 11

Alteryx tools used to connect

Standard workflow processing

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

In-Database workflow processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

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

Data Stream In Tool

Connecting to SQL Server

See Connect to a SQL Server Database.

Limitations

Database Version: 8.00
  • Maximum Columns In Table: 1024
  • Maximum Column Name Length: 128 characters
  • Maximum Row Size: 8060 bytes ( does not include LOB size )
ODBC (Client Version: 6.01.7601.17514)

LOB data must all be at the end of the select. If 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.

Limit for SQL Server for varchar(max)

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

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.