Microsoft SQL Server 2008, 2012, 2014, 2016

 

Type of Support: Read & Write, In-Database
Validated On: Database version 8,10, 11, 12, 13
ODBC Driver 11, 13, 13.1 for SQL Server
SQL Server Native Client 10, 11
Connection Type: ODBC, OLEDB (32- and 64-bit)
Driver Details: Download SQL Server ODBC and OLEDB drivers from Microsoft.

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

In-Database processing requires 64-bit database drivers.

 

Alteryx tools used to connect:

Connecting to SQL Server

See Connect to a SQL Server Database.

Additional Details

Limitations

Database Version: 8.00

ODBC (Client Version: 6.01.7601.17514)

OLEDB (Client Version: 6.01.7601.17514)