Jump to: navigation, search

Difference between revisions of "DTP Supported Databases"

 
(6 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
Last update: early Ganymede (February 2008)
 
Last update: early Ganymede (February 2008)
 +
 +
==Support Levels==
 +
*'''N''': No support
 +
*'''C''': Connect, no DSE content
 +
*'''T''': Table and columns
 +
*'''D''': T + data types
 +
*'''R''': D + routines (stored procs, UDF)
 +
*'''V''': R + vendor specific objects
 +
*'''A''': All available objects
 +
  
 
{| border="1" cellpadding="3" cellspacing="1"
 
{| border="1" cellpadding="3" cellspacing="1"
Line 17: Line 27:
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| DB2 for i5/OS
 
| DB2 for i5/OS
Line 24: Line 34:
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| DB2 for Linux, Unix, and Windows
 
| DB2 for Linux, Unix, and Windows
Line 31: Line 41:
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| DB2 for Linux, Unix, and Windows
 
| DB2 for Linux, Unix, and Windows
Line 38: Line 48:
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| DB2 for z/OS
 
| DB2 for z/OS
Line 45: Line 55:
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
 
| align="center" |  
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
 
| 10.0
 
| 10.0
 
| align="left"  | DB2 Universal Driver
 
| align="left"  | DB2 Universal Driver
| align="center" | V
+
| align="center" | '''V'''
| align="center" | Der Ping
+
| align="center" | dpchou
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
Line 59: Line 69:
 
| align="center" |
 
| align="center" |
 
| align="center" |
 
| align="center" |
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
 
| 10.1
 
| 10.1
 
| align="left"  | DB2 Universal Driver
 
| align="left"  | DB2 Universal Driver
| align="center" | V
+
| align="center" | '''V'''
| align="center" | Der Ping
+
| align="center" | dpchou
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
Line 73: Line 83:
 
| align="center" |
 
| align="center" |
 
| align="center" |
 
| align="center" |
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
Line 80: Line 90:
 
| align="center" |
 
| align="center" |
 
| align="center" |
 
| align="center" |
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
Line 87: Line 97:
 
| align="center" |
 
| align="center" |
 
| align="center" |
 
| align="center" |
| align="center" |
+
| align="left" |
 
|-
 
|-
 
| Derby
 
| Derby
 
| 10.2
 
| 10.2
 
| align="left"  | Derby Embedded JDBC Driver
 
| align="left"  | Derby Embedded JDBC Driver
| align="center" | V
+
| align="center" | '''V'''
| align="center" | John
+
| align="center" | jgraham
 +
| align="left" |
 +
|-
 +
| HSQLDB
 +
| 1.8
 +
| align="left"  | HSQLDB JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Informix
 +
| 9.2
 +
| align="left"  | Informix JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Informix
 +
| 9.3
 +
| align="left"  | Informix JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Informix
 +
| 9.4
 +
| align="left"  | Informix JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Informix
 +
| 10.0
 +
| align="left"  | Informix JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Ingres
 +
|
 +
| align="left"  | Ingres JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" | Coming in Galileo
 +
|-
 +
| MySQL
 +
| 4.0
 +
| align="left"  | MySQL JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| MySQL
 +
| 4.1
 +
| align="left"  | MySQL JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| MySQL
 +
| 5.0
 +
| align="left"  | MySQL JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| MySQL
 +
| 5.1
 +
| align="left"  | MySQL JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Oracle
 +
| 8.0
 +
| align="left"  | Oracle Thin Driver
 
| align="center" |
 
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Oracle
 +
| 9.0
 +
| align="left"  | Oracle Thin Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Oracle
 +
| 10.0
 +
| align="left"  | Oracle Thin Driver
 +
| align="center" | '''R'''
 +
| align="center" | dpchou
 +
| align="left" |
 +
|-
 +
| PostgreSQL
 +
| 8.0
 +
| align="left"  | PostgreSQL JDBC Driver
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Microsoft SQL Server
 +
| 2000
 +
| align="left"  | Microsoft SQL Server 2000 Driver for JDBC
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| Microsoft SQL Server
 +
| 2005
 +
| align="left"  | Microsoft SQL Server 2000 Driver for JDBC
 +
| align="center" |
 +
| align="center" |
 +
| align="left" |
 +
|-
 +
| SQLite
 +
| 3.6
 +
| align="left"  | SQLiteJDBC v053
 +
| align="center" |
 +
| align="center" |
 +
| align="left" | Coming in Galileo
 +
|-
 +
| Sybase ASA
 +
| 9.x
 +
| align="left"  | Sybase JDBC Driver for Sybase ASA 9.x
 +
| align="center" | '''A'''
 +
| align="center" | hhsi
 +
| align="left" |
 +
|-
 +
| Sybase ASE
 +
| 12.x
 +
| align="left"  | Sybase JDBC Driver
 +
| align="center" | '''A'''
 +
| align="center" | hhsi
 +
| align="left" | Delivered in Ganymede (1.6)
 +
|-
 +
| Sybase ASE
 +
| 15.x
 +
| align="left"  | Sybase JDBC Driver
 +
| align="center" | '''A'''
 +
| align="center" | hhsi
 +
| align="left" | Delivered in Ganymede (1.6)
 
|}
 
|}
  
 
[[Category:Data Tools Platform]]
 
[[Category:Data Tools Platform]]

Latest revision as of 11:29, 8 October 2008

Back to DTP Main Page


Last update: early Ganymede (February 2008)

Support Levels

  • N: No support
  • C: Connect, no DSE content
  • T: Table and columns
  • D: T + data types
  • R: D + routines (stored procs, UDF)
  • V: R + vendor specific objects
  • A: All available objects


DTP Supported Databases
Database Version Driver Support Checked By Notes
DB2 for i5/OS AS/400 Toolbox for Java
DB2 for i5/OS IBM Data Server Driver for JDBC and SQLJ
DB2 for Linux, Unix, and Windows AS/400 Toolbox for Java
DB2 for Linux, Unix, and Windows IBM Data Server Driver for JDBC and SQLJ
DB2 for z/OS IBM Data Server Driver for JDBC and SQLJ
Derby 10.0 DB2 Universal Driver V dpchou
Derby 10.0 Derby Embedded JDBC Driver
Derby 10.1 DB2 Universal Driver V dpchou
Derby 10.1 Derby Client JDBC Driver
Derby 10.1 Derby Embedded JDBC Driver
Derby 10.2 Derby Client JDBC Driver
Derby 10.2 Derby Embedded JDBC Driver V jgraham
HSQLDB 1.8 HSQLDB JDBC Driver
Informix 9.2 Informix JDBC Driver
Informix 9.3 Informix JDBC Driver
Informix 9.4 Informix JDBC Driver
Informix 10.0 Informix JDBC Driver
Ingres Ingres JDBC Driver Coming in Galileo
MySQL 4.0 MySQL JDBC Driver
MySQL 4.1 MySQL JDBC Driver
MySQL 5.0 MySQL JDBC Driver
MySQL 5.1 MySQL JDBC Driver
Oracle 8.0 Oracle Thin Driver
Oracle 9.0 Oracle Thin Driver
Oracle 10.0 Oracle Thin Driver R dpchou
PostgreSQL 8.0 PostgreSQL JDBC Driver
Microsoft SQL Server 2000 Microsoft SQL Server 2000 Driver for JDBC
Microsoft SQL Server 2005 Microsoft SQL Server 2000 Driver for JDBC
SQLite 3.6 SQLiteJDBC v053 Coming in Galileo
Sybase ASA 9.x Sybase JDBC Driver for Sybase ASA 9.x A hhsi
Sybase ASE 12.x Sybase JDBC Driver A hhsi Delivered in Ganymede (1.6)
Sybase ASE 15.x Sybase JDBC Driver A hhsi Delivered in Ganymede (1.6)