• Topic
  • Discussion
  • SupportWeb.ProductComparisonSheets(Last) -- Owiki? , 2016-09-01 08:59:27 Edit owiki 2016-09-01 04:59:27

    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

    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

    Referenced by...