Microsoft Azure SQL Data Warehouse

Last modified: May 04, 2022
Connection Type

ODBC (64-bit)

Driver Configuration Requirements

For client version 10.0, you must append the server name to the Login ID within the Microsoft SQL Server DSN Configuration window. For example:

If a Login ID is user123-admin and the server name is, you would enter for the Login ID.

Driver Details

The ODBC drivers are contained in the SQL Server Native Client. 
Microsoft ODBC Driver can be downloaded here.

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

ODBC Driver 11, 13, 13.1

Alteryx tools used to Connect

Standard Workflow Process

Input Data Tool Icon

Input Data Tool

Output Data Tool Icon

Output Data Tool

 In-Database Workflow Process

Blue icon with database being plugged in.

Connect In-DB Tool

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

Data Stream In Tool

Write Support

  • Alteryx recommends using the bulk connection. Select Other Databases > SQL Server Bulk when configuring the Output tool database connection.
  • Write functionality is limited to creating new tables or replacing tables.

Authentication Type

Only Windows Authentication or SQL Server Authentication is supported, depending on how the SQL Server is configured.

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.