Teradata Studio Express 14.02 now available

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.02 now available

Teradata Studio Express 14.02 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:

  • Aster Database Support

Support is provided for Teradata’s Aster Database. Users can create connections for an Aster Database using the Aster Connection Profile Wizard. The Data Source Explorer will display Aster Databases, Schemas, Tables, Views, and Map Reduce Functions. SQL Templates are provided to help users create Aster SQL commands. SQL statements can be executed against an Aster Database, with result set data displayed in the Result Set Viewer and history entries stored in the Teradata SQL History. The Teradata View also supports the display of more detailed information about Aster Database objects.

  • Data Lab Support (Smart Load, Copy Table)

Teradata Data Lab provides the DBA the flexibility to provision space within the data warehouse. Teradata Studio provides an option for Data Lab customers to easily load data from an Excel or CSV file (Smart Load) as well as copy tables from their Teradata system into their Data Lab. Tables can be dragged from the Data Source Explorer and dropped in the Data Lab View, invoking the Data Lab Copy Table wizard. The Copy Table wizard will copy the table in addition to the table data to the Data Lab. A filtering option is provided to filter out unwanted columns or certain data within the columns. The Smart Load option is provided by selecting the Tables folder within the Data Lab.

  • Excel 2007 (.xlsx) Support

Support for Excel 2007 (.xlsx) has been added when exporting table data or result set data to Excel. Previously, only Excel 97-2003 was supported. This allows users to export over 65,536 rows of data to an Excel spreadsheet.

  • Quick Tour Help Option

When bringing up Teradata Studio Express for the first time, a Quick Tour slide show is presented to help the user familiarize themselves with the basic features of Teradata Studio Express.

  • Result Set Viewer Performance Improvement

Performance improvements have been made to the Result Set Viewer to significantly reduce the amount of time it takes to display the result set data.

  • Teradata Load and Extract

Teradata Load and Export provides an enhanced load and export feature to quickly load or export the data to and from tables within the Data Source Explorer. The Teradata Load feature will use criteria such as number of rows, column types, and existing table data to determine whether the Teradata JDBC FastLoad option will be used, otherwise JDBC batch operations are performed. Teradata Load and Export support both Excel 97-2003 .xls and Excel 2007 .xlsx file formats.

Filtering has been added to the Teradata Export wizard. The user can choose to filter out certain columns, as well as filter out certain data within a column.

  • Upgrade Eclipse 3.7.2 and DTP 1.10.1

This release of Teradata Studio Express has upgraded its version of Eclipse to version 3.7.2 and its version of Eclipse Data Tools Platform to 1.10.1.

Need Help?

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express. 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:

  • From the main menu: Help > Help Contents > Teradata Studio Express
  • Context sensitive help: When a user is in a dialog, they can hit the F1 key to retrieve help text sensitive to where they are within the dialog.

Reference Documentation can be found on the download page or at: www.info.teradata.com

  • Title: Teradata Studio Express Release Definition  Publication ID: B035-2036-122C

Re: Teradata Studio Express 14.02 now available


I installed Teradata Express 14 and Teradata Studio Express on Windows 7 32bits machine. Teradata DB working fine but I am facing problem with Studio Express.

No screen pops-up when I double click Terdata Studio Express. I check all the folders in my working directory but still not able to figure out the problem.

Please advice the solution.

Teradata Employee

Re: Teradata Studio Express 14.02 now available

Please verify that you downloaded the 32-bit Windows version of Teradata Studio Express and running the 32-bit JVM. There is possibly a configuration log in the install location /configuration directory, if an error occurred trying to launch Studio Express.  The Studio Express error log is in your workspace directory, in .metadata/Teradata/teradata.log. 


Re: Teradata Studio Express 14.02 now available

Hi I have installed Teradata express studio to learn practicles on the same. But I am not able to connect database with studio express, I am not able to see employee table and department table.  Do I need to create the database from scratch or I get sample database installed with the studio express. Please let me as soon as possible, I am trying to connect since last 3-4 days without any success.

Teradata Employee

Re: Teradata Studio Express 14.02 now available

@sarang_rk, Just to clarify, Tereadata Express is a sample database provided on the Download site (http://downloads.teradata.com/download/database/teradata-express/vmware), that runs in a VMWare or EC2 environment. Teradata Studio Express is our client product that connects from your desktop to your Teradata Database (Teradata Express). These are two separate products and two separate downloads. Teradata Express has some sample data loaded. Studio Express does not provide database tables.

Using Teradata Studio Express, you can enter DDL statements, to create databases and tables, in the SQL Editor. You will need to first connection to your Teradata Database.

Re: Teradata Studio Express 14.02 now available

i downloaded Teradata studio Express and installed on my PC. when i try to connect, i get the 'Ping Failed' Error. What could be the reason for this error?

Teradata Employee

Re: Teradata Studio Express 14.02 now available

@asridhar7, The ping tries to establish a connection with the Teradata Server. Click the Details button to see the details of the exception. There are many reasons why your ping could have failed.

Re: Teradata Studio Express 14.02 now available

i was able to connect now, once i gave the Database details. Thanks for your help.


Re: Teradata Studio Express 14.02 now available


I'm running Studio Express in OSX, and I'm wondering if there is some hidden option that would allow me to copy column headers with the result set to the clipboard for pasting into other text editors/Excel.

That's one feature from SQL Assistant that I'm missing after my switch to OSX.

Many thanks!

Teradata Employee

Re: Teradata Studio Express 14.02 now available

@neckers, We have added this capability (Result Set Viewer preference to include Column Headers) in our upcoming release of Studio Express 14.10. We are in final testing of this release and hope to have it available on Developer Exchange download very soon.