Home Services Partners Company

OpenAccess SDK 7.2 (September 2013)

Noteworthy additions to release 7.2 include the following:

  • Support for Big Data Sets
    • Bulk load API
    • Disk-based nested query processing
  • Higher Precision for Number Crunching
    • Added DECIMAL datatype
    • Extended NUMERIC to 127 digit precision
    • Standard Deviation and Variance functions
  • Support for More Complex SQL
    • Expressions in INSERT values
    • Table functions in FROM
    • TOP and ORDER BY in Sub Queries
    • CASE expression in GROUP BY, HAVING, ORDER BY


  • JDBC client is 100% Pure Java Type 4 JDBC and JDBC 3.0 compliant, implemented from DataDirect's leading Connect for JDBC driver


  • ADO.NET client is 100% managed code and ADO.NET 1.1 compliant, implemented from DataDirect’s leading Connect for ADO.NET provider
  • ADO.NET client is 100% managed code based and offering ADO.NET 2.0, 3.5, and 4.0 compliant APIs offering pluggability into Microsoft Enterprise Libraries, Data Access Application Blocks (DAAB)

Specification Compliance

  • Built on the same framework as the DataDirect Connect line of ODBC, JDBC, OLE DB, and ADO.NET products, offering a higher level of compliance to the respective standards
  • 64-bit ADO (OLE.DB) client improves integration with Microsoft SQL Server Integration Services (SSIS) 2005, 2008 and 2010

Testing & Certification

  • Tested using DataDirect's testing suite, the industry's largest, most mature testing framework. This ensures that drivers built with OpenAccess SDK will work with hundreds of third-party applications that use ODBC, JDBC, OLE DB, or ADO.NET.

Performance & Scalability

  • Client API - Faster because it's based on the DataDirect Connect framework, which is continuously tuned to deliver market-leading performance
  • SQL Engine - Enhanced to support large file systems, allowing query results to extend beyond 2GB.
  • Wire level protocol – Gains performance through use of DataDirect SequeLink wire level protocol
  • Bulk load dramatically speeds up processing of very large data sets
  • Superior performance and scalability ready to on-ramp data for Big Data challenges over structured and unstructured data

All these enhancements enable faster end-to-end query time and the ability to handle massive data sets.


  • Adaptively integrate with the full SSL environments with mutual authentication configurability
  • Control access to OpenAccess Server at multiple levels of authentication
  • Configure client and server components to require host authentication, Kerberos, or IP range, in addition to data source specific authentication
  • SSL data encryption – Supported in ODBC, JDBC, and ADO.NET components

Management Console and Agent

  • Manage and monitor an OpenAccess Server remotely
  • Use GUI or command line management console to start, stop, and monitor services


  • Java and C/C++ support on 64-bit platforms (HP-UX, AIX, Solaris, Linux, and Windows)
  • See platform support for all operating systems and languages supported


  • Significant improvements
  • Includes complete documentation for new components leveraged from DataDirect's existing product lines

Read Next

What's new