You are currently viewing SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? – 1 great tool for 2 databases!
Photo by Campaign Creators on Unsplash
Could You Please Share This Post? I Appreciate It And Thank YOU! :) Have A Nice Day!
4.8
(779)

In this tutorial I will show you How to connect to Teradata using Oracle SQLDeveloper which 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?

How to connect to Teradata in SQL Oracle 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

SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? - 1 great tool for 2 databases!

Then find the tab Database -> Third Party JDBC Drivers

SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? - 1 great tool for 2 databases!

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

SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? - 1 great tool for 2 databases!

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

SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? - 1 great tool for 2 databases!

3. Create a database connection

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

SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? - 1 great tool for 2 databases!

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

SQL Developer:  How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? - 1 great tool for 2 databases!

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!

How useful was this post?

Click on a star to rate it!

Average rating 4.8 / 5. Vote count: 779

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?