SQL Developer: How To Connect To Teradata Or MS SQL Server Database In Oracle SQL Developer? – 1 Great Tool For 2 Databases!

SQL Developer: Jak połączyć się do Teradata / MS SQL Server w Oracle SQL Developer - w 3 krokach? 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
Share this post and Earn Free Points!

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.

Introduction

SQL Developer

SQL Developer is a free and open-source graphical tool for working with SQL and PL/SQL. It is developed by Oracle Corporation and is primarily used for database development and database administration.

SQL Developer offers a range of features and tools to help you work with databases, including:

  • A graphical user interface (GUI) for creating, modifying, and executing SQL and PL/SQL statements
  • A SQL editor with syntax highlighting, code completion, and code formatting
  • A database explorer for browsing and interacting with database objects
  • A data editor for inserting, updating, and deleting data
  • A query builder for creating complex SQL queries visually
  • A version control integration for working with version-controlled SQL and PL/SQL files
  • A code profiler for analyzing and optimizing SQL and PL/SQL code performance

SQL Developer is available for Windows, MacOS, and Linux, and supports a range of database management systems, including Oracle, MySQL, Microsoft SQL Server, Teradata, and more.

SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is primarily used to store and manage data for a wide range of applications, including business, web, and mobile applications.

SQL Server is available in a number of editions, including Enterprise, Standard, and Express, each of which is suited for different types and sizes of applications. SQL Server is available for Windows and Linux, and supports a range of programming languages, including T-SQL, .NET, and Python.

SQL Server offers a range of features and tools to help you manage and work with your data, including:

  • A graphical user interface (GUI) for managing database objects and configuring server settings
  • A database engine for storing and retrieving data
  • A SQL language for querying and manipulating data
  • A set of built-in functions and stored procedures for performing common tasks
  • A security model for controlling access to data and database objects
  • A set of tools for backing up and restoring data, monitoring server performance, and more

Teradata

Teradata is a relational database management system (RDBMS) developed by Teradata Corporation. It is primarily used to store and manage large amounts of data for enterprise applications, such as business intelligence, data warehousing, and analytics.

Teradata is known for its scalability, performance, and reliability, and is often used by organizations with large volumes of data that need to be accessed and analyzed quickly. It is available for a range of operating systems, including Linux, Unix, and Windows.

Teradata offers a range of features and tools to help you work with your data, including:

  • A SQL language for querying and manipulating data
  • A set of built-in functions and stored procedures for performing common tasks
  • A database engine for storing and retrieving data
  • A security model for controlling access to data and database objects
  • A set of tools for backing up and restoring data, monitoring server performance, and more

Teradata also offers a range of integration and connectivity options, including support for ODBC, JDBC, and .NET drivers, as well as support for a range of programming languages, including Java, C++, and Python.

SQL Developer Connect To SQL Server And Teradata

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.

Teradata SQL Developer

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.

SQL Developer For SQL Server

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.

Summary

I hope this helps! Let me know if you have any further questions about Teradata, SQL Server or SQL Developer.

Could You Please Share This Post? 
I appreciate It And Thank YOU! :)
Have A Nice Day!

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?