Microsoft Analytics Platform System

Type of Support: Read & Write, In-Database
Validated On: APS 10.0
ODBC Driver 13.1 for SQL Server
SQL Server Native Client 10.0, 11.0
Connection Type: ODBC (32- and 64-bit)
Driver Details: The ODBC 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.

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 Data Tool database connection.
  • Write functionality is limited to creating new tables or replacing tables.