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.