Microsoft Azure SQL Database

Version:
Current
Last modified: March 27, 2020
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

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

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?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.