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