Supported SQL database managers

The following table provides a list of the SQL databases that EGL supports.

To create a connection, the New Connection wizard requests some or all of the information in the right column. This information is provided so that you can obtain the right information from a database administrator, if necessary. For more information about these connection fields, see Fields in the New Connection wizard.

Table 1. Supported databases
Database Manager Versions Setup Information
Cloudscape® 5.1
  • JDBC driver
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
DB2® UDB V8.1, V8.2, V9.1
  • JDBC driver
  • Host
  • Port number
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
DB2 UDB iSeries® V5R2, V5R3, V5R4
  • JDBC driver
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
DB2 UDB zSeries® V7, V8 (Compatibility Mode or New-Function Mode)
  • JDBC driver
  • Host
  • Port number
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
Derby 10.0, 10.1
  • JDBC driver
  • Database location
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
Informix® 9.2, 9.3, 9.4, 10.0
  • JDBC driver
  • Database
  • Host
  • Port number
  • Server
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
Oracle 8, 9, 10
  • JDBC driver
  • SID
  • Host
  • Port number
  • JDBC driver class
  • Class location
  • Connection URL
  • Catalog
  • User ID
  • Password
SQL Server 2000, 2005
  • JDBC driver
  • Host
  • Port number
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password
Sun Microsystems MySQL 5.1
  • JDBC driver
  • Database
  • Port number (typically 3306 by default)
  • JDBC driver class
  • Class location
  • Connection URL
  • User ID
  • Password

Feedback