Microsoft Azure SQL Database
Version:
2022.1
Last modified: May 04, 2022
Connection Type | ODBC |
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 driver is contained in the SQL Server Native Client. 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.
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.
Authentication Type
Only Windows Authentication or SQL Server Authentication is supported, depending on how the SQL Server is configured.