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
|