Skip to main content

Microsoft Azure SQL Database

Connection Type


Driver Configuration Requirements

You must append the server name to the Login ID within the Microsoft Azure SQL Database 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 driver is contained in the SQL Server Native Client.

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, 17, and 18; OleDB - SQL Server Native Client 10, 11

Alteryx Tools Used to Connect

Standard Workflow Processing

Input Data Tool

Input Data Tool Icon


Output Data Tool

Output Data Tool Icon


In-Database Workflow Processing

Select Microsoft SQL Server as the Data Source.

Connect In-DB Tool

Blue icon with database being plugged in.


Data Stream In Tool

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


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.