[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

[en] Link
[en] Output Data Tool

[en] Link
[en] In-Database Workflow Processing
[en] Connect In-DB Tool

[en] Link
[en] Data Stream In Tool

[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.