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)
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.

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.