Microsoft Azure SQL Database

Version:
2019.3
Last modified: September 26, 2019
Connection Type

ODBC, OLEDB (32- and 64-bit)

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 bigserver.database.windows.net, you would enter user123-admin@bigserver.database.windows.net for the Login ID.

Driver Details

The ODBC and OLEDB drivers are contained in the SQL Server Native Client. 
32-bit can be downloaded here.
64-bit 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 for SQL Server

Alteryx tools used to connect

Standard workflow processing

In-Database workflow processing

Select Microsoft SQL Server as the Data Source.

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

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.
    Was This Helpful?

    Need something else? Visit the Alteryx Community or contact support.