Wrapping a SQL Component with ODBC OLE DB Or JDBC Using Existing Middleware


Support access to relational and/or proprietary databases from standard desktop tools such as Microsoft Access and Crystal Reports.


  • Use existing middleware (e.g., CORBA), which can execute SQL queries against one or more instances of the database.
  • Use an JDBC driver, or OLE DB provider to access the data from end-user applications.
  • Limit the types of queries that can be issued.
  • Enforce security on selected tables/columns.
  • Expose a global schema of a distributed database that is physically stored in different databases.


DataDirect OpenAccess SDK can help you create a customizable infrastructure for managing the distribution of information from your storage to the end user's application.

You simply use OpenAccess SDK to build an ODBC, JDBC, or OLE DB driver for your database(s). Because you're using a software development kit, you have full control over how to process the query. And you can start from our existing library of interfaces for Oracle, Sybase, Informix, Ingres, DB2 and others. This allows you to have customized access to these databases in weeks.


Use OpenAccess in the SQL database access mode where the SQL queries are executed not by the OpenAccess SQL engine but by the code you provide (SQL IP). This allows you to use your existing software that is capable of executing SQL statements. (Optionally, you can use the OpenAccess SQL engine to validate the SQL queries. ) See Wrapping a SQL Component with ODBC, OLE DB, JDBC API (.pdf) for more implementation details.


  • Quickly develop a single driver to access databases from desktop tools
  • Write code once and deploy in desktop or client/server configuration
  • Support both UNIX and NT platforms
  • Have full control over data mapping, execution of the SQL query, and access to certain tables