Omnis Studio Database Connectivity

Supported Connections on each Development Platform

The following tables list the database connections available with Omnis Studio. 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	Platform availability			Worker support
			Win32/64	MacOSX	Linux64
DAMOMSQL	Omnis native datafile (.df1, .df2, etc)*	None
DAMSQLITE	SQLite3 datafile (.db)	None (Omnis Studio 5.2 or later)
DAMODBC	ODBC datasource	Suitable ODBC Administrator & Unicode ODBC driver
DAMORA8	Oracle 8i (or later)	Oracle Client 9i release 2 (or higher) www.oracle.com
DAMSYBSE	Sybase ASA9...12 Sybase ASE11...15* ASA/ASE, MS SQL Server	SDK for SAP ASE 12.5 or higher (formerly Sybase Open Client) https://support.sap.com (login required) FreeTDS Client "libct"*
DAMDB2	IBM-DB2 v5 (or later)	DB2 Runtime Client 7.2 (or higher) www.ibm.com/db2
DAMMYSQL	MySQL 4.1 to 5.6.5 MySQL 5.6.6 or later	None MySQL API library "libmysql.dll/libmysqlclient.xxx"*
DAMPGSQL	PostgreSQL 8.1 to 9.6 PostgreSQL 10.0 or later	PostgreSQL API library "libpq.xxx" (supplied) PostgreSQL API library "libpq.xxx" (user-supplied)*
FRONTBASE	FrontBase 4.x (or later)	None (DAM available from www.frontbase.com)
DAMAZON	Amazon SimpleDB	None (Amazon Web Services account required. Studio 5.1 or later)
DAMJDBC	JDBC driver (API v2.0 or higher)	Java Runtime Environment (JRE) 1.4.1 or higher & *JDBC Driver

Notes

• DAMOMSQL connects using the V3 DAM API but is single-threaded only.
• Open Client 15.0 is required to connect to ASE 15.0
• Connection to PostgreSQL 10.0 and later requires a replacement SSL-enabled client library. Refer to technote TNSQ0031 for details.
• Worker support indicates support for SQL worker/multi-tasking objects, new in Studio 6.0.
• The MySQL DAM supplied with Omnis Studio 11 and later requires an external SSL-enabled client library. Refer to technote TNSQ0039 for details.
• Use the Sybase DAM with FreeTDS client for native connection to SAP Sybase & Microsoft SQL Server. See technote TNSQ0036 for details.
• The JDBC DAM is deprecated as of Omnis Studio 10.x

Other Products	Connects to...	Additional third-party software required	Platform availability
			Win32/64	MacOSX	Linux
Omnis read-only ODBC driver (single-threaded)*	Omnis native datafile (.df1, .df2, etc)	ODBC compliant application. ODBC Driver Manager
Omnis (Datafile) Data Bridge	Omnis native datafile (.df1, .df2, etc)	None
Omnis ODBC Data Bridge	ODBC Driver Manager (64-bit)	ODBC Driver (64-bit)

Notes

• Available separately for Unicode and Non-Unicode datafiles.

 

Disclaimer: Omnis Software Ltd. 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 OMNIS BE LIABLE FOR ANY INDIRECT, PUNITIVE, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES HOWEVER THEY MAY ARISE AND EVEN IF WE HAVE BEEN PREVIOUSLY ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.