How to Set up Third Party Databases Drivers in Oracle SQL Developer

Updated April 2008

Oracle SQL Developer 1.5 (1.5.0.53.38) supports browsing a selection of third party databases; Microsoft Access, Microsoft SQL Server, MySQL and Sybase. Before accessing these databases, you need to download and load the correct third party drivers. You can do this manually or using Check for Updates.

Loading Third Party Drivers Manually

To load a third party driver, go to Tools > Preferences > Database > Third Party Drivers. Click Add Entry and add your specific jar file. The jars on this preference panel are used for all third party databases.

MySQL Databases

Download the MySQL Drivers from the MySQL Site. There are two drivers here:

• MySQL Connector/j 5.0
  Unzip the zip file and take the mysql-connector-java-5.0.4-bin.jar as your driver.jar
• MySQL Connector/J 3.1
  Unzip the zip file and take the mysql-connector-java-3.1.14-bin.jar as your driver.jar

SQL Server and Sybase Databases

Download the JTDS driver from here. Unzip the file and take the jtds-1.2.jar out of this. This is your driver.

Using Check For Updates.

Oracle SQL Developer provides users with the ability to download, install and setup the required third-party drivers using Check for Updates. Once you have downloaded and installed Oracle SQL Developer 1.5

• Select Help -> Check for Updates.
• Follow the wizard to select the drivers you require.
• Accept the license agreement
• Supply you OTN connection details. If you do not have access to OTN, you need to sign up first.
• The wizard completes by downloading and setting the appropriate preferences in Oracle SQL Developer.

Getting Started

Once you have Oracle SQL Developer installed and the third-party drivers setup. You can follow the Getting Started guide for migrating from Third-Party database.

More Information

Any questions? Visit the OTN SQL Developer Forum.