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

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.