Requirements for Using DataDirect OpenAccess SDK with Java

View PDF

Requirements are to be able to expose data stored and or managed by a Java environment through an ODBC, JDBC, OLE DB, or .NET compliant interface. This will allow end-users to use standard APIs from Java, UNIX, or Windows applications to access this data. For example, objects stored in the Java environment can be exposed to Microsoft Excel or Crystal Reports.

For this use case assume we have a Java application server that implements a data store consisting of a single table with some columns. We want to be able to use ODBC to get this information into Windows applications like Crystal Reports. Assume that Java Application server is running on a Windows NT Server and we want to implement a client/server solution (Figure 1).


Figure 1: ODBC Access to Java Data

Next: "How to Quickly Implement Standards-based Access to Java Data Sources"