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 (32- and 64-bit)|
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 email@example.com 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.
- 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.