Omnis Data Access Modules

Omnis Data Access Modules (DAMs) plug-in to Omnis, enabling native and multi-tier connection to proprietary
Database Management Systems (DBMS).

To connect to proprietary databases (other than Omnis datafiles, SQLite datafiles, MySQL and PostgreSQL) you need the Professional edition of Omnis Studio. Depending on the database vendor you may also need to install the appropriate third-party clientware on each machine that will be connecting to the database server. Two-tier DAMs use this clientware to complete the connection to the remote database server.

Client Server Model

This page shows the different types of DAM supported by Omnis Studio. Single-tier DAMs (such as the MySQL DAM) connect directly to the DBMS, whereas two-tier DAMs are required to connect via a third party client library/libraries. The ODBC DAM also supports multiple-tier connections via third-party software. This is useful on platforms such as Mac OS X, where drivers to connect directly to a given DBMS may not be available.

Clientware Configuration

This page contains a list of third party clientware you can use for each of the supported platform and DAM combinations. Although several options are normally available for a given database, in the event of technical support issues with Omnis DAMs, it is the clientware and drivers listed on this page that we ask all faults be verified against.

Database connectivity

Where possible, we provide cross-platform support for DAMs, enabling you to deploy your application for Windows, Mac OS X and Linux users. This page lists the DAMs we provide with Omnis Studio and describes the attributes of each.

Third Party DAMs

In addition to the DAMs provided with Omnis Studio, FrontBase Inc also produce and maintain DAMs for Omnis Studio. Please click and navigate to the Download section.

New & Updated DAMs

Revisions and modifications made to Omnis DAMs are periodically made available for download from the ODPP download area. Older files are also available from the TigerLogic FTP site.

Legacy Information

The legacy information page contains information about past certifications, V2 DAMs and platforms no longer under development- for which support is no longer available.

DAMs Technical Notes

In addition to the information contained here, there are numerous Omnis technotes detailing issues commonly encountered using DAMs. (The DAMs section appears at the foot of the page).