Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

UDA Drivers Comparison Guide

OpenLink's 6.x Data Access Drivers feature set is listed below. Use the checklist to see which feature appears in which driver. Use individual feature hyperlinks to learn how to configure or otherwise access the feature. If you want to evaluate a previous version of the drivers, contact OpenLink Product Support for product feature lists and comparison information.

Feature Categories

OpenLink Data Access Drivers Feature List

Feature && Product Format
New DBMS Support && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
DB2 8 & 9 Check Mark Check Mark Check Mark
Firebird 1.5 Check Mark
Informix 10 & 11 Check Mark Check Mark Check Mark
Ingres R3 Check Mark Check Mark Check Mark
Microsoft SQL Server 2005 and 2008 Check Mark Check Mark Check Mark
MySQL 4.x & 5.x Check Mark Check Mark Check Mark
Oracle 11
PostgreSQL 8 Check Mark Check Mark Check Mark
Progress 91E04 &10.x Check Mark Check Mark
Sybase 15 Check Mark Check Mark Check Mark
Platform Support && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Mac OS X 10.5.x&&&10.6.x x86 (64-bit Mode) Check Mark Check Mark
Mac OS X 10.4.x&&&10.6.x x86 (32-bit Mode) Check Mark Check Mark Check Mark
Mac OS X 10.0.x&&&10.5.x PPC Check Mark Check Mark Check Mark
Linux & Unix (32-bit) Check Mark Check Mark
Linux & Unix (64-bit) Check Mark Check Mark
Windows Itanium2 (IA_64) Check Mark Check Mark
Windows Opteron (x86_64) Check Mark Check Mark Check Mark
Windows Xeon (x86_64) Check Mark Check Mark Check Mark
ODBC Compliance && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Core Check Mark Check Mark Check Mark
Level 1 Check Mark Check Mark Check Mark
Level 2 Check Mark Check Mark Check Mark
SQL Compliance && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
SQL-92 Check Mark Check Mark Check Mark
License Management && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Distributed License Management Check Mark Check Mark Check Mark
Performance & Stability && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Enterprise-grade Performance Check Mark Check Mark
Enterprise-grade Stability Check Mark Check Mark
Unicode Support && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Unicode Check Mark Check Mark Check Mark
Data Type Support && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Microsoft SQL Server NCHAR, NVARCHAR Check Mark Check Mark Check Mark
Microsoft SQL Server LARGE Value Data Types (NVARCHAR&&(max), VARBINARY&&(max), VARCHAR&&(max) Check Mark Check Mark
Microsoft SQL Server XML Data Type Check Mark Check Mark
MySQL Unicode Data Types Check Mark Check Mark Check Mark
Oracle BINARY FLOAT, BINARY DOUBLE Check Mark Check Mark Check Mark
Oracle BLOB, CLOB Check Mark Check Mark Check Mark
Oracle TIMESTAMP (with Time Zone, Local Time Zone) Check Mark Check Mark Check Mark
PostgreSQL Unicode Data Types Check Mark Check Mark Check Mark
Security & Authentication && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Ingres OS Level Authentication Check Mark
Informix OS Level Authentication Check Mark
Microsoft SQL Server Single Sign On (including Windows NTLMv2 authentication) Check Mark Check Mark
Serverside Rules-based Security Check Mark
SSL Data Encryption Check Mark Check Mark
Wire Protocol && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Microsoft SQL Server Check Mark Check Mark Check Mark
MySQL Check Mark Check Mark Check Mark
PostgreSQL Check Mark Check Mark Check Mark
Sybase Check Mark Check Mark Check Mark
Clustering (Failover, Balancing) && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Diagnostic Resources && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Built-in Clientside Tracing Check Mark Check Mark Check Mark
Connection Logging Check Mark
Database Specific Capabilities && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
DB2 - Multi-Threading Support Check Mark Check Mark
DB2 - SQLCancel Support Check Mark Check Mark
DB2 - XA-Based Two-Phase Commit Check Mark
Informix - MS DTC Check Mark
Informix - XA-Based Two-Phase Commit Check Mark
Ingres - Return of TID value by SQLSpecialColumns(RowID) Check Mark Check Mark
Ingres - XA-Based Two-Phase Commit Check Mark
Microsoft SQL Server - Auto-Discovery of SQL Server instances Check Mark Check Mark
Microsoft SQL Server - Database mirroring compatibility Check Mark Check Mark
Microsoft SQL Server - MS DTC Check Mark
Microsoft SQL Server - Multiple Active Result Sets (MARS) Check Mark Check Mark
Microsoft SQL Server - Named Instance Support Check Mark Check Mark
Microsoft SQL Server - Snapshot transaction isolation levels Check Mark Check Mark
Microsoft SQL Server - SQL Server Express Support Check Mark Check Mark
Microsoft SQL Server - XA-Based Two-Phase Commit Check Mark
Oracle - Connection Pooling Check Mark Check Mark
Oracle - Instant Client Support Check Mark Check Mark
Oracle - MS DTC Check Mark
Oracle - Real Application Cluster (RAC) Support Check Mark Check Mark
Oracle - Reference Cursors in Stored Procedures Check Mark Check Mark
Oracle - Static, Keyset, Forward-Only Cursors Check Mark Check Mark
Oracle - XA-Based Two-Phase Commit Check Mark
Progress - User Level Transaction Isolation Levels configuration Check Mark Check Mark
Sybase - Identity Column Support Check Mark Check Mark
Sybase - MS DTC Check Mark
Sybase - XA-Based Two-Phase Commit Check Mark
Other && Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
ADO.NET 2.0 Support Check Mark Check Mark
Visual Studio 2005 Integration Check Mark Check Mark