Open Data Manager

Open Data Manager (ODM) provides access to data in archive files for programs that use the Open Database Connectivity (ODBC) or Java™ Database Connectivity (JDBC) Application Programming Interfaces (APIs). Optim™ must be installed before installing ODM; however, ODM can be installed during the Optim installation process.

ODM is implemented using Optim Connect in concert with a custom driver that provides access to archive files and archive file collections. Optim Connect is a rich peer-to-peer networking product. A full set of Optim Connect manuals is included with ODM. This appendix describes how to install, configure, and use ODM to provide access to archive files.

Note: ODM is provided with a 30-day trial license that must be replaced with a permanent license for continued use. To obtain the permanent license, you must submit a Service Request at the Integrated Data Management Support site.

Deployment Strategy

To be accessed using ODM, archive files must be registered in an Optim directory and be accessible from the ODM server on which the data source is defined. A primary ODM server resides on an Optim server machine with one or more ODM data sources for archive files or archive file collections.

If JDBC is the sole API used to access archived data, a direct connection is made to the ODM server. This connection requires the JDBC driver for Optim Connect to access archived data.

If ODBC is used to access archived data, the thin ODBC client can connect directly to an ODM Server without the need of a secondary server. The ODBC driver is a standards-based driver that adheres to the ANSI SQL-92 standard. For this reason, the use of object names that are reserved words in the ANSI SQL-92 standard will produce unexpected results.

You can use connect studio, which is included with your ODM installation, to administer the ODM server from a Windows® machine. Optim Connect documentation is located in the Documentation subdirectory of the Optim Connect directory.