Skip to main content

[en] Microsoft Azure SQL Data Warehouse

[en] Connection Type

[en] ODBC (64-bit)

[en] Driver Configuration Requirements

[en] 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:

[en] 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.

[en] Driver Details

[en] The ODBC drivers are contained in the SQL Server Native Client. You can download the Microsoft ODBC Driver here.

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

[en] In-Database processing requires 64-bit database drivers.

[en] Type of Support

[en] Read & Write, In-Database

[en] Validated On

[en] ODBC Driver 11, 13, 13.1

[en] Alteryx Tools Used to Connect

[en] Standard Workflow Process

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database Workflow Process

[en] Connect In-DB Tool

Blue icon with database being plugged in.

[en] Link

[en] Data Stream In Tool

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

[en] Link

[en] Write Support

  • [en] Alteryx recommends that you use the bulk connection. Select Other Databases > SQL Server Bulk when you configure the Output tool database connection.

  • [en] Write functionality is limited to creating new tables or replacing tables.

[en] Authentication Type

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

: