This page contains links to allow you to access our on-line library of
application notes.
| Addressing
Sarbanes-Oxley Compliance with Fine Grained Secure Database
Access - According to the IT Governance Institute’s document,
"IT Control Objectives for Sarbanes-Oxley," controls over information
technology systems should include access controls over programs
and data. OpenAccess can help achieve this. |
| Integrate
Any Data Source With IBM DB2 Through ODBC Wrapper - describes
how OpenAccess SDK provides the framework and pre-built components
to quickly integrate any data source with IBM DB2 through ODBC
wrapper. |
| Open
up Web Services to 100s of ODBC and JDBC Compliant Applications
- describes how OpenAccess SDK provides the framework and pre-built
components to quickly allow the implementation of a custom JDBC
and ODBC driver over Web Services using C, C++, Java, or .NET
development environment. |
| Adding
a Flexible Query Mechanism to a Web Service - describes
how OpenAccess Query for Web Services SDK allows you to implement
a powerful query processing capability as part of your web service.
|
| Integration
of Data into Native Applications from .NET or Java Data Sources
- Describes how OpenAccess SDK can be used to implement a custom
ODBC or JDBC driver for a Java or .NET data source to bridge
the barrier between native Windows and the virtual machine worlds. |
| Opening
Up Your Financial Applications - Discusses how to use OpenAccess
to access data through proprietary business logic instead of
accessing the underlying SQL Database directly. And why that
is important. |
| ISAM
Appnotes and Programmer's
Guide - describes the design and implementation
of an IP to access ISAM compliant files using the standard
ISAM API. This application note details a design for writing
an IP that uses information stored in the schema definition
to handle access to any number of files. This note applies to
all cases in which data must from processed from sequential
files. Fully functional code is available under our samples
section. |
| SCADA
- Addresses the use of OpenAccess SDK to develop a ODBC, OLE
DB , or a JDBC driver for real-time and historian types of data
sources. |
| Custom
ODBC driver of an existing driver - Discusses the use of
the SQL Pass Through mode of the OpenAccess SDK to develop a
custom driver for a SQL compatible data source. |
| Object
Oriented Database - Discusses the use of the OpenAccess
SDK to expose a relational model for object and hierarchical
data sources. |
|
Wrapping
a SQL Component - Discusses the use of the OpenAccess
SDK to implement a SQL IP to implement ODBC, JDBC, or OLE
DB API to an existing SQL database.
|
| OpenAccess
Distributed Query Engine - OpenAccess supports the ability
to implement drivers that can perform joins between data residing
in different databases. This application note discusses the
use of the OpenAccess in the distributed query processing mode
to provide ODBC access to JD Edwards ERP system. |
| Using
OpenAccess to Access A Java Data Source - Discusses
how to expose data stored and or managed by Java environment
through 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. |
| Custom
ODBC Driver for a Progress Application - Use of a custom
ODBC or JDBC driver for a Progress application allows the information
it contains to be accessed from 100s of Windows and UNIX applications
that are in use by corporate users. |
