Skip to main content

Microsoft Analytics Platform System

Connection Type

ODBC (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

Input Data Tool

Input Data Tool Icon

Link

Output Data Tool

Output Data Tool Icon

Link

In-Database Workflow Processing

Connect In-DB Tool

Blue icon with database being plugged in.

Link

Data Stream In Tool

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

Link

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.