The version of the driver I use is Teradata JDBC Driver 16.20.00.12.Īfter downloading the file in ZIP format, extract it to the directory of your choice. You can download JDBC for Teradata at this link. In this post, all operations will be performed on version 19.2.1. If you have not downloaded the SQL Developer yet, you can do it here. 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 So we have three databases and you will want to connect to each one sooner or later. However, due to the unification of enterprise systems, data from Oracle will be migrated to Teradata. The original data warehouse was built in the Oracle and all date martes are stored there. Imagine that the data from the source system is stored in the MS SQL Server database. 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. 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 provides the feature to connect to many databases, including to Teradata, Microsoft SQL Server, IBM DB2, Sybase, MySQL and even Microsoft Access.
0 kommentar(er)
