To access this download, you must login.
Teradata Studio is a client based graphical interface used to perform database administration tasks on Aster and Teradata Databases, as well as moving data to and from Hadoop database systems. 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.
Teradata Studio 16.00.02 release information.
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 Databases 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.00
Aster Database 6.10
Aster Database 6.20
Aster Database 7.0 (Aster on Hadoop)
- 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.
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.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.
tar -xvf TeradataStudio__linux_x86.16.00.02.00-1.tar
2) Change directories (CD) to the TeradataStudio.16.00.02.00 directory
3) Switch to Super User or Root and run the Studio install script, passing
the Studio RPM (Package Management) package:
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:
Running Teradata Studio:
Double click the Teradata Studio desktop icon shortcut.
Update your path variable to include the TeradataStudio directory. Execute TeradataStudio.
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.00\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.
"C:\Program Files (x86)\Teradata\Client\16.00\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.
The following bugs were fixed in 16.00.02:
IDE-17881 FastLoad with Unicode Pass Through needs to pass in RUNSTARTUP parameter
IDE-18240 Disable SSL from Teradata Studio connection to hadoop through Knox
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-12705 Linux and Amazon Linux --> Data Sort/Filter, Export All and ‘Refresh table from Database’ toolbar options are not displayed
IDE-12818 Redhat 7 and Amazon Redhat - Copy object Wizard --> Generated SQL is not displayed in the SQL Summary Page in Copy object Wizard
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-15075 Transfer View Refresh is not refreshing after dropping table in Admin Perspective
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-15806 Property form is not closed when the table is dropped
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-15935 Set Root Database for Navigator --> Perform the case insensitive validation for Root Database
IDE-15937 JOIN/HASH --> Hash/Join Index is displayed without ‘Database name’ prefix when index dragged and dropped on SQL Editor
IDE-15959 Drop - Delete Database.../Drop Database... --> Menu options for Drop/Delete are not displayed when selecting the Database/User
IDE-16067 Result set Format settings lost on cancel operation
IDE-16070 Aster Smartloader gets incorrect nullable information
IDE-16156 Teradata ViewVX is not being used when loading Table Size information (DBC.TableSizeVX)
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-16302 Edit Data… - Teradata --> Unhandled event loop exception is thrown when clicking on ‘OK’ Button in the Filter/Sort Data dialog
IDE-16440 Smartload table returned null right after create statement successfully ran in Aster
IDE-16441 Only check for EXPLAIN for Teradata
IDE-16517 Japanese Localization Bugs in the 15.12 release
IDE-16604 Studio with ASTER on setting MAROWS is generating a pop up
IDE-16755 Aster --> Schemas are not displayed in the OLV when double clicked on database in the Navigator tab
IDE-16756 Aster --> Inform the user with proper message (or) Disable the ‘Add a Schema’ toolbar option as we cannot(other than login DB)
create the schema directly under the ‘XX DB’ using ‘Create Schema’ form
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-16815 Spelling --> Message is displayed incorrectly in the ‘Drop Confirmation’ message box
IDE-16833 Need to update wording on notification dialog
IDE-16886 CDH 5.8 testing with TDCH 1.5 --> Unhandled event loop exception is thrown when clicking on Finish button after clicking on
‘Select None --> Select All --> Reset’ buttons when trying to transfer Teradata table to Hadoop
IDE-16896 Teradata Studio 15.12 - Open SQL File does not work.
IDE-16915 Label name is displayed as ‘Database’ instead of ‘Schema’ in the ‘Transfer Hadoop Table to Aster Table’ wizard
IDE-16930 Unhandled event loop exception is thrown if the destination type contains unsupported data type as distribute by hash key
when transferring a Hadoop table to Aster
IDE-16931 Transfer Hadoop table to Aster -->Distribute by hash clause is not displayed when selecting hash key as other than first column
after unselecting the first column in the Transfer Column field
IDE-16996 Error Dialogue loops when timeout Teradata Connection and attempt copy table
IDE-17008 In SQL Editor, 'Connection Profile' Drop down is displayed as SmartLoad(CDH) instead of SmartLoad(HDP).
IDE-17055 Cloudera connection with SmartLoader connection option should show WebHDFS properties dialog, not TDCH
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-17369 Foreign Servers --> Unhandled event loop exception is thrown when pressing the 'Alt+Tab'
IDE-17397 Load Data and Export Data have Error Dialogue loops when connection got timed out
The following improvements were made in 16.00.02:
IDE-17476 Support for Cloudera 5.9
IDE-17620 Create Aster Execution Engine Connections
IDE-17621 Aster Execution Engine Create table support
IDE-18179 Migrate Aster 7.0 connection profiles
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.
IDE-12922 See Triggers with table objects in the Object List Viewer
IDE-12570 Ability to "show all objects" for a DB/User
IDE-12571 Display the references for a table
IDE-14657 See the list of roles that a user is in.
IDE-14665 Show the list of statistics for tables
IDE-12082 Preference to use Columns VX or custom view.
IDE-14732 SmartLoad and FastLoad: add option to ignore null rows
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. Teradata Studio
requires TDCH version 1.5.1. The following are the system requirements of TDCH 1.5.1:
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 Hortonworks Data Platform (HDP) versions:
HDP 2.3 (Hadoop 2.7.1, Hive 1.2.1, HBase 1.1.1)
HDP 2.4 (Hadoop 2.7.1, Hive 1.2.1, HBase 1.1.2)
HDP 2.5 (Hadoop 2.7.3, Hive 1.2.1, HBase 1.1.2)
Supported Cloudera Hadoop (CDH) versions:
CDH 5.4, 5.7, 5.8, 5.9
Teradata Connector for Hadoop Setup:
The TDCH 1.5.1 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 (version 1.5.1) 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]
(The parameters are entered on a single line. The parameters surrounded by [ ] are optional. The “[“ and “]” are not part of the command.)
(Note: the Job Tracker in HDP 1.x is now the Resource Manager in HDP 2.x)
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:
** 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