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.

The following tables list the database connections available from Omnis Studio version 4.3.2 and later. Where a DAM is listed as being supported, please refer to the appropriate clientware configuration/certification matrix for further information on the third-party clientware required.

Where a DAM is not supported on a given platform, this is usually because the appropriate clientware is not available or is unstable or incompatible with our existing code base, preventing the code from being ported at the current time.

Multi-threaded (V3) Object DAMs
DAM Name Connects to... Additional third-party software required to make a connection Platform availability Worker
support
Win32 MacOSX Linux
DAMOMSQL Omnis native datafile
(.df1, .df2, etc)*
None
 
DAMSQLITE SQLite3 datafile (.db)
None (Omnis Studio 5.2 required)
DAMODBC ODBC datasource Suitable ODBC Administrator
& Unicode ODBC driver
DAMJDBC JDBC driver
(API v2.0 or higher)
Java Runtime Environment (JRE) 1.4.1 or higher & *JDBC Driver
DAMORA8 Oracle 8i (or later)
 
Oracle 9i release 2 (or higher) www.oracle.com
DAMSYBSE Sybase ASA9...12
Sybase ASE11...15*
Sybase Open Client 12.5 (or higher) www.sybase.com
DAMDB2 IBM-DB2 v5 (or later)
 
DB2 Runtime Client 7.2 (or higher)
www.ibm.com/db2
DAMMYSQL MySQL 4.1 (or later)
 
None
DAMPGSQL PostgreSQL 8.1 (or later) PostgreSQL API library "libpq.xxx"
(supplied)*
DAMOBASE OpenBase 7.0.7 (or later)
None
 
FRONTBASE FrontBase 4.x (or later) None (DAM available from www.frontbase.com)
 
DAMAZON Amazon SimpleDB None (Amazon Web Services account required)
 

Notes

  • DAMOMSQL connects using the V3 DAM API but is single-threaded only.
  • Type 4 JDBC drivers are embedded and require no additional software. Lower version drivers may required additional clientware.
  • Open Client 15.0 is required to connect to ASE 15.0
  • DAMPGSQL is not compatible with Omnis Studio 4.1 and earlier.
  • Please note that single-threaded (V2) DAMs are not available in the unicode version of Omnis Studio.
  • Worker support indicates support for SQL worker/multi-tasking objects, new in Studio 6.0.
Other Drivers
Driver Name Connects to... Additional third-party software required to make a connection Platform availability
WIn32 MacOSX Linux
Omnis read-only ODBC driver (single-threaded)* Omnis native datafile
(.df1, .df2, etc)
ODBC compliant application.
ODBC Administrator
 

Notes

  • Available separately for Unicode and Non-Unicode datafiles.
Disclaimer: TigerLogic is not responsible for the content of external web sites, and disclaims any responsibility for or liability related to software obtained through this site or any external web sites. IN NO EVENT WILL TIGERLOGIC BE LIABLE FOR ANY INDIRECT, PUNITIVE, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES HOWEVER THEY MAY ARISE AND EVEN IF TIGERLOGIC HAS BEEN PREVIOUSLY ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.