SQL Assistant Java Edition 13.11 now available

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

SQL Assistant Java Edition 13.11 now available

Teradata SQL Assistant Java Edition release 13.11 is now available for download. SQLA JE is an information discovery tool for retrieving and displaying data from your Teradata Database systems. 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 SQL Assistant Java Edition to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

What's New:

  • Updated for Eclipse 3.6.2 and DTP 1.8.2
  • Connection Handling of Expired Passwords

Passwords can expire. In many cases the original password is a temporary password and the user is expected to change it when logging on for the first time. It is now recognized when a password expires (SQL Warning error code: 3032) and the user is prompted for the new password. The connection is retried with the JDBC property ‘NEW_PASSWORD’ set to the new password and the new password is saved in the profile.

  • Execute SQL Files from the Project Explorer

This feature provides the ability to execute one or more SQL files from within the Project Explorer. The user can select the SQL file(s) and right click and choose the Execute Teradata SQL Files option. If multiple SQL files are selected, a dialog is displayed to confirm the connection profile for the SQL files. If a parameterized query is contained within the SQL files, the user is prompted for the parameter values.

  • Explain SQL Shortcut Key

This feature provides the ability to generate the Database EXPLAIN results from a SQL statement by pressing the F6 key or clicking the Explain icon, , in the toolbar. The EXPLAIN results are displayed in the Teradata View window.

  • Import/Export SQL History

This feature provides the ability to export and import the history information from the Teradata SQL History to an external file. This ability allows SQL statements, which are part of the SQL History, to be shared between installations of SQLA JE. New Export and Import menu items are provided as part of the Teradata SQL History View toolbar.

  • LOB Support

LOB support includes the ability to view LOBs within the Result Set Viewer, and include LOBs as parameters when running parameterized SQL. When a query result is being processed and a result column contains an LOB, a dialog appears. The dialog requests information about where the LOB values are to be stored on the file system, what the base name of the file is to be (initially the column’s name), what the file extension should be, whether the contents of image values are to be shown as images in the result set view, and whether image values are to be saved when the images are displayed in the result set view. When LOBs are needed for parameters to a SQL statement, the Configure Parameters dialog allows the user to specify the location of the LOB file.

  • Manual Option for JDBC Properties

This feature provides an option for users to manually enter a JDBC property and its value. This is useful when non-standard JDBC properties are required for the Teradata connection. In the drop down list of JDBC Properties, scroll down to the bottom and select the USER_ENTERED_PROPERTY option. A dialog appears for you to enter your JDBC property name and its value. The name/value pair is then stored and passed to the JDBC driver when creating a connection to the Teradata Database.

  • Row Count Menu Option

This feature provides a Row Count menu option when a table is selected from the Data Source Explorer. Select the table from the Data Source Explorer and click Data>Row Count. A dialog with the number of rows for the table appears.

  • Schema Cache Option

The Schema Cache option allows the user to designate particular schemas (databases/users) to be cached. A schema cache file that contains the metadata for the schema is created. The metadata describes all of the information about the schema, such as its tables, columns, constraints, indexes, macros, parameters, stored procedures, user defined functions, user defined types, views, and so forth. The schema cache is associated with the connection profile. If the connection profile is deleted, so is the schema cache list and any schema cache files that were created. The schema cache files are stored in the workspace/metadata directory.



When the user first connects to the database and opens the Schemas folder, the schema cache file is created in a background job. Once the cache is created, if the user refreshes the list of schemas (by clicking the Refresh menu option on the Schemas folder), the cached schemas are loaded from the schema cache file. The schema is then highlighted within the Data Source Explorer with the cache icon, . Note that any modifications made to objects of a cached schema are not immediately reflected in the cache. The user must refresh the schema cache for those changes to take effect.

  • Support for Oracle, IBM DB2, and SQL Server Database Connections

This feature allows you to create connection profiles for Oracle, IBM DB2, and SQL Server databases. Support is provided by the standard Eclipse Data Tools Platform functionality. Note that SQL result set data for other database connections is displayed in the SQL Results View instead of the Teradata View, used only for Teradata Database connections.

 

For more information on using Teradata SQL Assistant Java Edition, refer to the article, SQL Assistant Java Edition.

7 REPLIES
Enthusiast

Re: SQL Assistant Java Edition 13.11 now available

Would you please see forum post at http://forums.teradata.com/forum/tools/sql-assistant-java-edition-13-11-on-vista -- I'd love some help. Thanks.
Enthusiast

Re: SQL Assistant Java Edition 13.11 now available

Is it possible to change default result handling from TERADATA RESULT SET VIEWER to simply SQL Results?
When performing "sample contents" results are dislplayed in SQL Results but every other statement run from editor always ends in teradata window.
Teradata Employee

Re: SQL Assistant Java Edition 13.11 now available

We are moving toward all queries that come from Teradata will use the Teradata Result Set Viewer. There is currently not an option to choose the SQL Results view for Teradata result sets.
Enthusiast

Re: SQL Assistant Java Edition 13.11 now available

From where do I download SQLA JE? I donot see anything in downloads section or on T@YS site. Can someone please help.

Senior Apprentice

Re: SQL Assistant Java Edition 13.11 now available

SQLA JE has been renamed, it's Teradata Studio/Teradata Studio Express :-)

Dieter

Re: SQL Assistant Java Edition 13.11 now available

Hi where I can get the link to download teradata sql assistant for MAC.

Teradata Employee

Re: SQL Assistant Java Edition 13.11 now available

Arnav, Teradata SQL Assistant does not run on the Mac OSX. You can download Studio Express for Mac OSX at: http://downloads.teradata.com/download/tools/teradata-studio-express