Microsoft Azure SQL Data Warehouse
Last modified: May 17, 2023
|Driver Configuration Requirements||
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:
If a Login ID is user123-admin and the server name is bigserver.database.windows.net, you would enter firstname.lastname@example.org for the Login ID.
The ODBC drivers are contained in the SQL Server Native Client. You can download the Microsoft ODBC Driver here.
Bulk write support is available for standard and in-database workflows.
In-Database processing requires 64-bit database drivers.
|Type of Support||
Read & Write, In-Database
ODBC Driver 11, 13, 13.1
In-Database Workflow Process
- Alteryx recommends that you use the bulk connection. Select Other Databases > SQL Server Bulk when you configure the Output tool database connection.
- Write functionality is limited to creating new tables or replacing tables.
Only Windows Authentication or SQL Server Authentication is supported, depending on how the SQL Server is configured.