Microsoft Analytics Platform System

Version:
2019.3
Last modified: September 26, 2019
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.

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

Alteryx tools used to connect

Standard workflow processing

In-Database workflow processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

Link
Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

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.
Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.