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](../../image/uuid-44c39077-2b45-df80-e69b-b71155470a81.png)
Output Data Tool
![Output Data Tool Icon](../../image/uuid-c3b315b4-79eb-aeec-b68a-2dca910b2a6f.png)
In-Database Workflow Processing
Connect In-DB Tool
![Blue icon with database being plugged in.](../../image/uuid-1a9d955f-dda6-bb9b-293b-18f515ee9c40.png)
Data Stream In Tool
![Blue icon with a stream-like object flowing into a database.](../../image/uuid-44c7f9d3-5dab-b8e3-89e0-b62d271e5a7d.png)
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.