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 15.10 release builds on the 15.00.02 offering by boasting increased functionality.
Teradata 15.10 Support
Added support for Teradata 15.10 Database and embedded the Teradata JDBC 15.10 driver.
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.
Teradata Plug-in for Eclipse 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.
Teradata Plug-in for Eclipse 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.
Teradata Plug-in for Eclipse 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.
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.
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 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.
Added support for Aster 6.10 Database and embedded the Aster JDBC 6.10 driver. Teradata Plug-in for Eclipse 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.
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.
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.
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.
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.
Provides additional templates for Teradata, Aster, and Hadoop tables using the Generate SQL menu option.
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.
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 Teradata Plug-in for Eclipse. HiveQL support will allow users to execute HiveQL statements in the SQL Editor and display the result set data in the Result Set Viewer.
Provides an option to create a udaSQL project that contains the ANT libraries used to create ANT scripts for running SQL.
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