Skip to main content

[en] Microsoft Azure SQL Database

[en] Connection Type

[en] ODBC

[en] Driver Configuration Requirements

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

[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] Database version: 10, 11, 12, 13

[en] Client version: ODBC Driver 11, 13, 13.1, 17, and 18; OleDB - SQL Server Native Client 10, 11

[en] Alteryx Tools Used to Connect

[en] Standard Workflow Processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database Workflow Processing

[en] Select Microsoft SQL Server as the Data Source.

[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 using the bulk connection. Select Other Databases > SQL Server Bulk when configuring 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.