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

Teradata Studio Express provides an information discovery tool that retrieves data from Teradata 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.6 or later for Windows and Linux platforms. Mac OSX platforms 10.7 or greater does not provide an Apple JRE. Users must install Oracle's Java Developer Kit (JDK) 1.7 or 1.8 before installing Studio.

► NOTE: If you have installed Studio Express 15.10.00.00 and are upgrading to Studio Express 15.10.00.01, you must first uninstall 15.10.00.00 then install the new 15.10.00.01 version.

► NOTE: There is an outstanding issue on Aster Database when canceling queries that can cause Studio to hang. We recommend that you do not cancel Aster queries.

README

Teradata Studio Express 15.10.00 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      - Microsoft Windows 8 and 8.1, 32-bit and 64-bit
     Ret Hat Server - Red Hat Advanced Server 2.1, 3.0, and 4.0, 32-bit
                    - Red Hat Advanced Server 4.0, 64-bit
     Red Hat Platform - Red Hat Advanced Platform 5.0, 32-bit and 64-bit
     SUSE Linux Enterprise - SUSE Linux Enterprise 9, 32-bit and 64-bit
                    - SUSE Linux Enterprise 10, 32-bit and 64-bit
                    - SUSE Linux Enterprise 11, 32-bit and 64-bit
     Apple Mac      - OSX 10.7, 10.8, 10.9, and 10.10

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

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

Supported Aster Databases Versions:
====================================
     Aster Database 5.10
     Aster Database 6.0
     Aster Database 6.10

Supported Hadoop (HiveServer2 0.13) versions:
=============================================
     HDP 2.1, 2.1.3

Required Software:
=============================
     Java Runtime Environment (JRE) version 1.6, 1.7, or 1.8
     Mac OSX 10.7 or greater does not provide the Apple JRE 1.6. Users must
     install Oracle's JDK 1.7 or 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\15.10\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.15.10.00.00-1.tar.gz
        tar -xvf TeradataStudioExpress__linux_x86.15.10.00.00-1.tar
    2) Change directories (CD) to the TeradataStudioExpress.15.10.00.00 directory
        cd TeradataStudioExpress.15.10.00.00
    3) Switch to Super User or Root and execute the RPM (Package Management) command to
       install Teradata Studio Express on Linux.
        su
        ./studioexpressinstall TeradataStudioExpress-15.10.00.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 command:
        rpm -qa TeradataStudioExpress
    To remove the Teradata Studio Express product from your Linux system, run the following
    command:
        rpm -e TeradataStudioExpress

  For Mac OS 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.
 

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\15.10\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\15.10\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 15.10:

IDE-9005 - REVERT: TD Studio converts CR/LF into a single character line separator
IDE-9210 - Object Viewer incorrect label name 'Schema' is displayed instead of 'Database'.
IDE-9211 - Aster Drag/Drop names into SQL Editor doesn't qualify names.
IDE-9212 - Right click on Aster table in DSE causes SELECT COUNT(*) on the table to be executed.
IDE-9246 - Triggers: Not more than 5 triggers are displayed in the DSE.
IDE-9308 - Studio and Studio Express fail when starting if the Data Source Explorer (DSE) is closed in previous run.
IDE-9309 - Better error reporting to user needed when HistoryActivator cannot create/connect to its Derby database
IDE-9351 - Aster Smart Loader offers INTERVAL for a column type but throws an exception when it is chosen.
IDE-9445 - nc_users and nc_all_users column schemapath has "unknown" data type.
IDE-9833 - Aster External JDBC Driver doesn't get picked up.
IDE-9895 - Result Set Viewer sorting icon reversed.
IDE-10131 - Mac 10.10 Calendar tool is not available in the Cleanup History dialog for date criteria.
IDE-10161 - Mac 10.10 Non-varchar data type column values are not allowed to be edited in Table Editor.
IDE-10292 - Result Set Viewer Aggregate command fails if language used.
IDE-10333 - Result Set Viewer Copy Cells problems
IDE-10351 - Statement cancel not responding.
IDE-10461 - Result Set Viewer displays bad tooltip if switch between grid and text mode display.

The following bug was fixed in 15.10.00.01:

IDE-10526 - Hive Hadoop JDBC binary mode (Non HTTP) connection missing jar.

Improvements
====================================
The following improvements were implemented in 15.10:

IDE-3222 - History Preferences: Allow user to select columns displayed in the Teradata SQL History View.
IDE-4858 - History Preferences: Option(s) to exclude explain statements and unsuccessful queries from display in SQL History View.
IDE-8393 - User is prompted once for parameter value if parameter name is repeated in a SQL statement.
IDE-8439 - Update the Teraedata JDBC connection property list with new options.
IDE-8547 - Smart Load: Option to set MULTISET or SET on a table.
IDE-9012 - Smart Loader improvements - add option for OS Line Feed, allow fixed length columns for input file.
IDE-9013 - Teradata Loader improvements - add options for OS Line Feed, allow fixed length columns for input file, display sample of input file based
           on the chosed file options.
IDE-9225 - History View performance improvement.
IDE-9245 - Provide Result Set Viewer option to reuse result set viewer tabs.
IDE-9314 - Improvements to Result Set Viewer table display, copy as HTML format, include background and foreground colors, option for grid lines copied,
           Transfer History highlight error rows in red.
IDE-9408 - Provide templates for Aster analytic functions.
IDE-9442 - Smart Loader and Fast Loader Improvements on error log, restart option and drop table if error occurs option.
IDE-9525 - Expanding View columns in Teradata Studio DSE takes a long time for some views. Provide option to not load view data types.
IDE-9766 - Result Set Viewer to provide toolbar option to close all open Result Set tabs.
IDE-9933 - Coding changes to address Globalization Assessment issues.

IDE-9942 - Preference to determince which profile types are displayed in New Connection Profile dialog.
IDE-9943 - Allow users to selectively add databases to the DSE.
IDE-9944 - Option to set "root" of DSE display.
IDE-9955 - Slow loading of Tables and Macros folders - provide option to not load table details or routines if folder not provided.
IDE-9988 - Result Set Viewer to use JFaceDialogFont in table display. Users can change font via Font Preference page.
IDE-10093 - Teradata Export Data Wizard to include CLIENT_CHARSET JDBC Property if provided in JDBC connection properties.