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
- 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
- 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 plugability 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.
Security
- 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
Platforms
- 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
Documentation
- Significant improvements
- Includes complete documentation for new components leveraged from DataDirect's existing product lines