Studio 16.00 Available for Download

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

Studio 16.00 Available for Download

Teradata Studio Express, Teradata Studio, and Teradata Plug-in for Eclipse 16.00 are now available for download. The Studio family of products provide client based access to Teradata, Aster, and Hadoop.

Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems. Teradata Studio, in addition to the functionality of Studio Express, includes administration features for creating and administering database objects. They are both built on top of the Eclipse Rich Client Platform (RCP) which allows them to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database, Aster Database, and Hadoop platforms. Studio Express and Studio can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata Plug-in for Eclipse provides an Eclipse plug-in that includes the same functionality as Teradata Studio along with Dialogs and Wizards to help build Java Web Services, Java Stored Procedures, and Java User-defined Functions. Teradata Plug-in for Eclipse is supported on both Windows and Mac OSX platforms.

What's new in 16.00:

Teradata 16.00 Features

  • Provides 16.00 Grammar and DDL Syntax changes
  • Unicode Pass-through support
  • Dot Notation for AVRO, CSV, and TDNATIVE
  • TDNEGO support for authorization type in Teradata connections

Teradata Dataset Schema Support (Studio and IDE Only)

  • Provides support for administering Teradata DATASET SCHEMA objects. This includes Create, Drop, and Table column data type definitions to include DATASET SCHEMAs.

Foreign Server Support for QueryGrid Mapping of Users and Roles (Studio and IDE Only)

  • Provides support for Foreign Server Name Value Pairs to include SQL Sub-queries and System Variables. The Create and Modify Foreign Server will support mapping database system variables in the name value pairs.

Hadoop External JDBC Driver

  • Provides support to add an external JDBC Driver for Hadoop JDBC connections using Hive, Impala, or Presto

Hadoop Certifications

  • Cloudera 5.8
  • Hortonworks 2.5
  • Presto 148t
  • TDCH 1.5

Aster 7.0 Support (Aster on Hadoop)

  • Studio is bundled with Aster 6.2 JDBC Driver. The Aster 6.2 Driver will allow users to enter SQL for functionality even though it has been removed from AX 7.0. It will be ignored by the Aster database.

Additional Useablity Enhancements:

  • Administer UDTs (Studio and IDE Only). Additional menu and toolbar options in the Object List Viewer when viewing User-defined Types.
  • Delete Database (Studio and IDE Only). New option in the Object List Viewer when viewing Databases.
  • Additional lists displayed in the Object List Viewer display, such as 'Show All Objects', 'Show Triggers' for a Database, Table references, and user roles.
  • SQL Editor String Substitution (new button 'SQLA Substition' in the Teradata SQL Editor toolbar). This will toggle the SQL Editor to handle string substitutions like Teradata SQL Assistant.
  • Provide SQL History File Location (new option on the Teradata SQL History preference page)

Need Help?

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express or Teradata Studio Express User Guide (available on the Teradata Studio Express Download Page).

For more information on using Teradata Studio, refer to the article, Teradata Studio or the Teradata Studio User Guide (available on the Teradata Studio Download Page).

For more information on using Teradata Plug-in for Eclipse, there is an article to help you get up and running. Please refer to Getting Started with Teradata Plug-in for Eclipse.

To ask questions or discuss issues, refer to the Teradata Studio Forum on Community and post your question.

Online Help can be accessed within the plug-in in two ways:

  • From the main menu: Help > Help Contents
  • 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 Express or 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 Installation Guide Publication ID: B035-2037-086K
5 REPLIES
Enthusiast

Re: Studio 16.00 Available for Download

In both SQL Assistant and Studio, we are given the option of exporting the result set to a file. In SQL Assistant, we have the option to write all exported answer sets to a single file. This comes in handy when I have several 'show statistics' or 'show table', etc statements. In Studio, I don't see this option. If I submit several statements in one screen and choose 'export', it saves each one to a different file and it stops after each execution and asks for a file name and location. Am I overlooking the option to write all answer sets to a single file or is this option not available yet in Studio?
Teradata Employee

Re: Studio 16.00 Available for Download

This option isn't available in Studio 16.00.

Enthusiast

Re: Studio 16.00 Available for Download

Are there plans to make it available in later versions?
Teradata Employee

Re: Studio 16.00 Available for Download

We are considering this enhancement for a future release.

Enthusiast

Re: Studio 16.00 Available for Download

Hi,

 

I have installed Teradata Studio express 16 version. But it looks like SQL Server software.

I want Teradata SQL Assistant software. Can you please help me with link ASAP.

 

Thanks in advance.