1.6 Database Certification for SQL Developer (Oracle and Third-Party)

This section describes Oracle and non-Oracle (third-party) databases that are certified for use with SQL Developer.

Table 1-2 lists the Oracle database certifications.

Table 1-2 Oracle Database Certification for SQL Developer

Product Releases

Oracle Database

Oracle 11gR2, Oracle 19c, Oracle 23ai

SQL Developer can be used to view metadata and data of several non-Oracle (third-party) databases. Table 1-3 lists the third-party database certifications.

Table 1-3 Non-Oracle (Third-Party) Database Certification for SQL Developer

Database Releases Notes

IBM DB2

DB2 UDB

DB2 8.x

DB2 9.x

For any DB2 release: db2jcc.jar and db2jcc_license_cu.jar files required; available from IBM.

Microsoft SQL Server

SQL Server 7

SQL Server 2000

SQL Server 2005

SQL Server 2008

For any Microsoft SQL Server release: JDBC driver jtds-1.2.jar required; included in jtds-1.2-dist.zip available from sourceforge.net; also available through Help, Check for Updates.

MySQL

MySQL 3.x

MySQL 4.x

MySQL 5.x

For any MySQL release: JDBC driver required. For MySQL 5.x: mysql-connector-java-5.0.4-bin.jar, which is included in mysql-connector-java-5.0.4.zip; also available through Help, Check for Updates. (Do not use the latest MySQL driver 5.1.)

Sybase Adaptive Server

Sybase 12

Sybase 15

For any Sybase Adaptive Server release: JDBC driver jtds-1.2.jar required; included in jtds-1.2-dist.zip available from sourceforge.net; also available through Help, Check for Updates.

Teradata

Teradata 12

Teradata 13

JDBC driver files tdgssconfig.jar and terajdbc4.jar required; included (along with a readme.txt file) in the TeraJDBC__indep_indep.12.00.00.110.zip or TeraJDBC__indep_indep.12.00.00.110.tar download.

For information about creating and using connections to third-party databases, see the information about database connections in the SQL Developer online help or Oracle SQL Developer User's Guide.