Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section at Teradata Plug-in for Eclipse . The 14.10.00 release builds on the 14.02.00 offering by boasting increased functionality.
Aster Schema Cache
Schema caching provides a mechanism, which stores the selected schemas locally in the format of an XML file. The user is provided with an interface for selecting which schemas to cache. Caching allows for a quicker loading time in comparison to loading the schema from the database each time.
The DSE Tree Hierarchy provides an option to display the databases in the Data Source Explorer in a hierarchical format (the flat format option is still supported as well). This provides a clearer view of relationships between databases and users. This feature also provides a set of preferences to select what to load from the database and what to display in the Data Source Explorer.
The Teradata SQL Editor provides a mechanism that allows the user to write SQL statements and execute them against a database. The Teradata SQL Editor does not replace the open source SQL Editor but instead provides a more efficient and accessible method of performing the functions. The Teradata SQL Editor includes a connection indicator, a connection profile list, an execute menu, and a save menu.
The Table Data Editor provides an enhanced feature to edit tables within the Data Source Explorer. The data in the editor is broken up into pages, which allows for efficiency in updating large tables. Along with the standard insert, update, and delete, data filtering, sorting, and in-memory filtering are also supported. The user also has the option of exporting to Excel or Text files.
The 14.10 database definition provides the XML data type in addition to existing types. Dialogs such as Create Table, Create Procedure, Create User-Defined Function, and Create UDT support the XML type for column, parameter, and return types. In the case of Java Stored Procedures and Java UDFs, the XML data type is not displayed as an option because it is not supported.
This release of Teradata Plugin for Eclipse includes various interface enhancements. The Privileges dialog has been refactored to be consistent with other platform dialogs. The dialog has been organized into Display, Grant, and Revoke tabs and there is an 'All But' option, which allows the user to grant or revoke all privileges but the ones selected in the dialog.
The Generate DDL dialog has also been enhanced; options not supported by Teradata such as the user defined string terminator and running the DDL on a server have been removed.
Change Password dialog has been added to allow users to quickly change their password.
The Smart Loader for Teradata is now available outside of Teradata Data Lab. Users can invoke the Smart Loader by right clicking on the Tables folder for a Database and choose the Smart Load Data option.
Teradata Plug-in for Eclipse has been cerified on Mac OSX. This includes the Java Wizards (Java Stored Procedure, Java UDF, and Web Service creation).
If you are new to the Eclipse world, 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 and post your question.
Online Help can be accessed within the plug-in in two ways:
Reference Documentation can be found on the download page or at: www.info.teradata.com