Teradata Studio 15.00 now available

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Teradata Studio 15.00 now available

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.

What's New:

  • 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.

  • Aster 6.0 Support

Added support for the Aster 6.0 Database and embedded the Aster 6.0 JDBC Driver.

  • Aster Smart Loader, Table Load and Export Wizards

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.

  • Aster Table Editor

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.

  • Teradata 15.00 Support

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.

  • Aster Drop Action

Support for dropping of Aster objects has been added to the menu and toolbar actions.

  • Hadoop Enhancements

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.

  • Data Transfer Wizard

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.

  • New Teradata Compare Object Wizard

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.

  • New Teradata Copy Object Wizard

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.

  • SQL Editor Enhancements

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.

  • Disk Cache

Allows large objects, such as CLOBS, BLOBS, JSON, or large text data types to be cached on disk for Export, Load, and Editing.

Need Help?

For more information on using Teradata Studio, refer to the article, Teradata Studio. To ask questions or discuss issues, refer to the Teradata Studio Forum and post your question.

Online Help can be accessed within Teradata Studio:

  • From the main menu: Help > Help Contents > Teradata Studio
  • Context sensitive help: When a user is in a dialog, they can hit the F1 key to retrieve help text sensitive to where they are within the dialog.
  • Also, the Quick Tour provides a quick overview of Teradata Studio features. Go to Help > Welcome.

Reference Documentation can be found on the download page or at: www.info.teradata.com

  • Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Release Definition Publication ID: B035-2040-014C
  • Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Installation Guide Publication ID: B035-2037-014K
17 REPLIES

Re: Teradata Studio 15.00 now available

Hello,

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

Regards,

Edwin Muñoz

Teradata Employee

Re: Teradata Studio 15.00 now available

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/teradata-studio.

You can also download from the Teradata Patch Server.

Re: Teradata Studio 15.00 now available

Thank so much!!!

Re: Teradata Studio 15.00 now available

I downloaded the studio recentversion (From http://downloads.teradata.com/download/tools/teradata-studio), and installed by using .exe file. I am on Windows 7 and DBMS 13.10. When i searched for the Teradata Studio from start menu OR desktop, i cannot see it. Am I missing anything here? 

Thanks,

Geeta.

Teradata Employee

Re: Teradata Studio 15.00 now available

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.

Re: Teradata Studio 15.00 now available

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.

Teradata Employee

Re: Teradata Studio 15.00 now available

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/teradata-studio-products-choosing-the-right-client-tool.

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.

N/A

Re: Teradata Studio 15.00 now available

hi

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? 

Thanks

Dennis

Teradata Employee

Re: Teradata Studio 15.00 now available

Dennis, The Teradata Studio Mac OSX install requires Apple JRE 1.6.