Add Support for Newer Microsoft SQL Server Versions and Drivers

[ClayVan]

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

• ODBC Driver 17+ is not mentioned, even though it was released in February of 2018. https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view...
• SQL Server Native Client is deprecated. It is being replaced by Microsoft OLE DB Driver for SQL Server. However, there is not a mention of Microsoft OLE DB Driver for SQL Server. The latest version of this is 18.3.0. https://docs.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?vie...

[capgroup]

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

[KylieF]

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]

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.

[rartt]

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

[rkong]

Do we know when SQL 2019 will be officially supported?

[MonBrazier]

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!