[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

[en] Link
[en] Output Data Tool

[en] Link
[en] In-Database Workflow Processing
[en] Select Microsoft SQL Server as the Data Source.
[en] Connect In-DB Tool

[en] Link
[en] Data Stream In Tool

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