Teradata Studio Express 16.00.01.00 for Windows i386 32-bit
Teradata Studio Express 16.00.01.00 for Windows x86 64-bit
Teradata Studio Express 16.00.01.00 for Linux 32-bit
Teradata Studio Express 16.00.01.00 for Linux 64-bit
Teradata Studio Express 16.00.01.00 for Mac OS
Teradata Studio Express Documentation 16.00.01.00
About this download

Teradata Studio Express provides an information discovery tool that retrieves data from  Aster, Teradata, and Hadoop Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio Express, refer to the article Teradata Studio Express.

Teradata Studio Express contains several open-source components. A package containing the source code and licenses for these components is also available for download. This package does not contain proprietary Teradata source code.

Teradata Studio Express is a fully supported product by Teradata. 

For community support, please visit the Teradata Studio Forum.

► NOTE: This version requires Java Runtime Environment(JRE) 1.8. Mac OSX platforms 10.7 or greater does not provide an Apple JRE. Users must install Oracle's Java Developer Kit (JDK) 1.8 before installing Studio Express.

README

Teradata Studio Express 16.00.01 release information.

Supported Platforms:
=============================
     Windows Vista  - Microsoft Windows Vista Enterprise, 32-bit and 64-bit
     Windows Server - Microsoft Windows Server 2003, 32-bit and 64-bit
                    - Microsoft Windows Server 2008, 32-bit and 64-bit
     Windows 2000   - Microsoft Windows 2000, 32-bit
     Windows 7      - Microsoft Windows 7, 32-bit and 64-bit
     Windows 8 and 8.1 - Microsoft Windows 8 and 8.1, 32-bit and 64-bit
     Windows 10     - Microsoft Windows 10, 32-bit and 64-bit
     Ret Hat Server - Red Hat Advanced Server 5.0,6.0, and 7.0 64-bit
     Red Hat Platform - Red Hat Advanced Platform 5.0, 6.0, and 7.0 32-bit and 64-bit
     SUSE Linux Enterprise - SUSE Linux Enterprise 10, 32-bit and 64-bit
            - SUSE Linux Enterprise 11, 32-bit and 64-bit
            - SUSE Linux Enterprise 12, 32-bit and 64-bit
     CentOS 7       - 7, 32-bit and 64-bit
     Apple Mac      - OSX 10.7, 10.8, 10.9, 10.10, and 10.11

Minimum Memory Required:
====================================
     4GB Memory, but 6GB Memory desired

Supported Teradata Database Versions:
=====================================
     Teradata Database 14.00
     Teradata Database 14.10
     Teradata Database 15.00
     Teradata Database 15.10
     Teradata Database 16.00

Supported Aster Databases Versions:
====================================
     Aster Database 6.0
     Aster Database 6.10
     Aster Database 6.20
     Aster Database 7.0 (Aster on Hadoop)

Supported Hadoop (HiveServer2 0.14) versions:
=============================================
     HDP 2.3, 2.4, 2.5
     Cloudera 5.4, 5.7, 5.8

Required Software:
=============================
     - Java Runtime Environment (JRE) version 1.8
     - Mac OsX 10.7 or greater does not provide the Apple JRE. Users must
     install Oracle's JDK (not JRE) 1.8

Install Instructions;
=============================
     Download the Teradata Studio Express zip file from the download site.

  For Windows install:
     1) Unzip the Teradata Studio Express package to your local file system.
     2) Run the setup.exe to launch the Teradata Studio Express installation.
     3) Teradata Studio Express is installed in the Program Files directory.
        For example, C:\Program Files (x86)\Teradata\Client\16.00\Teradata Studio Express.
    When Teradata Studio Express is started, a 'workspace' directory is created in your
    home directory (C:\Users\<user>\workspace). This directory contains
    workspace files, including the SQL project folder. The teradata.log file is
    located in the install \configuration directory.


  For Linux install:
    1) Unzip and untar the Teradata Studio Express package to your local file system.

        gunzip TeradataStudioExpress__linux_x86.16.00.01.00-1.tar.gz
        tar -xvf TeradataStudioExpress__linux_x86.16.00.01.00-1.tar

    2) Change directories (CD) to the TeradataStudioExpress.16.00.01.00 directory

        cd TeradataStudioExpress.16.00.01.00

    3) Switch to Super User or Root and run the Studio Express install script, passing
       the Studio Express RPM (Package Management) package

        su
        ./studioexpressinstall TeradataStudioExpress-16.00.01.00-1.x86.rpm

    4) Provide the path to where you would like to install Teradata Studio Express.
       The default location is /opt/teradata. When Teradata Studio Express is started, a workspace
       directory is created in the location where you launched Teradata Studio Express (TeradataStudioExpress) from.
       This directory contains workspace files, including the SQL project folder.
       The teradata.log file is located in the install /configuration directory.

    Note: To check whether Teradata Studio Express is installed or not, run the following RPM command:

        rpm -qa TeradataStudioExpress

    To remove the Teradata Studio Express product from your Linux system, run the following RPM command:

        rpm -e TeradataStudioExpress

  For Mac OSX Install:
    1) Unzip the Teradata Studio Express package to your local file system.
    2) Double click on the Teradata Studio Express.pkg package to invoke the Teradata Studio Express installer
    3) You can change the install location or use the default install location, which is the
       /Applications/TeradataStudioExpress folder. When Teradata Studio Express is started, a 'SQLA' folder is created in the
       user's Documents folder. This folder contains the workspace files, including the SQL
       project folder. The teradata.log file is located in the install /configuration directory.
 
    To uninstall Studio on the Mac OSX, open a Terminal window and run the Studio Express uninstall script:

       . ./studio_uninstall.sh


Running Teradata Studio Express:
================================
    Windows:
       Double click the Teradata Studio Express desktop icon shortcut.

    Linux:
       Update your path variable to include the TeradataStudioExpress directory. Execute TeradataStudioExpress.

    Mac:
       Execute Teradata Studio Express in the TeradataStudioExpress directory.



Changing the Teradata Studio Workspace and/or Configuration information directories
 - (using Roaming Profiles):
=====================================================================================
When Teradata Studio Express is launched, it creates a workspace directory (called workspace) in your
<USER HOME> directory. If you want to change the location of your workspace directory, you must pass
the -data option into the TeradataStudioExpress executable. You can do this by changing the Target
parameter in the Windows desktop shortcut or in the command window when launching Teradata Studio Express.
For example:

"C:\Program Files (x86)\Teradata\Client\16.00\Teradata Studio Express\TeradataStudioExpress.exe"
-data "c:\Teradata Studio Express\My Workspace"

There is another directory (called .eclipse) created in your <USER HOME> directory that contains configuration
information and jars for launching Teradata Studio Express. If you want to change the location of your configuration
directory, you must pass the -configuration option into the TeradataStudioExpress executable. You can do this by changing
the Target parameter in the Windows desktop shortcut or in the command window when launching Teradata Studio Express.
For Example:

"C:\Program Files (x86)\Teradata\Client\16.00\Teradata Studio Express\TeradataStudioExpress.exe"
-configuration "c:\Teradata Studio Express"

You can combine both the -data and -configuration options on a single command line as well. This is often needed
when using a Roaming Profile that is not always accessible when running applications.


Bug Fixes
====================================

The following bugs were fixed in 16.00.01:

IDE-14512    TD Studio does not display details under the Teradata Labs tab
IDE-17501    In SQL Editor star (*) is showing in editor tab even SQL save. Refer SQL.PNG
IDE-17590    Presto enabled in Connection Profile if Knox selected
IDE-17591    Cloudera Existing Connection Profile - Properties Page - Test Connection uses HortonworksConnection
IDE-17617    Data Transfer: The process just hangs since the update to 15.10.02 15.12.00. Exporting few hundred rows and the process ran for hours.
IDE-17712    Help table of contents missing
IDE-17722    Copy table TD to TD showing 0 rows transferred when actually transferred 65533
IDE-17743    Load table data always uses FastLoad protocol, even if only 45 rows
IDE-17888    SQL History SQL statement has lost the leading comment - Regression

The following bugs were fixed in 16.00:

IDE-12819    Redhat 7 and Amazon Redhat - Format the Result set --> Format the Result set is not working
                   in Redhat 7 and Amazon Redhat
IDE-14695    Row Count on more than 15 tables causes "Response limit exceeded."
IDE-14791    Result Set Viewer preference error message
IDE-15209    Hadoop Refactoring --> Confirm Dialog message box is not displayed when clicking on OK button
                   after updating the Hadoop Profile name in the Properties dialog and updated Hadoop Profile
                    name in the Navigator/DSE with entered name
IDE-15549    Project Explorer 'Execute SQL Files' does nothing when press OK
IDE-15824    Preconfigured Data Sources mechanism does not support JDBC HTTP Transport Mode property
IDE-15878    Error when using default editor with previously imported Hadoop profile
IDE-15937    JOIN/HASH --> Hash/Join Index is displayed without ‘Database name’ prefix when index dragged
                   and dropped on SQL Editor
IDE-16067    Result set Format settings lost on cancel operation
IDE-16225    Getting NullPointException for Sample Contents on empty table from Hadoop system.
IDE-16233    Certify CDH 5.8 with Studio Testing --> Unhandled event loop exception is thrown when clicking
                   on ‘Toggle Result Set display as Text or Grid’ toolbar button in the ‘Teradata Result Set Viewer’
                   after selecting the Sample Contents option for a Hadoop table
IDE-16441    Only check for EXPLAIN for Teradata
IDE-16517    Japanese Localization Bugs in the 15.12 release
IDE-16774    Studio with ASTER treating "?" mark in reset function as query parameter
IDE-16814    Teradata/Aster --> 'Row Count' tooltip is displayed incorrectly for Views
IDE-16833    Need to update wording on notification dialog
IDE-16896    Teradata Studio 15.12 - Open SQL File does not work.
IDE-17092    In JDBC Connection profile, every field has Key board shortcut key other than 'Cancel' button
                   and 'LDAP Security enabled' check box.
IDE-17366    Externalize SQL Formatter preference and routine editor
IDE-17397    Load Data and Export Data have Error Dialogue loops when connection got timed out


Improvements
====================================

The following improvements were made in 16.00.01:

IDE-10476    Unable to logon to Teradata DB using SSO/Kerberos in Studio v 15.0
IDE-14432    Support Kerberized cluster for Hortonworks and Cloudera
IDE-17725    Propagate WebHDFS username to WebHCAT username for new Hadoop Connection Profile
CLNTINS-7021    Automate some steps to support use of SSO/Kerberos with Studio and Studio Express

The following improvements were made in 16.00:

IDE-14769    mm/dd/yyyy hh:mm:ss timestamp format is not recognized in external data transfer
IDE-14237    Provide a preference for setting number of decimal places on Float values displayed in the Result set viewer
IDE-11792    Result Set Viewer preference to specify numeric format pattern
IDE-14670    Provide option to choose the date format in the Result Set Viewer
IDE-14678    Provide option to display binary data in the Result Set Viewer with dashes
IDE-14679    Provide option to display BigInt and Decimal(16)+ values as Strings for Excel
IDE-13583    Result Set Viewer - add preference for displaying TIME values
IDE-14325    Provide direct string substitution for parameters in SQL Editor like SQL Assistant does
IDE-11839    Specify the location of the history file.


HORTONWORKS SELF_SIGNED CERTIFICATES:
=====================================

The certificate used by the Knox server needs to be added to the Java runtime's certificate store. You can save the certificate with a web browser.
For example, with Chrome, you can:
•    Enter the Knox server:port in the address bar. It will say that the connection is not private
•    Click Advanced, then click on the Proceed to site link
•    Click on the lock in the address bar and select Details
•    Click View certificate
•    Select the Details tab in the resulting dialog and click the Copy to file... button
•    In the resulting Certificate Export Wizard, save the certificate as Base-64 encoded

(Other browsers have similar methods to get to the Certificate Export Wizard)

Alternatively, on the Knox server, run the command:

     keytool -export -alias gateway-identity -rfc -file knox.crt -keystore <path to gateway.jks keystore (eg. /usr/lib/knox/data/security/keystore/gateway.jks)>

To install the certificate into your Java Runtime certificate store, run the command:
     %JDK_HOME%\bin\keytool.exe -importcert -alias "TDH240 Knox self-signed certificate" -file cert_location/<filename>.txt -keystore %JRE_HOME%\lib\security\cacerts
Where %JDK_HOME% is an environment variable with the location of a JDK and %JRE_HOME% is the location of the JRE used to run Studio.

The keytool.exe will ask for the password to the certificate store. It is “changeit” unless you’ve changed it