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.
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.
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.
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.
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. 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.
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.
Provides additional templates for Teradata, Aster, and Hadoop tables using the Generate SQL menu option.
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 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.
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.
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
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"
@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:
Value Name: allowtgtsessionkey
Value Type: REG_DWORD
2) - For Teradata JDBC Driver, create the TeraJDBC.config file and place it in your install directory.
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:
4) Also add for SSO:
5) Check you krb5.ini file, located under C:\Windows or C:\winnt. You can also set the location the .ini:
6) Run kinit - give kerberos password for your login
7) Launch Studio Express