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

  • Teradata 15.10 Support

Added support for Teradata 15.10 Database and embedded the Teradata JDBC 15.10 driver.

  • Teradata Query Band Support

Provides support for Query Bands within the Connection Profile.

  • Data Source Explorer Enhancements (Add Database, Set Root, Performance Improvements)

Studio Express 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.

Studio Express 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.

  • Result Set Viewer Enhancements (Result Set Reuse, Clear Result Sets)

Studio Express 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.

  • Result Set Export Mode

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.

  • SQL History View Enhancements

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 Enhancements

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.

  • Aster 6.10 Support and Parser

Added support for Aster 6.10 Database and embedded the Aster JDBC 6.10 driver. Studio Express 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.

  • Aster Analytics Templates

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.

  • Quick INSERT, DELETE, and UPDATE SQL Templates

Provides additional templates for Teradata, Aster, and Hadoop tables using the Generate SQL menu option.

  • Display Teradata Foreign Server

Added ability to display Teradata FOREIGN SERVER objects in the DSE and Object Viewer for Teradata Database version 15.00.02.04 and above.

  • HiveQL Support

HiveQL support uses the HiverServer2 JDBC driver, that comes embedded with Studio Express, to allow users to execute HiveQL statements in the SQL Editor and display the result set data in the Result Set Viewer. The Connection Profile Wizard has added a Hortonworks Connection type that supports JDBC via Knox and direct JDBC type connections.

  • Install Configuration File

Studio Express 15.10 provides an install configuration file that allows distribution centers to create a configuration file, containing connection profile definitions, that is loaded during the install. This feature is provided with the Windows Studio Express install package.

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.
  • Also, the Quick Tour provides a quick overview of Teradata Studio Express features. Go to Help > Welcome.

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

  • Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Release Definition Publication ID: B035-2040-045C
  • Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Installation Guide Publication ID: B035-2037-045K

 

Discussion
SAP 1 comment Joined 08/14
12 Feb 2016

Hi Grimmer ,
I was just looking if teradata studio express have any option to Teradata with SSO login or Active directory authentication or Kerberos Authentication . Similar to the one , we have in SQLA , the option "integerated Security"
Thanks
 

SAP

fgrimmer 660 comments Joined 04/09
15 Feb 2016

@SAP, Studio Express supports SSO, allowing you to leave the username and password blank for Kerberos (KRB5) authentication mechanism. 
For Single SignOn (SSO) on Windows:
1) By default, Windows does not allow the TGT session key to be accessed.  Add the following registry key so that the TGT session key is accessible and Java can use it to acquire additional service tickets.
For Windows 2003 and Windows Vista, Win7 (and later versions of Windows), the registry key and value should be:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\Kerberos\Parameters
Value Name: allowtgtsessionkey
Value Type: REG_DWORD
Value: 0x01
2) - For Teradata JDBC Driver, create the TeraJDBC.config file and place it in your install directory.
-------------------------------------------------------
com.sun.security.jgss.initiate
{
com.sun.security.auth.module.Krb5LoginModule sufficient
useTicketCache=true;
};

other
{
com.sun.security.auth.module.Krb5LoginModule required ;
};
-------------------------------------------------------
 
3) Modify TeradataStudioExpress.ini file:
- Place TeraJDBC.config file in TeradataStudioExpress directory where the executable is and modify TeradataStudioExpress.ini to include a reference to its location:
-Djava.security.auth.login.config=c:/Program Files/Teradata/Client/15.10/TeradataStudioExpress/TeraJDBC.config
4) Also add for SSO:
-Djavax.security.auth.useSubjectCredsOnly=false
5) Check you krb5.ini file, located under C:\Windows or C:\winnt. You can also set the location the .ini:
 
-Djava.security.krb5.conf=C:\terajdbc\krb5.ini

6) Run kinit - give kerberos password for your login
7) Launch Studio Express

You must sign in to leave a comment.