N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

DataDirect Oracle ODBC Driver Features

DataDirect features are 100% driver implemented, allowing you to leverage them quickly, without changes to application code or proprietary Oracle extensions.

Performance
  • Wire protocol architecture
  • Easy-to-use tuning options and automatic driver tuning via Performance Wizard
  • Performance optimized for applications that use LOB data and PL/SQL stored procedures
  • Bulk Load
  • Load balancing
  • Built-in debugging capabilities
  • Enterprise-quality driver logging
  • Advanced Connection Pooling
  • Statement pooling
  • Data conversion
  • Socket management
  • Network wire management
  • Batching and throughput optimization

Security
  • Operating system authentication (aka Single Sign-On) via Kerberos
  • SSL data encryption

Enterprise Application Functionality
  • Application failover
  • Windows ODBC Driver Manager for Unix/Linux
  • Unicode and ANSI character sets
  • Stored procedures – Fully supports returning result sets (including multiple result sets) generated from PL/SQL stored procedures

Comprehensive Database / Platform Coverage

Interoperability
  • Interoperability including SQL up-leveling, which simplifies the task of supporting other databases in addition to Oracle, such as DB2, SQL Server, Sybase, MySQL, and more
  • Common architecture across drivers for different databases

Driver Functionality
  • Supports advanced data types such as BLOB, CLOB, XML, Timestamp, and National Language character data types (NCHAR, NVARCHAR2, NCLOB)
  • Oracle TNSNames.ora support
  • Static Cursor support – Optimizes forward-only cursors to pre-fetch multiple records, reducing network traffic and improving performance
  • Table and Tablespace Compression
  • SECUREFILE LOB Storage
  • Transparent Data and Tablespace Encryption – Leverage this database-level encryption capability provided by Oracle. Certification ensures interactions work seamlessly with data that is encrypted on the Oracle server.
  • Server-side result set caching – Leverage this capability provided by Oracle for better performance and scalability. DataDirect automatically inserts hint syntax necessary to enable caching. (Oracle’s driver requires hints be added to SQL statements to use this feature.)
  • Oracle RAC support
  • Character conversion support – Supports Unicode applications and full character conversion for Oracle database code pages
  • Oracle Heterogeneous Services (Generic Connectivity) / Oracle Database Gateway for ODBC – Supports connecting to any other data source through these technologies
  • Oracle 11gR2 feature support including:
    • IPv6
    • EditionName
    • Real Application Clusters (RAC) configuration options
    • Oracle Quality of Service Management

Quality and Reliability
  • Quality tested and certified with the DataDirect ODBC Verification Suite (OVS), the largest, most mature ODBC testing infrastructure
  • 100% ODBC specification compliance so you can leverage Oracle functionality without proprietary extensions or code