Microsoft Analytics Platform System
|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
|Connection Type:||ODBC (32- and 64-bit)|
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.
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (For standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing).
- 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.