Teradata Studio Express 14.00 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

Teradata Studio Express 14.00 now available

Teradata Studio Express 14.00 (formerly Teradata SQL Assistant Java Edition) is now available for download. Teradata Studio Express 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 Teradata Studio Express to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

What's New:

  • Product Re-Branding

Teradata Studio Express has replaced Teradata SQL Assistant Java Edition. Stay tuned for more information on future Teradata Studio Family product offerings.

  • Custom attributes for DBC artifacts

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.

  • History Cleanup Dialog

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 execute 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.

  • Import from SQLA History XML files

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.

  • JDBC Property Configuration 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 and allows for deployment of Teradata Studio Express with a different set of JDBC properties. An empty JDBC Configuration File indicates that no JDBC properties will be set and connections will use the JDBC driver default values.

  • Logging Options

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.

  • Result Set Viewer Improvements

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.

  • Toggle Button Auto Activation of Code Assist

A new toolbar button,  , has been added to the main, topmost toolbar that allows the user to toggle on the auto activation of code assist. Code assist provides drop down syntax suggestions as you pause while entering your SQL statement in the SQL Editor. This operation uses metadata from the database so for large databases the operation can take a long time. Code assist is turned off when Teradata Studio Express is initially installed.  You can turn it on by clicking the Code Assist toggle button.

  • User Control of Visible Tabs within Teradata View

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.

 

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express.

33 REPLIES
Enthusiast

Re: Teradata Studio Express 14.00 now available

where we can download and install in windows xp
Teradata Employee

Re: Teradata Studio Express 14.00 now available

Here is a link to the download page :
http://downloads.teradata.com/download/tools/teradata-studio-express
Enthusiast

Re: Teradata Studio Express 14.00 now available

Well, I tried to install on a windows 7 PC 32 bit OS and I get the error message - Source file not found for data1.cab. I saved to desktop. In order to work I had to copy the .cab file to the temp location ' C:\TEMP\Temp1_teradatasqla__win32_x86.14.00.00.00.zip\teradatasqla__win32_x86.14.00.00.00'
and it worked.
Teradata Employee

Re: Teradata Studio Express 14.00 now available

I just did a download as well, unzipped into my install directory and the Data1.cab file is there. I ran the setup.exe and the install was successful. Was there any problems during your download? It sounds like the second download got it all.
Enthusiast

Re: Teradata Studio Express 14.00 now available

Well I ran the studio express msi file. should that be a problem for not having the data1.cab file?
Teradata Employee

Re: Teradata Studio Express 14.00 now available

The data1.cab file should be there. I just did a download and it was there?
Enthusiast

Re: Teradata Studio Express 14.00 now available

I figured it out. I haven't extracted the zip file.

Re: Teradata Studio Express 14.00 now available

Looks like I need "Java Runtime Environment (JRE) version 1.6 or greater." How can I tell if that is installed on my system? (Please also post the instructions on the Download page.)
Teradata Employee

Re: Teradata Studio Express 14.00 now available

To find out what version of java you are running, open a dos window and enter: java -version