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
It will also install the JDBC driver as well as some utility support programs. After installing you will have these folders and files. If you are running HANA One v52 and the database is not running, navigate to the Administration page and start it. (HANA Developer edition v48 starts the database when you start the instance). Unsupported driver versions are not available for download here. We are continually improving the Java connectivity support. As such we highly recommend that you work with the latest version of Microsoft JDBC driver. For more information about the Microsoft JDBC Driver for SQL Server, see Overview of the JDBC driver and the JDBC.
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 t ake 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.
Download Sap Hana Jdbc Driver
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.