Skip to main content

[en] Microsoft Analytics Platform System

[en] Connection Type

[en] ODBC (64-bit)

[en] Driver Details

[en] The ODBC drivers are contained in the SQL Server Native Client.

[en] 32-bit can be downloaded here.

[en] 64-bit can be downloaded here.

[en] Bulk write support is available for standard and In-Database workflows.

[en] In-Database processing requires 64-bit database drivers.

[en] Type of Support

[en] Read & Write, In-Database

[en] Validated On

[en] APS 10.0

[en] ODBC Driver 13.1 for SQL Server

[en] SQL Server Native Client 10.0, 11.0

[en] Alteryx Tools Used to Connect

[en] Standard Workflow Processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database Workflow Processing

[en] Connect In-DB Tool

Blue icon with database being plugged in.

[en] Link

[en] Data Stream In Tool

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

[en] Link

[en] Write Support

  • [en] Alteryx recommends using the bulk connection. Select Other Databases > SQL Server Bulk when configuring the Output Data Tool database connection.

  • [en] Write functionality is limited to creating new tables or replacing tables.