- Page 1 How To – Install the HANA Client and Create ODBC. You have been given HANA access via your Link Blue id. Please use responsibly.
- 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.
How to Set up Third Party Databases Drivers in Oracle SQL Developer
Hi, I was deployed excel file reader application using tomcat 7. For the back end purpose i used oracle 11g(oracle.jdbc.driver.OracleDriver ). How could I deploy the same application using SAP Netweaver Cloud and which driver i have to use for SAP HA.
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 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.
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.
-->
In our continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server, and Azure SQL Database. The driver is available at no additional charge and provides Java database connectivity from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs).
The Microsoft JDBC Driver for SQL Server has been tested against major application servers such as IBM WebSphere, and SAP NetWeaver.
Getting started
Documentation
Community
Download
Jdbc Driver Mysql
Download Microsoft JDBC Driver for SQL Server - has additional information about Maven projects, and more.