SQL Developer: How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?

SQL Developer:  How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?
Photo by Campaign Creators on Unsplash

Oracle SQL Developer provides the feature to connect to many databases, including to Teradata, Microsoft SQL Server, IBM DB2, Sybase, MySQL and even Microsoft Access. All you need is the JDBC driver. In this post, I will show you how to connect to Teradata and Microsoft SQL Server using JDBC in the Oracle SQL Developer tool.

Oracle SQL Developer is a free, integrated development environment for managing and administering the Oracle database, data modeling, creating PL / SQL applications, as well as managing external databases.

Use case
Imagine that the data from the source system is stored in the MS SQL Server database. The original data warehouse was built in the Oracle and all date martes are stored there. However, due to the unification of enterprise systems, data from Oracle will be migrated to Teradata. So we have three databases and you will want to connect to each one sooner or later. Of course, you can use dedicated tools for each database (Teradata Studio / Teradata SQL Assistant, MS SQL Server Management Studio and Oracle SQL Developer), but is not it easier and faster to use one tool to connect to all these databases?

Connection to Teradata in SQL Developer

If you have not downloaded the SQL Developer yet, you can do it here. In this post, all operations will be performed on version 19.2.1.

1. Download JDBC

You can download JDBC for Teradata at this link. The version of the driver I use is Teradata JDBC Driver 16.20.00.12.

After downloading the file in ZIP format, extract it to the directory of your choice. In the package you will find a file in .jar format – terajdbc4.jar.

2. Add JDBC driver in SQL Developer

Then find the tab Database -> Third Party JDBC Drivers

Click the Add Entry … button and select a .jar file from your directory. For me it looks like this:

The path to the JDBC file should appear in the list of drivers. Then click OK and restart SQL Developer.

3. Create a database connection

Add a new connection to the database by selecting New Database Connection…

Change the database type to Teradata and enter your database settings.


Connection to MS SQL Server in SQL Developer

Connecting in SQL Developer to the Microsoft SQL Server database looks the same as in the case of Teradata. The only thing you need to change is definitely the driver 🙂 jTDS JDBC allows you to connect to MS SQL Server and Sybase.

1. Download JDBC

To connect to Microsoft SQL Server you will need jTDS JDBS, which you can download for free here. I will use the jTDS JDBC 1.3.1 driver

2. Add JDBC driver in SQL Developer

1. Select Tools -> Preferences in the menu bar.

2. Then find the Database -> Third Party JDBC Drivers tab.

3. Click the Add Entry … button and select a .jar file from your directory.

4. The path to the JDBC file will appear in the list of drivers. Then click OK and restart SQL Developer.

3. Create a database connection

1. Add a new connection to the database by selecting New Database Connection …

2. Change the database type to SQLServer and enter your database settings.

If you enjoyed this post please add the comment below or share this post on your Facebook, Twitter, LinkedIn or another social media webpage.
Thanks in advanced!

Leave a Reply

avatar
  Subscribe  
Notify of
Close Menu