Teradata Studio

Teradata Studio is an administration tool for creating and administering database objects. It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio, refer to the article Teradata Studio.

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

For community support, please visit the Tools Forum.

► NOTE: This version requires Java Runtime Environment 1.6 or greater. (To find out what version of Java you are running, open a DOS window and enter: java -version)

README

Teradata Studio 14.02.00 release information.

Supported Platforms:
=============================
     Windows Vista - Microsoft Windows Vista Enterprise, 32-bit and 64-bit
     Windows XP Professional - Microsoft Windows XP Professional, 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, 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
     Apple Mac - OSX 10.5, 10.6, and 10.7

Supported Teradata Databases Versions:
======================================
     Teradata Database V2R6.2
     Teradata Database 12.0
     Teradata Database 13.0
     Teradata Database 13.10
     Teradata Database 14.00

Supported Aster Databases Versions:
======================================
     Aster Database 5.0

Required Software:
=============================
     Java Runtime Environment (JRE) version 1.6 or greater

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

  For Windows install:
     1) Unzip the Teradata Studio package to your local file system.
     2) Run the setup.exe to launch the Teradata Studio installation.
     3) Provide the path to where you would like to install Teradata Studio.
        The default location is
        C:\Program Files\Teradata\Client\14.00\Teradata Studio. When Teradata Studio
        is started, a 'workspace' directory is created in your home directory (C:\Users\
        <user>\workspace-studio). 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 package to your local file system.
        gunzip TeradataStudio__linux_x86.14.02.00.00-1.tar.gz
        tar -xvf TeradataStudio__linux_x86.14.02.00.00-1.tar
    2) Change directories (CD) to the TeradataStudio.14.01.00.00 directory
        cd TeradataStudio.14.02.00.00
    3) Switch to Super User or Root and execute the RPM (Package Management) command to
       install Teradata Studio on Linux.
        su
        ./studioinstall TeradataStudio-14.02.00.00-1.x86.rpm
    4) Provide the path to where you would like to install Teradata Studio.
       The default location is /opt/teradata. When Teradata Studio is started, a 'workspace'
       directory is created in the location where you launched Teradata Studio (TeradataStudio) from,
       called workspace-studio. 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 is installed or not, run the following command:
        rpm -qa TeradataStudio
    To remove the Teradata Studio product from your Linux system, run the following
    command:
        rpm -e TeradataStudio

  For Mac OS Install:
    1) Unzip the Teradata Studio package to your local file system.
    2) Double click on the Teradata Studio.pkg package to invoke the Teradata Studio installer
    3) You can change the install location or use the default install location, which is the
       /Applications/TeradataStudio folder. When Teradata Studio is started, a 'workspace-studio' 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:
=============================
    Windows:
       Double click the Teradata Studio desktop icon shortcut.

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

    Mac:
       Execute Teradata Studio in the TeradataStudio directory.


Hadoop Configuration Support:
=============================
Teradata Studio provides an option to transfer data to and from Hadoop systems using the Teradata Connector for Hadoop
version 1.0.6. The Teradata Connector for Hadoop is installed on the Hadoop node. The following are the requirements
of the Teradata Connector for Hadoop:

    System
        JRE/JDK 1.6

    Supported Teradata Database versions

        Teradata Database 13.0
        Teradata Database 13.10
        Teradata Database 14.0

    Supported Hortonworks Data Platform (HDP) versions

        HDP 1.1.0.17 (Hadoop 1.0.3, Hive 0.9.0, HCatalog 0.4.0)
        HDP 1.0.0.12 (Hadoop 1.0.3, Hive 0.9.0, HCatalog 0.4.0)