Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Plug-in for Eclipse) . The 14.00.00 release builds on the 13.11.00 offering by boasting increased functionality.
Access and Query Logging Rules dialogs have been added. They are available from the Data Source Explorer for schema level objects. They allow the user to configure and display Teradata Access Logging Rules and Teradata Query Logging Rules.
An authorization makes an association between a database user and an operating system server user identification. The authorization allows an external routine to run in secure mode using the context, privileges, and access control accrued to the specified operating system user. The Create Authorization dialog is available in the Data Source Explorer for schema level object. It will allow users to create and drop user authorizations.
The Custom Attributes provides the ability for users to specify additional attributes for objects displayed in the Teradata View. When objects of the type are displayed in the Teradata View, additional tabs containing the attributes’ values will be provided. Single attributes or a collection of attributes are displayed in a table format.
The custom attributes are defined in an XML file that is located in the user's workspace .metadata/Teradata directory. The XML file contains information about the type of object, name, tooltip and icon for the Teradata View’s tab, and the query that will run to retrieve the object’s attributes.
MyBatis has replaced iBatis. MyBatis provides a lightweight SQL mapping framework for Java. The Teradata IDE wizards allow you to switch between MyBatis and iBatis for your underlying database mapping framework. The MyBatis upgrade supports Spring 3.05.
A custom data type handler allows the user to provide custom processing or support an unsupported type, such as a Teradata User Defined Type, within their Java application. A new wizard is provided to help the user define the custom data type and its handler that uses the iBatis(MyBatis) framework. Custom data type handlers can be used with other iBatis(MyBatis) wizards.
A Cleanup History dialog has been added to the Teradata SQL History toolbar to help the user clean up the history. The dialog allows the user to specify one or more criteria to match the rows that they wish to delete. They can also select an option to delete all duplicate queries. In order to be considered duplicate, both the data source and the SQL statement must be identical. In deleting duplicates, all except the most recently executed entry will be deleted. The Cleanup Dialog will also allow the user to compact the SQL History database. The compact feature works by freeing up unused allocated space
The iBatis(MyBatis) Stored Procedure Wizard will wrap a Teradata Stored Procedure into an iBatis SQL Map. The iBatis SQL Map can then be used to generate a DAO and create a Web Service or be used by a Java application that uses the iBatis framework. The iBatis(MyBatis) Stored Procedure Wizard is launched from a Stored Procedure object in the Date Source Explorer. It will create an iBatis SQL Map and Java class for the parameter information. The iBatis SQL Map will contain the parameter mapping and SQL statement to call the Stored Procedure.
The iBatis(MyBatis) Macro Wizard will wrap a Teradata Macro into an iBatis SQL Map. The iBatis SQL Map can then be used to generate a DAO and create a Web Service or be used by a Java application that uses the iBatis framework. The iBatis(MyBatis) Macro Wizard is launched from a Macro object in the Date Source Explorer. It will create an iBatis SQL Map and Java class for the parameter information. The iBatis SQL Map will contain the parameter mapping and SQL statement to call the Macro.
This feature provides the option to import the SQL Assistant history in XML format. The Teradata SQL History import dialog now provides an option to import a SQL Assistant History (.xml) file.
Users have the option to provide a JDBC Property Configuration File that acts as the default list of JDBC properties when creating a new connection profile. The JDBC Property Configuration File is located in the user's workspace .metadata/Teradata directory. An empty JDBC Configuration File indicates that no JDBC properties will be set and connections will use the JDBC driver default values.
Log messages are now stored in the teradata.log file, located in the user's workspace .metadata/Teradata directory. There is also a Teradata Log console view, which can be used to display log messages. The logging levels of the two displays are independently controlled and can be set in Teradata Datatools Preferences page.
In previous releases, the Teradata Result Set Viewer was displayed inside the Teradata View. It has now been moved to its own view display, allowing users to view result sets at the same time as viewing database object information in the Teradata View. Additionally, the Result Set Viewer has added a toolbar button to allow users to rename result set tabs and made performance enhancements when displaying large result set data.
The SQL User Defined Function (UDF) Dialog allows users to define their own UDFs written using SQL expressions. The dialog is available on the User-Defined Functions folder in the Data Source Explorer. The dialog will create and submit the DDL for the SQL UDF.
This feature provides the ability to hide tabs that are displayed in the Teradata View for database objects. Tabs that provide details of the database objects can be hidden by pressing the tab’s close button. Tabs that are hidden will not be displayed when objects of that type are later shown in the Teradata View. Hidden tabs can be restored by selecting the “Restore Tabs” button or menu item in the Teradata View’s toolbar.
A tab’s visibility can also be managed in the Teradata Datatools Preferences page. The Teradata View Object Visibility preference page displays a list of the Teradata View tabs whose visibility can be set. Tabs with their checkboxes checked will be shown in the Teradata View when appropriate. Tabs that are unchecked will not be displayed.
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.
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