Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Add Support for Newer Microsoft SQL Server Versions and Drivers

Please add official support for newer versions of Microsoft SQL Server and the related drivers.

 

According to the data sources article for Microsoft SQL Server (https://help.alteryx.com/current/DataSources/SQLServer.htm), and validation via a support ticket, only the following products have been tested and validated with Alteryx Designer/Server:

 

Microsoft SQL Server

Validated On: 2008, 2012, 2014, and 2016.

  • No R versions are mentioned (2008 R2, for instance)
  • SQL Server 2017, which was released in October of 2017, is notably missing from the list.
  • SQL Server 2019, while fairly new (~6 months old), is also missing

This is one of the most popular data sources, and the lack of support for newer versions (especially a 2+ year old product like Sql Server 2017) is hard to fathom.

 

ODBC Driver for SQL Server/SQL Server Native Client

Validated on ODBC Driver: 11, 13, 13.1

Validated on SQL Server Native Client: 10,11

8 Comments
capgroup
6 - Meteoroid

Authentication options should also match those available in SSMS where possible. (include MFA support)

KylieF
Alteryx Community Team
Alteryx Community Team

Thank you for submitting your idea to the Alteryx idea boards!

 

If you haven’t yet be sure to check out our updated Submission Guidelines as well as the other product idea boards! All boards are actively monitors and we appreciate all the feedback we receive for each product.

rartt
Alteryx
Alteryx

As one of the data sources with the highest usage on our platform outside of Excel, it' important to our customers to have more recent versions supported.

CristonS
Alteryx Alumni (Retired)
Status changed to: Under Review
 
rartt
Alteryx
Alteryx

Great to see this under review, thank you Product Team!

rkong
Alteryx
Alteryx

Do we know when SQL 2019 will be officially supported?

MonBrazier
8 - Asteroid

SQL Server is one of the main data sources used in Alteryx - in fact, in our team, we use it a lot more frequently than any other source!

Please support the newer versions of ODBC Drivers for SQL Server!

CristonS
Alteryx Alumni (Retired)
Status changed to: Coming Soon