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

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

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.

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!