How to Set up Third Party Databases Drivers in Oracle SQL Developer
Updated April 2008
Oracle SQL Developer 1.5 (18.104.22.168.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.
Download the MySQL Drivers from the MySQL Site. There are two drivers here:
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
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.
Any questions? Visit the OTN SQL Developer Forum.