In my case, I put them in the $SQLDEV_HOME/jdbc/lib directory. Step 3 … Configure SQL Developer to use these third-party JDBC Driversįirst of all, you will have to put all the needed jars in a folder (somewhere in the sqldeveloper subfolders). Once downloaded, you will need both jars included in the zipfile. (It’s free but you will need an account to download it.).
Oracle sql developer postgresql driver#
To be able to connect a teradata database with SQL Developer, you need to download the jdbc driver for teradata. Note: the jTDS is a bit older, and I didn’t use it to connect to recent version of MSSQL (including in the Azure Cloud). SQL Server / Sybaseĭownload the jTDS jar file at this URL:, and extract the jar file included in the zip file.
When writing this blog post the last version was mysql-connector-java-8.0.16, and the required jar file was mysql-connector-java-8.0.16.jar. MySQL / MariaDBĬonfiguring SQL Developer to be able to connect to mysql or mariadb server need mysql Connector / J available at this URL: ĭownload the “Platform Independant” connector, and extract the jar file included in the archive/zip file. I recommend to download the 42.2.5 JDBC 42 driver, but download the driver you need depending on your PG Server version, your JDBC driver version etc.
To be configured for other rdbms, SQL Developer need extra libraries, and more precisely extra jdbc libraries for the required rdbms.ĭepending on the target rdbms, you will have to download these libraries : Postgresĭownload the jdbc driver enclosed in a jar file for postgres. Once downloaded, installed, then executed, you can add new connection but only to Oracle databases:
Oracle sql developer postgresql how to#
SQL Developer is available for download at this URL: ĭownload the version you want and install it (I don’t explain how to proceed here … I’m sure you’re smart enough to do that alone ! 😉 ) Step 1 … Download and Install SQL Developer In this post I will explain how to configure SQL Developer if you want to connect and use it with other rdbms than Oracle: But I usually use SQL Developer as an IDE. In my job, I usually work with other rdbms like postgres, sql server, teradata etc.
0 kommentar(er)
