Icon7 Supported DataBases...

We communicate with databases via JDBC™, a SUN Microsystems Data Access Application Programming Interface. In order to establish a connection, there needs to be a database JDBC driver and adapter. Over 120 databases support JDBC and make basic drivers available to their owners. Some third party companies also supply enhanced drivers that offer increased functionality, however our software only requires basic connectivity. Refer to http://industry.java.sun.com/products/jdbc/drivers for an up to date list of databases that support JDBC.
The role of the database driver is to convert SQL statements and other calls into a syntax the database understands. Not all drivers are created equal. Many are utilitarian and only support rudimentary operations, such as select, update, delete, etc. Others, such as those offered by FrontBase and OpenBase enable far reaching capabilities. The database driver sets these limits.

The database adapter matches a standard set of interface tools to the respective database driver. As our customers encounter the need for additional connectivity, we develop new adapters. If you do not see your database in the list below, first check to insure your database supports JDBC, then contact us for development information.
 
Supported DataBase Information
Database
Notes (based on driver/database limitation)
FileMaker™
 JDBC driver included. Limited SQL support. Schema export and joins are not supported. Each database is considered a single Qilan table.
FrontBase™
 JDBC driver included. Full SQL support including schema import and export. All join types supported.
Helix™
 Communication is via TCP/IP to the Osmosis Gateway (OG) running on the Mac OS under system 8.6 through 9.x. JDBC access is not supported.
OG communicates to Helix through a limited AppleEvent suite. SQL, import and export schema, and joins are not supported.
Informix™
 JDBC driver included. Full SQL support including schema import and export. All join types supported.
MySQL™
 JDBC driver included. Full SQL support including schema import and export. Data Types ENUM and SET can't be exported.
A stand-alone MySQL installer is available from Tenon Intersystems.
MS-Access™
 JDBC driver included. ODBC-JDBC bridge software (server) must be installed on an Microsoft Windows computer accessible to MS-Access and the OSX machine running the Qilan engine. The software server component can be downloaded, along with complete documentation and troubleshooting, from rmijdbc. You do not need to download the Rmi ‘client’ software as this is already built into the Qilan adapter.

http://www.objectweb.org/rmijdbc/current/RmiJdbc/doc/index.html

Schema export is not supported.
MS-SQL™
 JDBC driver included. Full SQL support including schema import and export. Full outer joins not supported. SQL Server 7 and 2000 supported.
OpenBase™
 JDBC driver included. Full SQL support including schema import and export. Right outer and full outer joins are not supported.
Oracle™
 JDBC driver included. Full SQL support. Schema export and full outer joins are not supported. Oracle 9i supported.
Paradox™
 JDBC driver included. Limited SQL support. Schema import and export is not supported.
Sybase™
 JDBC driver included. Full SQL support including schema import and export. All join types supported.

JDBC™ is a trademark of Sun Microsystems. Use is respectfully acknowledged.