Microsoft Azure SQL Database
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 | Database version: 10, 11, 12, 13 |
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.