Welcome to the Alteryx Knowledge Base

DSN-less Oracle ODBC Support in Workspace Execution
user

Created/Edited - 9/13/2026 by Abdul Rehman | Alteryx

Question

How do I use a DSN-less Oracle ODBC connection with Workspace Execution?

Environment
  • Alteryx Designer 2026.1 and 2026.2
  • Workspace Execution
  • Data Connection Manager
  • Oracle Open Database Connectivity (ODBC)
  • Oracle RDS
  • Data & Connectivity
Answer

To use a DSN-less Oracle ODBC connection with Workspace Execution, upgrade to Alteryx Designer 2026.2.

Support for Oracle Simba ODBC DSN-less Data Connection Manager schemas was introduced in Alteryx Designer 2026.2. These schemas are not available in Alteryx Designer 2026.1.

Therefore:

  • Designer 2026.1: DSN-less Oracle ODBC Data Connection Manager schemas are not available.
  • Designer 2026.2: DSN-less Oracle ODBC Data Connection Manager schemas are available and can be used with Workspace Execution.

Resolution

  1. Upgrade Alteryx Designer to 2026.2.
  2. Open Data Connection Manager.
  3. Select Oracle as the data source.
  4. Select the ODBC connection type.
  5. Configure the Oracle ODBC connection details as required.
  6. Test and save the connection.
  7. Use the connection with your workflow in Workspace Execution.

The screenshots below illustrate where to select Oracle, followed by the ODBC connection type, when configuring the connection.

Additional Information

For details about supported tools, engines, drivers, and connectors in Workspace Execution, see the Workspace Execution compatibility reference:

Workspace Execution: Tool, Engine, Driver, and Connector Compatibility

Keywords

Oracle ODBC, DSN-less ODBC, Oracle Simba ODBC, Data Connection Manager, Workspace Execution, Oracle RDS, Alteryx Designer 2026.2

Was this article helpful?