ODBC Driver Development with the DataDirect OpenAccess SDK

OpenAccess SDK provides the toolkit and the run-time software components needed to implement an ODBC driver for your data source within days. The toolkit is used to build an Interface Provider (IP) to your data source through the implementation of a defined API consisting of 12 functions. Alternatively, you can replace the OpenAccess SDK SQL engine with your own SQL engine by implementing what we call a SQL IP that handles SQL execution.

OpenAccess SDK is suited for making desktop or server based data sources accessible through ODBC. It provides 99% of the code that is required to open up a database. The other 1% of the code resides between our SQL engine and your database. This is the code you write to take information from the SQL engine and to use it to process rows of data from your database. Whether implementing a local or client/server solution, you write your code with very little concern for the ODBC interface, SQL, networking, optimization, data types, and many other issues. You need only be concerned with taking a request to process data for which we provide you all the information you need to do it optimally. The 1% code you write can be written in C, C++, Java, or a .NET language. And this code is the same regardless of whether you want to support ODBC, JDBC, OLE DB, or ADO.NET.

Download | Buy | Data Sheet | Use Cases

Using our SQL Engine
Using our SQL Engine
Click Graphic for a full-sized image

Using your SQL Engine
Using your SQL Engine
Click Graphic for a full-sized image

Product Highlights

  • Simply implement 12 functions to integrate your data source with our SQL engine. Alternatively, you can replace the OpenAccess SDK SQL engine with your own SQL engine by implementing what we call a SQL IP that handles SQL execution.

  • Supports ODBC 3.5 specifications for Unicode and ANSI API

  • Runs on Windows, UNIX, and Linux, and available in 32-bit and 64-bit

  • OpenAccess SDK' ODBC implementation offers a high level of compliance to the Microsoft ODBC specification. This guarantees compatibility with any application written to the ODBC specification and with applications that are compatible with SQL Server, Oracle, Sybase, DB2, and other commercial RDBMS.

  • Supports interfacing to data sources using C/C++, Java, or .NET. You can implement an ODBC driver by writing the custom portion in Java!

  • The finished driver can be completely customized with the driver name, error message pre-fix, error messages, and configuration dialog boxes.

  • All supplied components are fully tested using our extensive test suite. All you have to test is the Custom Code you write.

  • Expand your driver offerings to include JDBC, OLE DB, and ADO.NET without any additional coding.

Additional Information

Product Overview
Platform Support
Release History
Main Product Page