Microsoft Azure SQL Database
| Type of Support: | Read & Write, In-Database |
| Validated On: | ODBC Driver 11, 13, 13.1 for SQL Server |
| Connection Type: | ODBC, OLEDB (64-bit) |
| Driver Details: |
The ODBC and OLEDB drivers are contained in the SQL Server Native Client. 32-bit can be downloaded here. 64-bit can be downloaded here. Bulk write support is available for standard and in-database workflows. In-Database processing requires 64-bit database drivers. |
| 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. |
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (For standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing). Select Microsoft SQL Server as the Data Source.
Additional Details
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.