To access this download, you must login.

About this download

Teradata Studio is an administration toolkit that helps users to create and administer database objects. It also provides a SQL Editor and Result Set Viewer for retrieving and displaying data fron your Teradata Database systems (Teradata, Aster, and Hadoop). 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.

Teradata Studio 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 16.10.01 release information.
 
Supported Platforms:
==================================== 
     Windows Server - Microsoft Windows Server 2012 64-bit
                    - Microsoft Windows Server 2016 64-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 6.0, and 7.0 32-bit and 64-bit
     Red Hat Platform - Red Hat Advanced Platform 6.0, and 7.0 32-bit and 64-bit
     SUSE Linux Enterprise - SUSE Linux Enterprise 11, 32-bit and 64-bit
                                      - SUSE Linux Enterprise 12, 32-bit and 64-bit
     CentOS 6       - 6, 32-bit and 64-bit
     CentOS 7       - 7, 32-bit and 64-bit
     Apple Mac      - OSX 10.7, 10.8, 10.9, 10.10, 10.11, and 10.12
 
 
Minimum Memory Required:
====================================
     4GB Memory, but 6GB Memory desired
 
 
Supported Teradata Databases Versions:
====================================  
     Teradata Database 14.0
     Teradata Database 14.10
     Teradata Database 15.0
     Teradata Database 15.10
     Teradata Database 16.0
     Teradata Database 16.10
 
Supported Aster Databases Versions:
====================================  
     Aster Database 6.10
     Aster Database 6.20 
     Aster Database 7.0 (Aster on Hadoop)
 
 
 
Supported Hadoop:
=============================================
     HDP 2.3, 2.4, 2.5 
     Cloudera 5.7, 5.8, 5.9
 
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 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) Teradata Studio is installed in the Program Files directory.
        For example, C:\Program Files (x86)\Teradata\Client\16.10\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.16.10.01.00-1.tar.gz
        tar -xvf TeradataStudio__linux_x86.16.10.01.00-1.tar
 
    2) Change directories (CD) to the TeradataStudio.16.10.01.00 directory
 
        cd TeradataStudio.16.10.01.00
 
    3) Switch to Super User or Root and run the Studio install script, passing
       the Studio RPM (Package Management) package:
 
        su 
        ./studioinstall TeradataStudio-16.10.01.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 RPM command:
 
        rpm -qa TeradataStudio
    
    To remove the Teradata Studio product from your Linux system, run the following RPM command:
 
        rpm -e TeradataStudio
 
  For Mac OSX 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.
    
    To uninstall Studio on the Mac OSX, open a Terminal window and run the Studio uninstall script:
 
       . ./studio_uninstall.sh
 
 
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.
 
 
Changing the Teradata Studio Workspace and/or Configuration information directories
    - (using Roaming Profiles):
====================================================================================
When Teradata Studio is launched, it creates a workspace directory (called workspace-studio) in your 
USER HOME directory. If you want to change the location of your workspace directory, you must pass
the -data option into the TeradataStudio executable. You can do this by changing the Target parameter in the
Windows desktop shortcut or in the command window when launching Teradata Studio. For example:
 
"C:\Program Files (x86)\Teradata\Client\16.10\Teradata Studio\TeradataStudio.exe" -data "c:\Teradata Studio\My Workspace"
 
There is another directory (called .eclipse) created in your USER HOME directory that contains configuration 
information and jars for launching Teradata Studio. If you want to change the location of your configuration
directory, you must pass the -configuration option into the TeradataStudio executable. You can do this by changing
the Target parameter in the Windows desktop shortcut or in the command window when launching Teradata Studio.
For Example:
 
"C:\Program Files (x86)\Teradata\Client\16.10\Teradata Studio\TeradataStudio.exe" -configuration "c:\Teradata Studio"
 
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.10.01:
 
IDE-19851  While expanding/selecting Database node unhandled event loop exception is getting.
 
IDE-19853  Same keyboard shot cut key is using in two different place in new hadoop connection profile.
 
IDE-19861  Empty warning dialog is displayed after click on cancel button in Conform Replace Dialog.
 
IDE-19870  Teradata<->Hadoop Load Data into existing Table - Wizard closes when selecting database 
 
IDE-19978  Password masking: Execute All problem handling End Of Line in Unix/Windows
 
IDE-19976  Password masking: Problem with carriage return and pattern search in single query
 
IDE-20009  Password masking: Problem with multi-statements with multi-passwords in single line
 
IDE-20041  Fastload property needs to be set
 
 
The following bugs were fixed in 16.10.00:
 
IDE-12116  Edit Data.. --> Error message is not displayed when entered invalid value for NUMBER Data type and Data inserted as 'null' value for NUMBER data type
 
IDE-12805  User name is truncating to 30 characters and displaying only 30 characters in the DSE at admin level node if logged on user contains more than 30 characters
 
IDE-15877  DSE Filter not working when caching databases
 
IDE-15915  Studio Express is missing the SQL File Wizard
 
IDE-16220  Teradata result set viewer --> While executing multiple queries from Editor, Row Count is displaying wrongly in 'Row Max Limit' dialog for subsequent queries
 
IDE-16776  DSE displaying nested Database directory not sorting with case-insensitive
 
IDE-16816  Aster - Create Objects Forms--> Error message(The field name is longer than 50 characters) is displayed after resetting the form
 
IDE-17044  For Create UDT forms,INLINE LENGTH and for Dataset column type, Avro storage format is missing
 
IDE-17113  Not able to 'Cancel' the connection to disconnect the connection in progress
 
IDE-17272  Array UDTs cannot specify complex data types, they should be excluded
 
IDE-17486  Creating a new Hadoop profile gets NPE
 
IDE-17500  Different row count is displayed In Teradata SQL History after executing same SQL Query from SQL Editor and Project Explorer.
 
IDE-17502  Database/User Object Space display headers are wrong
 
IDE-17761  TDCH + Presto enabled Hadoop Profile - Smart Load is not disabled
 
IDE-17807  In Hadoop Connection Profile : Password is not masked in 'JDBC URL' Property values in summary window.
 
IDE-17916  'Max Row Limit' prompt will be displayed after consecutive execution of valid and invalid SQL's which is irrelevant to the currently executed SQL
 
IDE-17940  Unable to insert/delete the NULL Values into/from a MULTISET Table using Edit Data.. wizard
 
IDE-18248  Null pointer exception while clicking on 'Privileges on' of the Database/User form
 
IDE-18249  Incorrect Impala JDBC URL tail for auth=noSasl
 
IDE-18291  Table Data Editor unusable on Mac for large queries
 
IDE-18292  In the query to get the list of UDFs for the DSE, query had hard-coded TablesV
 
IDE-18294  No Datatools preference option to specify IndicesVX for primary key load.
 
IDE-18419  Cloudera/Hortonworks Hive version is inaccurate in connection properties version tab
 
IDE-18420  Connection Properties Rename - Doesn't check if new name ends with a space
 
IDE-18462  Aster --> Duplicate Short cut keys for selecting the Back/Next buttons in the 'New Aster Database/Execution Engine Connection Profile' Wizard
 
IDE-18487  Aster Schema Cache --> Table type(fact/dimension) is displayed with trailing spaces in the Cached file
 
IDE-18494  FINISH button is not working while transfer data from Hadoop to Teradata.
 
IDE-18506  F5 to run sql doesn't work consistently
 
IDE-18515  When using the Teradata Studio Data Transfer feature, export sessions are not closed after transfer completion.
 
IDE-18700  Aster AX External JDBC Driver class not found
 
IDE-18728  Add Database dialog not refreshing error message
 
IDE-18952  Aster - Create Database ñ Consistency --> Generated SQL should be end with semicolon (;) in the SQL tab in Create Database form
 
IDE-18955  AccessCount column in Object List Viewer Show All Objects not filled out
 
IDE-18961  Result Set Viewer timestamp values not sorted correctly
 
IDE-19090  Class cast exception when using DSE Load Preference 'Only Databases'
 
IDE-19419  ACT: MR functions does not appear in Query Development View.
 
IDE-19449  After running any data transfer job in the data transfer progress view, all sql queries then return with 4 query monitors instead of a single monitor, 
           like before the data transfer.
 
 
Improvements
==================================== 
 
The following improvements were made in 16.10.00:
 
IDE-10474  Load Locale Improvements
 
IDE-10546  Kerberos Support for TDCH
 
IDE-13886  Show details for a database index'
 
IDE-15245  Use Presto to load DSE Objects for Presto connections
 
IDE-15348  Indicate default Aster database in object list viewer.
 
IDE-17152  Array UDT, support for creating Multidimensional array type
 
IDE-17384  Manage DATASET SCHEMA privileges
 
IDE-17386  Support Aster Execution Engine
 
IDE-17414  Support Multiple Hash Maps
 
IDE-17413  Teradata 16.10 Parser Update
 
IDE-17425  Provide better information when detect java mismatch at startup
 
IDE-17437  Gracefully handle Teradata Connection Timeout
 
IDE-17445  Export mode should run in cancelable job
 
IDE-17489  Additional password masking
 
IDE-17762  Ability to add own JDBC properties to connection for Hive/Impala/Presto
 
IDE-17763  Add 'Column Labels in First Row' option in Hadoop Smartload for  Cloudera 5.8+ Systems
 
IDE-18607  Support Row Count for Hadoop Tables
 
IDE-19062  Option to translate certain characters in the Result Set Viewer
 
 
Hadoop Configuration Support:
=============================
Teradata Studio provides an option to transfer data to and from Hadoop systems using its feature called the
Smart Loader for Hadoop. The Smart Loader for Hadoop uses the Teradata Connector for Hadoop (TDCH), which is
installed on the Hadoop node, to provide the data transfer to and from the Hadoop system. The following are the system requirements of TDCH:
 
    Supported Teradata Database versions:
 
        Teradata Database 14.0
        Teradata Database 14.10
        Teradata Database 15.0
        Teradata Database 15.10
        Teradata Database 16.0
 
        Teradata Database 16.10
 
    Supported Hortonworks Data Platform (HDP) versions:
        HDP 2.3, 2.4,  2.5
 
    Supported Cloudera Hadoop (CDH) versions:
        CDH 5.7, 5.8, 5.9
 
 
Teradata Connector for Hadoop Setup:
====================================
The TDCH must be installed and configured on the Hadoop system. Studio
uses Oozie to submit the data transfer workflow on the Hadoop System. Please follow these instructions
to configure the Hadoop System and create the Oozie workflow files.
 
1) If the script is not already on your Hadoop system, download and install the TDCH onto your Hadoop system.
2) Navigate to the TDCH scripts folder in the TDCH install directory (default location: /usr/lib/tdch/1.5/scripts)
3) Execute the configureOozie.sh script as root user, providing the locations of your Hadoop services.
    
The usage of the configureOozie.sh script is as follows (this is all a single line):
 
    Usage: ./configureOozie.sh nn=nameNodeHost [nnHA=fs.default.value] [rm=resourceManagerHost] [oozie=oozieHost] [webhcat=webHCatalogHost] [webhdfs=webHDFSHost]
        [nnPort=nameNodePortNum] [rmPort=resourceManagerPortNum] [ooziePort=ooziePortNum] [webhcatPort=webhcatPortNum] [webhdfsPort=webhdfsPortNum] 
        [hiveClientMetastorePort=hiveClientMetastorePortNum] [kerberosRealm=kerberosRealm] [hiveMetaStore=hiveMetaStoreHost] 
        [hiveMetaStoreKerberosPrincipal=hiveMetaStoreKerberosPrincipal]
 
(The parameters are entered on a single line. The parameters surrounded by [ ] are optional. The ì[ì and ì]î are not part of the command.)
 
    nn - The Name Node host name (required)
    nnHA - If the name node is HA (High Availability), specify the fs.defaultFS value found in core-site.xml
    rm - The Resource Manager host name (uses nn parameter value if omitted)
    oozie - The Oozie host name (uses nn parameter value if omitted)
    webhcat - The WebHCatalog host name (uses nn parameter value if omitted)
    webhdfs - The WebHDFS host name (uses nn parameter value if omitted)
    nnPort - The Name node port number (8020 if omitted)
    rmPort - The Resource Manager port number (8050 if omitted)
    ooziePort - The Oozie port number (11000 if omitted)
    webhcatPort - The WebHCatalog port number (50111 if omitted)
    webhdfsPort - The WebHDFS port number (50070 if omitted)
    hiveClientMetastorePort - The URI port for hive client to connect to metastore server (9083 if omitted)
    kerberosRealm - name of the Kerberos realm
    hiveMetaStore - The Hive Metastore host name (uses nn parameter value if omitted)
    hiveMetaStoreKerberosPrincipal - The service principal for the metastore thrift server (hive/_HOST if ommitted)
 
The port numbers are HDPís defaults. So, if the system being set up has all the services
hosted on a single system on the default ports, only the nn parameter is needed.
 
The script will exit with an error message if the TDCH is not in its expected location.
Otherwise the script will display a message indicating the parameters values. A sample
message is as follows:
 
The following is the specification of the Hadoop services used by the Oozie workflows:
{
        "Distribution":"HDP",
        "DistributionVersion":"2.4",
        "TeradataConnectorForHadoopVersion”:”1.5.3”,
        "WebHCatalog":"hostname",
        "WebHCatalogPort":50111,
        "WebHDFS":"hostname",
        "WebHDFSPort":50070,
        "JobTracker":"hostname",
        "JobTrackerPort":8050,
        "NameNode":"hostname",
        "NameNodePort":8020,
        "NameNodeHA":"fs.defaultFS",
        "NameNodeHAConfigured":true,
        "Oozie":"hostname",
        "OoziePort":11000,
        "HiveClientMetastorePort":9083
        "HiveMetaStoreKerberosPrincipal":"hive/_HOST",
        "KerberosRealm":"",
        "HiveMetaStore":"hostname"
}
 
** You must also make sure the Teradata IDE/Studio client machine can access the Hadoop system services (hostnames and ports provided to configureOozie script).
Thus, you may need to add the Hadoop services host names and IP addresses to your host file or DNS service. 
 
 
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