Teradata Studio 15.10 now available

Teradata Studio 15.10 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:

• Teradata 15.10 Support

Added support for Teradata 15.10 Database and embedded the Teradata JDBC 15.10 driver.

• Teradata Query Band Support

Provides support for Query Bands within the Connection Profile. Also provides support for Query Bands within the Database PROFILE object when created using the Administer Profile dialog.

• Data Source Explorer Enhancements (Add Database, Set Root, Performance Improvements)

Studio 15.10 provides an option to add one Database/User at a time to the Data Source Explorer (DSE). By setting the Data Source Explorer Load Preference to 'User Choice', the Add Database menu option appears for you to enter the name of the Database or User to add to the DSE tree. Another DSE improvement is that ability to set the ROOT of the DSE tree. By checking the Data Source Explorer Load Preference option 'Show Databases and Users in Hierarchical Display', the Set Root menu option appears for you to enter the name of the Database or User you wish to be the root of the DSE tree.

Studio 15.10 also provides Data Source Explorer load performance improvements. Two new options are available in the Data Source Explorer Load Preferences, 'Load tables space and journal details' and 'Load View Columns Data Types'. Unchecking these options will improve the time it takes to load the Tables and Views folder in the DSE.

• Result Set Viewer Enhancements (Result Set Reuse, Clear Result Sets)

Studio 15.10 added a new preference for the Result Set Viewer to allow reuse of the Result Set Viewer tab. Checking this option will cause the Result Set Viewer to reuse the current window with the new result set generated by the SQL Editor. Also added to the Result Set Viewer is a new toolbar button to clear all Result Set windows.

• Result Set Export Mode

This feature allows the user to send the query result set data to a file instead of displaying it in the Result Set Viewer. The user will set the Results Handler value on the SQL Handling Preference page. When the next query is executed, the Export Data Wizard is invoked for the user to specify the export file location and file options.

• SQL History View Enhancements

Added enhancements to the SQL History View Preferences to allow users to select the columns displayed and control the number of rows loaded in the SQL History View.

• Smart Loader and Teradata Load Enhancements

Smart Loader and Teradata Load have added an option to allow the user to specify the OS line separator or a fixed width column delimiter, as well as providing the user better control over the handling of errors in the load input file. When an error occurs trying to load the row of data, the error row is stored in an error file. An option has been added to stop the load after 'n' number of errors has occurred. The user can also restart the Teradata Load, specifiying the row number of the input file to start the load from.

Teradata Load has also added a preview panel to show a sample of the load input file based on the file options (such as column delimiter, string delimiter, encoding) chosen. This will help the user to verify that the file options are correct before starting the load.

• Aster 6.10 Support and Parser

Added support for Aster 6.10 Database and embedded the Aster JDBC 6.10 driver. Studio 15.10 also includes an Aster 6.10 Parser to detect syntax errors and provide content assist for SQL statements within the SQL Editor, along with SQL formatting and Outline view support.

• Aster Administration

Provides Aster Administration user interface for creating and dropping Database, Schema, Role, User, Table, and View objects, as well as granting and revoking privileges for all Aster objects.

• Aster Analytics Templates

Provides support for Templates View of Aster analytics templates. Users can drag and drop analytic functions from the list in the view to the SQL Editor to display a template for that analytic function.

• Aster Generate DDL Wizard and Display DDL Menu Option

These features will use the new Aster 6.10 DISPLAY command to generate and display the DDL for Aster Database objects. The menu options are provided in the Aster menu when in the Administrator perspective.

• Aster Compare Objects

Provides support for comparing two Aster database objects. The user selects an Aster object in the Data Source Explorer and then chooses the Compare With option from the Aster menu. This invokes the Aster Compare dialog for the user to select the object to compare with. The two objects' DDL are displayed side-by-side in the Eclipse Compare Editor.

• Quick INSERT, DELETE, and UPDATE SQL Templates

Provides additional templates for Teradata, Aster, and Hadoop tables using the Generate SQL menu option.

• Administer Teradata Foreign Server

Added administration support for Teradata FOREIGN SERVER objects. A user interface is provided to create, drop, and alter FOREIGN SERVER objects for Teradata Database version 15.00.02.04 and above.

• Hadoop Enhancements

Added support for Hortonworks Knox connections, Cloudera support for Hadoop to Teradata Smart Loader, and SQL-H support for Hadoop to Aster Smart Loader. Also added is HiveQL support using the HiverServer2 JDBC driver that comes embedded with Studio. HiveQL support will allow users to execute HiveQL statements in the SQL Editor and display the result set data in the Result Set Viewer.

• Install Configuration File

Studio 15.10 provides an install configuration file that allows distribution centers to create a configuration file, containing connection profile definitions, that is loaded during the install. This feature is provided with the Windows Studio install package.

Need Help?

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). 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-045C
• Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Installation Guide Publication ID: B035-2037-045K