Teradata Studio 15.00 is now available for download. Teradata Studio is an administration tool for creating and administering database objects. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX. It is built on top of the Eclipse Rich Client Platform (RCP) which allows Teradata Studio to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.
New Studio UI Perspectives
A perspective is a visual container for a set of views, menus, toolbars, and actions. Each perspective provides a set of functionality aimed at accomplishing a specific type of task or works with specific types of resources. Teradata Studio 15.00 includes three new perspectives: Query Development, Administrator, and Data Transfer. The Query Developement perspective focuses on SQL query developement tasks. The Administrator perspective focuses on database development and administrative tasks for Teradata Databases, Aster Databases, and Hadoop systems. The Data Transfer perspective provides support for transferring data and objects in Teradata and Aster Databases, and Hadoop systems.
Added support for the Aster 6.0 Database and embedded the Aster 6.0 JDBC Driver.
Smart Loader, Table Load and Table Export Wizards now support the Aster Database. Users can invoke the load and export wizards from the Data Source Explorer or the new Data Transfer Wizard.
The Teradata Studio Table Editor has added support for Aster tables. Users can invoke the Table Editor by selecting the table in the Data Source Explorer and choosing the Data>Edit Data option. The Table Editor supports paging and filtering of data for large tables.
Added support for the Teradata 15.00 Database. This includes support for the 15.00 Teradata grammar in content assist, as well as support for JSON data types. Teradata Studio 15.00 has also embedded the Teradata 15.00 JDBC Driver.
Support for dropping of Aster objects has been added to the menu and toolbar actions.
Hadoop connections have been added to the list of Connection Profile Types and are now displayed in the Data Source Explorer, as well as Hadoop object details are displayed in the Object Viewer.
Teradata Studio 15.00 has added a Data Transfer Wizard that provides a single dialog for transfering data between Teradata, Aster, Hadoop, and the external file system. Users can use the Data Transfer Wizard to invoke the Smart Loader on Teradata or Aster Databases, load or export table data for Teradata or Aster Databases, and Copy table objects and data between Teradata Databases or Teradata and Hadoop.
A new Compare Object wizard is provided to compare a Teradata object with another like object in the same or a different Teradata Database. The DDL for the objects is displayed side by side in the Compare Editor with the differences highlighted. Toolbar buttons are provided to allow the user to move from one difference to another.
The new Copy Object Wizard allows users to copy Teradata Database objects from one Teradata system to another. The Copy Object Wizard is invoked by dragging one or more objects from the Data Source Explorer to the Transfer View or via the Data Transfer Wizard. The Copy Object Wizard provides filtering of columns and data when copying table objects.
The SQL Editor has been enhanced to provide an Auto-commit toggle, Commit and Rollback toolbar options. This enhancement allows the user to manually manage the "commit" operation on their SQL statements. By default, the Auto-commit option is on. The user can toggle Auto-commit off and manually commit or rollback SQL statements to the database.
Another SQL Editor enhancement is the ability to link a SQL Editor window to a Result Set Viewer window. This allows the user to better manage multiple SQL Editors and Result Set Viewers.
Allows large objects, such as CLOBS, BLOBS, JSON, or large text data types to be cached on disk for Export, Load, and Editing.
Online Help can be accessed within Teradata Studio:
Reference Documentation can be found on the download page or at: www.info.teradata.com
I client of terada in Sunat- Lima-Peru. I need dowload teradata studio but i don´t find the link. Please send me this link? Thank´s
Edwin, The download is on the Developer Exchange Download page (Downloads Link at the upper right toolbar, then choose Teradata Studio from the table):http://downloads.teradata.com/download/tools/terad
You can also download from the Teradata Patch Server.
I downloaded the studio recentversion (From http://downloads.teradata.com/download/tools/terad
Geethareddy, Teradata Studio is installed in the Program Files(x86) or Program Files directory (depending on whether you installed the 32-bit or 64-bit version). Then /Teradata/Client/15.00. There is also an option to create a shortcut and/or add Studio to the Start Menu.
Thank you. That worked.
One more question, being DBA I feel TD Studio help better than TD Studio Express. Can you share your thoughts?
And on suggesting this tool to others (AppDBAs, Developers and Leads,etc), is there any downside of having too many TD studio connections on the DBMS?
Geeta, Yes, Teradata Studio is intended to be more of an administration tool than Teradata Studio Express. They are based on the same code set, but Studio has added administration features. Here is an article that compares the feature list between the two products: http://developer.teradata.com/tools/articles/terad
There is a limit to how many sessions you can have on the DBMS. From Studio perspective, we create 2 connections for your connection profile for internal use within Studio, such as gathering metadata from the Data Dictionary. We also create a connection pool to be used by the SQL Editor when executing SQL statements.
trying to install the Teradata Studio for Mac, i have already installe the JRE and JDK verison 1.8 but why it still asking me to install Java 1.6?