Alteryx Designer Desktop Knowledge Base
Definitive answers from Designer Desktop experts.End of Support for 32-BIT Database Connections
WHAT IS CHANGING?
The Alteryx Platform currently supports both 32-bit and 64-bit database connections. Alteryx version 2021.2 will be the last version that contains functionality to connect to 32-bit data sources. If you are currently using 32-bit connections, you will not be able to utilize those same connections in 2021.3.
WHY ARE WE DOING THIS?
This one is simple; 32-bit data sources are an increasingly obsolete form of technology that have taken a back seat to the now industry-standard 64-bit variant. 64-bit database connections provide significant performance improvements through the better utilization of memory, leading to better input performance of your Alteryx workflows. Continued support and investment in 32-bit technology takes away resources that would otherwise be used to optimize the implementation of current and future technologies.
WHO WILL THIS IMPACT?
We do not expect this to impact many customers, and those who are impacted are encouraged to migrate their software to support 64-bit connections. Customers who utilize 32-bit connections will have the ability to continue to use Alteryx version 2021.2 or older for the foreseeable future and with the “Extended Support Period” outlined below.
WHAT IS THE EXTENDED SUPPORT PERIOD FOR 32-BIT CONNECTIONS IN ALTERYX ANALYTICS 2021.2 AND PRIOR?
For a period of two (2) years from the date of release of Alteryx version 2021.2 (the “Extended Support Period”), Alteryx will provide customer technical support comprised of fixes for critical bugs such as those related to security. The likelihood of a bug or defect being addressed and fixed is dependent upon a number of variables including the frequency of occurrence and the viability of work around solutions. After the Extended Support Period, Alteryx will no longer provide customer technical support for 32-bit connections.
HOW CAN YOU CHECK IF YOU ARE USING 32-BIT CONNECTIONS?
-
On your machine, navigate to the Windows search menu and search for “ODBC Data Sources”
-
Select “ODBC Data Sources (32-bit)”
-
Note any Data source (System DSN or User DSN) that has a platform version of “32-bit”
-
Check if any of these DSNs are referenced within connections for Alteryx workflows. You can also check if they are referenced within saved User Connections, In-DB connections, or Gallery Data Connections.
*Note* If you utilize any full connection strings within your workflow, verify whether the specified driver is 32-bit. If you have issues determining what drivers you are using, your IT team or Database Administrator will be able to help you.
HOW DO I UPGRADE TO 64-BIT CONNECTIONS?
If you find that you are currently utilizing 32-bit connections, the process to upgrade them to 64-bit connections is as follows:
- Validate with your IT team or database administrator that the database supports connections with a 64-bit driver
- Install the 64-bit version of the driver for your specific database on your machine
- Configure a DSN with the new 64-bit driver or reference the new driver in your connection string (for Oracle and SQL Server)
- Update workflows with the new connection(s)
WHAT ARE THE KEY MILESTONES FOR 32-BIT CONNECTION SUPPORT?
Q2 2021
Release of Alteryx version 2021.2 with 32-bit connections available
Alteryx version 2021.2 will be the last Alteryx release that allows users to connect with a 32-bit connection.
EXPECTED Q4 2022
Last day to download a version of Alteryx that supports 32-bit connections
Alteryx version 2021.2 will be available on the downloads.alteryx.com webpage until Alteryx version 2022.4 is released. After this date, no version of Alteryx will be available that allows users to connect to data sources with 32-bit connections.
JUNE 2023
Extended support period ends for all 32-bit data source connections
All support for 32-bit versions of Alteryx will end two (2) years from the date of release of Alteryx Analytics 2021.2. For customers with contracts that specify EOL support clauses, support will be available under the terms and conditions of that contract.
