Qilan - Supported Data Bases

Qilan communicates 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 Qilan 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 Qilan 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 (created by Qilan) 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, not Qilan, sets these limits.

The Qilan 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 Qilan 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)
Apache Derby	JDBC network drivers included. Full SQL support including schema import. Schema design, table data editing and backups are handled via the Qilan Database Manager. All join types supported. Please note that Derby is in active development and some features may not be implemented or partially implemented. New updates, available from http://db.apache.org/derby/, may be downloaded as they become available.
FileMaker™	JDBC driver included. Limited SQL support. Schema export and joins are not supported. Each database is considered a single Qilan table. Filemaker version 6 supported.
FoxPro™	JDBC driver available from HXTT (http://www.hxtt.net). JDBC software (server) must be installed on a computer accessible to FoxPro and the OSX machine running the Qilan engine. Schema export is not supported.
FrontBase™	JDBC driver included. Full SQL support including schema import and export. All join types supported.
Helix™	Helix is not supported by Qilan v3.5.1. Communication to Helix 6 under OSX is via a special adapter sold separately (Qog.jar) and requires CallHelix 2.1. Older Helix communication is via TCP/IP to the Osmosis Gateway (OG) running on the Mac OS under system 8.6 through 9.x for Helix versions 4.x and 5.x. Helix communication uses 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 available from HXTT (http://www.hxtt.net). JDBC software (server) must be installed on an Microsoft Windows computer accessible to MS-Access and the OSX machine running the Qilan engine. 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 8i and 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.

Making Databases Work Together

interconnectivity,web deployment,database,multi-database,multi-platform,web applications,OS X,OS 10,MAC,MacIntosh