Teradata Studio 14.02 now available

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 14.02 now available

Teradata Studio 14.02 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 Express to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

What's New:

  • Aster Database Support

Support is provided for Teradata’s Aster Database. Users can create connections for an Aster Database using the Aster Connection Profile Wizard. The Data Source Explorer will display Aster Databases, Schemas, Tables, Views, and Map Reduce Functions. SQL Templates are provided to help users create Aster SQL commands. SQL statements can be executed against an Aster Database, with result set data displayed in the Result Set Viewer and history entries stored in the Teradata SQL History. The Teradata View also supports the display of more detailed information about Aster Database objects.

  • Collect Statistics

The Collect Statistics Wizard provides a user interface to help users perform COLLECT STATISTICS operations on tables and columns in Teradata Database 14.0 and higher. The user can select a table or column in the Data Source Explorer and choose the Collect Statistics option. The Statistics View is opened where the user can specify additional information for statistics collection and choose the columns for single or multi stats collection.

  • Data Lab Support (Smart Load, Copy Table)

Teradata Data Lab provides the DBA the flexibility to provision space within the data warehouse. Teradata Studio provides an option for Data Lab customers to easily load data from an Excel or CSV file (Smart Load) as well as copy tables from their Teradata system into their Data Lab. Tables can be dragged from the Data Source Explorer and dropped in the Data Lab View, invoking the Data Lab Copy Table wizard. The Copy Table wizard will copy the table in addition to the table data to the Data Lab. A filtering option is provided to filter out unwanted columns or certain data within the columns. The Smart Load option is provided by selecting the Tables folder within the Data Lab.

  • Enhanced DDL Generator

The DDL Generator has been enhanced to provide better options and DDL generation for Schemas, Tables, Views, Macros, Indexes, Stored Procedures, User Defined Functions, and User Defined Types.

  • Excel 2007 (.xlsx) Support

Support for Excel 2007 (.xlsx) has been added when exporting table data or result set data to Excel. Previously, only Excel 97-2003 was supported. This allows users to export over 65,536 rows of data to an Excel spreadsheet.

  • Hadoop Data Transfer

Teradata Studio 14.02 provides a feature to easily transfer tables and data from Hadoop to Teradata (Import) and from Teradata to Hadoop (Export). The Hadoop Transfer Perspective allows users to drag Teradata tables from the Data Source Explorer and drop them on the Database node in the Hadoop View and visa versa, drag tables from the Hadoop view and drop them on the Tables folder in the Data Source Explorer. Users can also right click on a Teradata table and choose the option in the Data menu, Export to Hadoop. Or right click on the Tables folder in the Data Source Explorer and choose the Teradata menu option Import from Hadoop. A dialog is opened to help you map the Teradata columns to Hadoop column types or Hadoop columns to Teradata column types.  A transfer job is started and, when completed, its status is displayed in the Transfer History View. Users must create a connection profile for the Hadoop database, providing the profile name, HCatalog hostname, port number, system username and password.

In order to use the Hadoop Data Transfer feature, users must enable the option by setting the Data Transfer Preference 'Enable Hadoop Views'. Refer to the Teradata Studio Help for more information on this feature.

  • Quick Tour Help Option

When bringing up Teradata Studio for the first time, a Quick Tour slide show is presented to help the user familiarize themselves with the basic features of Teradata Studio.

  • Result Set Viewer Performance Improvement

Performance improvements have been made to the Result Set Viewer to significantly reduce the amount of time it takes to display the result set data.

  • Teradata Load and Export

Teradata Load and Export provides an enhanced load and export feature to quickly load or export the data to and from tables within the Data Source Explorer. The Teradata Load feature will use criteria such as number of rows, column types, and existing table data to determine whether the Teradata JDBC FastLoad option will be used, otherwise JDBC batch operations are performed. Teradata Load and Export support both Excel 97-2003 .xls and Excel 2007 .xlsx file formats.

Filtering has also been added to the Teradata Export wizard. The user can choose to filter out certain columns, as well as filter out certain data within a column.

  • Upgrade Eclipse 3.7.2 and DTP 1.10.1

This release of Teradata Studio has upgraded its version of Eclipse to version 3.7.2 and its version of Eclipse Data Tools Platform to 1.10.1.

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.

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

  • Title: Teradata Studio Release Definition Publication ID: B035-2040-122C

Re: Teradata Studio 14.02 now available

Looks like the bug whereby edit and sometimes Show DDL on stored procedures and UDF's don't fully return all the info still exists on the Mac OS X version. Seems to work fine on Windows...

Otherwise, it's much faster. Thanks for the update!!
Teradata Employee

Re: Teradata Studio 14.02 now available

@tdgi, We will look into the problem.
Teradata Employee

Re: Teradata Studio 14.02 now available

@tdgi, I was not able to recreate your problem on the Mac OS X. So, can you tell me more about the SP or UDF you are having problems with? Is it a SQL, C, or Java UDF/SP? How many lines of SQL is it? Can you display the UDF/SP in the Teradata View and click on the SQL and Source tabs. Is it displayed correctly? Is there any exceptions in the Error Log? Thanks.

Re: Teradata Studio 14.02 now available

Is there a way to order the databases and users like we see them in TD Administrator? In hierarchical form instead of just listing every user and database on the system in alphabetical order? If this tool is to ultimately replace the existing TD administrator that is one feature it really needs to have. It makes it much easier to move between the different objects when I can collapse all my users under the parent DB and not have to look through them unless i want to.
Teradata Employee

Re: Teradata Studio 14.02 now available

A hierarchical view will be available in the next release; 14.10. The release has not been committed but early 3rd Q is the target.

Re: Teradata Studio 14.02 now available

I had to change permissions on the installation directory (chmod 755) in order to launch the app as no-root user.

Re: Teradata Studio 14.02 now available

@gseller, sounds good. thanks
Not applicable

Re: Teradata Studio 14.02 now available

This is probably a stupid question. I'm brand-new to Teradata (currently support several large Oracle environments).

Is the Studio tool and "single install" on Windows that doesn't require ANY other pre-reqs installed? We have previously installed the TTU suite for version 14 and it's a major pain the you-know-what. I have installed Studio, but that was after I had installed TTU.

Teradata Employee

Re: Teradata Studio 14.02 now available

Yes, it just requires the Java Runtime Environment, version 1.6 or greater.