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.01.00 release builds on the 14.00.00 offering by boasting increased functionality.
A new Administer Profiles dialog has been added to allow users to create and modify database Profiles. The dialog will present the general space information, password information, and the associated users in order to create or modify the profile. Profiles are also listed in the Teradata View when selecting the Database node in the Data Source Explorer.
A new Administer Roles dialog has been added to allow users to create and modify database roles. The dialog will present the list of users and roles associated with the role in order to create or modify the role. Roles are also listed in the Teradata View when selecting the Database node in the Data Source Explorer.
New Create User Defined Type dialogs have been added to allow users to create Structured, Distinct, and Array User Defined Types for the database. Three separate dialogs are provided depending on the type of the UDT. The Create Distinct UDT dialog will create a user defined type that references a distinct, known database type. The Create Structured UDT dialog will create a structured user defined type that contains ‘C’ code for methods and functions. The Create Array UDT will create an array user defined that references a known database type with given bounds for the array. The Create Structured and Distinct UDT dialogs will provide an editable template to help the user define the UDT. A SQL Preview tab will display the SQL statement that was generated to create the UDT, allowing the user to save the SQL statement to a file, run the SQL statement, creating the UDT in the database, or show the SQL in a SQL Editor tab.
Note: All UDTs are created in the SYSUDTLIB database.
A new Find option has been added to the Teradata Menu. The Find operation will open a dialog for you to enter the search value and select a database object type. It will start the search relative to the selected object in the DSE. For example, if you have selected a connection profile node, the find operation will search all of the schemas on that Teradata server. If you have selected a specific schema (or database), the Find operation will search only that schema. Upon locating the object, the Find will select the object in the DSE. If the Teradata View is opened and in focus, the object will be opened in the Teradata View.
A Find Next option has been added to that will find the next object in the DSE tree that matched the previously entered search value and object type. Find Next can be invoked by clicking the F3 shortcut key.
Also provided is an Advanced Find dialog that allows you to choose more detailed find options and presents the list of all objects that match the search value. The Find dialog contains an Advanced Find button to invoke the Advanced Find dialog. The dialog allows the user to select the specific connection profiles or schemas to search, the type of objects for which to search, and a limit on the number of objects found. The search result list is presented in the Teradata View.
Function name overloading has not been supported in previous versions due to a bug in the Eclipse base. The bug has been fixed and Teradata has added functionality to support the function name overloading capability. Users can overload names in the Create User Defined Function dialog.
New dialogs have been added to allow the user to manage the rights on database objects.
A new dialog is provided to Clone Users. This dialog allows the user to clone a current database user, creating a new database user with a new password and the same attributes as the original database user.
A new dialog is provided to Modify Users. Users can modify the attributes of a database user, such as the associated profile, default role, password, account, fallback, journal information, time zone, date format, default character set, and space information.
A new Modify Comments action is provided in the Teradata View toolbar to allow you to easily modify comments for the following objects: Schemas, Tables, Stored Procedures, Macros, Views, Hash Indexes, Join Indexes, User Defined Functions, and User Defined Types.
A Filter option has also been added to the lists that are displayed in the Teradata View for Schemas, Tables, Macros, Stored Procedures, Indexes, User Defined Functions, User Defined Types, and Views. The user can filter the lists by a starting value, ending value, or containing value.
Additional information has been added to the Teradata View for Schemas and Tables. The Schemas view will now include creator name, access count, last access date, and ‘rights held by’ information. The Tables view will now include creator name, access count, last access date, queue table, fallback indicator, version, temporary, no primary index indicator, index number, references and users of, and statistics. Teradata IDE users can set a preference to disable these tabs if desired. Refer to the Windows>Preferences>Teradata Preference Page.
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