Teradata Studio Express
Teradata Studio Express 16.10.01.00 for Windows i386 32-bit
Teradata Studio Express 16.10.01.00 for Windows x86 64-bit
Teradata Studio Express 16.10.01.00 for Linux 32-bit
Teradata Studio Express 16.10.01.00 for Linux 64-bit
Teradata Studio Express 16.10.01.00 for Mac OS
Teradata Studio Express Documentation 16.10.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.10.01 release information.
Supported Platforms:
====================================
Windows Server - Microsoft Windows Server 20116.102 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 (HiveServer2 0.14) versions:
=============================================
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 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.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.16.10.01.00-1.tar.gz
tar -xvf TeradataStudioExpress__linux_x86.16.10.01.00-1.tar
2) Change directories (CD) to the TeradataStudioExpress.16.10.01.00 directory
cd TeradataStudioExpress.16.10.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.10.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.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\16.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 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-17113 Not able to 'Cancel' the connection to disconnect the connection in progress
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-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-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-18487 Aster Schema Cache --> Table type(fact/dimension) is displayed with trailing spaces in the Cached file
IDE-18506 F5 to run sql doesn't work consistently
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-15245 Use Presto to load DSE Objects for Presto connections
IDE-17386 Support Aster Execution Engine
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
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