Teradata® Studio™ and

Studio™ Express
Installation Guide

Release 17.10
July 2021

B035-2037-129K
DOCS.TERADATA.COM
Copyright and Trademarks
Copyright © 2006 - 2021 by Teradata. All Rights Reserved.
All copyrights and trademarks used in Teradata documentation are the property of their respective owners. For more information, see
Trademark Information.

Product Safety

Safety type Description

Indicates a situation which, if not avoided, could result in damage to property, such as to equipment
NOTICE or data, but not related to personal injury.

Indicates a hazardous situation which, if not avoided, could result in minor or moderate
CAUTION personal injury.

Indicates a hazardous situation which, if not avoided, could result in death or serious
WARNING personal injury.

Third-Party Materials
Non-Teradata (i.e., third-party) sites, documents or communications (“Third-party Materials”) may be accessed or accessible (e.g., linked or
posted) in or in connection with a Teradata site, document or communication. Such Third-party Materials are provided for your convenience
only and do not imply any endorsement of any third party by Teradata or any endorsement of Teradata by such third party. Teradata is not
responsible for the accuracy of any content contained within such Third-party Materials, which are provided on an “AS IS” basis by Teradata.
Such third party is solely and directly responsible for its sites, documents and communications and any harm they may cause you or others.

Warranty Disclaimer
Except as may be provided in a separate written agreement with Teradata or required by applicable law, the information available
from the Teradata Documentation website or contained in Teradata information products is provided on an "as-is" basis, without
warranty of any kind, either express or implied, including the implied warranties of merchantability, fitness for a particular
purpose, or noninfringement.
The information available from the Teradata Documentation website or contained in Teradata information products may contain references
or cross-references to features, functions, products, or services that are not announced or available in your country. Such references do not
imply that Teradata Corporation intends to announce such features, functions, products, or services in your country. Please consult your
local Teradata Corporation representative for those features, functions, products, or services available in your country.
The information available from the Teradata Documentation website or contained in Teradata information products may be changed or
updated by Teradata at any time without notice. Teradata may also make changes in the products or services described in this information
at any time without notice.

Machine-Assisted Translation
Certain materials on this website have been translated using machine-assisted translation software/tools. Machine-assisted translations
of any materials into languages other than English are intended solely as a convenience to the non-English-reading users and are not
legally binding. Anybody relying on such information does so at his or her own risk. No automated translation is perfect nor is it intended to
replace human translators. Teradata does not make any promises, assurances, or guarantees as to the accuracy of the machine-assisted
translations provided. Teradata accepts no responsibility and shall not be liable for any damage or issues that may result from using such
translations. Users are reminded to use the English contents.

Feedback
To maintain the quality of our products and services, e-mail your comments on the accuracy, clarity, organization, and value of this document
to: docs@teradata.com.
Any comments or materials (collectively referred to as "Feedback") sent to Teradata Corporation will be deemed nonconfidential. Without
any payment or other obligation of any kind and without any restriction of any kind, Teradata and its affiliates are hereby free to (1) reproduce,
distribute, provide access to, publish, transmit, publicly display, publicly perform, and create derivative works of, the Feedback, (2) use any
ideas, concepts, know-how, and techniques contained in such Feedback for any purpose whatsoever, including developing, manufacturing,
and marketing products and services incorporating the Feedback, and (3) authorize others to do any or all of the above.
 Contents

Chapter 1: Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Supported Platforms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Supported Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Hardware Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Software Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Java Runtime Environment or Java Development Kit Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Chapter 2: Installing Teradata Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Software Downloads . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Installation on Windows Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Installing Teradata Studio on Linux Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Installing Teradata Studio on Apple macOS Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Changing the Workspace Directory Location . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Setting Up a Teradata Connector for Hadoop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

Chapter 3: Installing Teradata Studio Express . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Software Downloads . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Installing Teradata Studio Express on Linux Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Installing Teradata Studio Express on Apple macOS Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Installation on Windows Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Changing the Workspace Directory Location . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

Appendix A: Administrative Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Appendix B: Additional Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 3
 1
Dependencies

Supported Platforms
Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading
Teradata® Database. Until references in content are updated to reflect this change, the term Teradata
Database is synonymous with Teradata Vantage.

The following table lists the operating systems on which Teradata® Studio™ and Studio Express
are supported:

Platform Studio Studio Express

Microsoft Windows 7 (64-bit) ● ●

Microsoft Windows 8 and 8.1 ● ●
Microsoft Windows 10 (64-bit) ● ●
Microsoft Windows Server 2012 (64-bit) ● ●
Microsoft Windows Server 2016 (64-bit) ● ●
Microsoft Windows Server 2019 (64-bit) ● ●

Red Hat Enterprise Server 6.0 and 7.0 (64-bit) ● ●

Red Hat Advanced Platform 6.0 and 7.0 (64-bit) ● ●

SUSE Linux Enterprise 11 (64-bit) ● ●

SUSE Linux Enterprise 12 (64-bit) ● ●
SUSE Linux Enterprise 15 (64-bit) ● ●

Apple macOS 10.13, 10.14, 10.15, 11.1 BigSur ● ●

CentOS 6 (64-bit) ● ●
CentOS 7 (64-bit) ● ●

Supported Databases
Teradata Studio and Studio Express support the following Vantage/Teradata Database and
Hadoop releases:
• Teradata Vantage 2.0, which includes the capabilities of Teradata Vantage™ Advanced SQL
Engine 17.00
• Teradata Vantage 1.0, which includes the capabilities of Teradata Vantage™ Advanced SQL
Engine 16.20
• Teradata Database 16.10
• Teradata Database 16.0

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 4
 1: Dependencies

• Teradata Database 15.10

Teradata Studio and Studio Express support the following Aster on Hadoop releases:
• Aster on Hadoop 7.00.02
Teradata Studio and Studio Express support the following Hadoop systems:
Hortonworks Data Platform (HDP)
• HDP 3.0.1
• HDP 2.6.5
• HDP 2.6.4
Cloudera Hadoop (CDH) versions
[17.00.10+] CDH 6.2
• CDH 6.1

Note:
Data transfer will not work from Hadoop to Teradata and vice versa when connecting to CDH 6.1
and CDH 6.2 as there is known limitation with Oozie service accessibility from External machine.

• CDH 5.16.1
• CDH 5.15

Hardware Requirements
The following table lists the minimum hardware requirements for Teradata Studio and Teradata
Studio Express.
Studio Studio Express

Memory 4 GB (6 GB desired) 4 GB

Disk Space 250 MB 250 MB

Software Requirements
Teradata Studio and Studio Express can work with either 8, 10, or 11 Java version of any Java vendor such
as Azul OpenJDK or Oracle. Teradata Studio and Studio Express requires OpenJDK or Oracle Java version
8, 10, or 11.
Depending on Operating System, either JDK or JRE must be installed.
• Apple macOS requires JDK.
• [Java 8, 10] Linux or Windows requires JRE.
• [Java 11] Windows requires JDK.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 5
 1: Dependencies

Teradata Studio and Studio Express tested and verified with Azul Zulu and Oracle vendor Java, but will work
with any vendor Java of version 8, 10, or 11.
You must install Java Runtime Environment or Java Development Kit, depending on your operating system:
• Apple macOS requires Java Development Kit (JDK) version 8, 10, or 11 of any Java vendor (for
example, Azul OpenJDK, Oracle)
• All other operating systems require Java Runtime Environment (JRE) version 8, 10, or 11 of any Java
vendor (for example, Azul OpenJDK, Oracle)
• macOS BigSur version 11.1 requires Java 11 for Studio

Java Runtime Environment or Java Development

Kit Requirements
The Teradata Studio and Studio Express 17.10.00 packages require either OpenJDK Installation or Oracle
JDK installation as below of any Java vendor.
Teradata Studio and Teradata Studio Express were certified on Azul OpenJDK and Oracle Java of versions
8, 10, and 11.
Teradata Studio and Teradata Express requires OpenJDK or Oracle Java of version 8, 10, or 11. Depending
on Operating System, either JDK or JRE must be installed.

Note:
Starting with JDK 11, Oracle provides JDK only.

• Apple macOS requires JDK

• [Java 8, 10] Linux or Windows requires JDK or JRE
• [Java 11] Windows requires JDK
• Apple macOS BigSur 11.1 requires Java 11

Azul Zulu OpenJDK Installation

1. Download required Java version 8, 10, or 11 depending on your operating system:
• Azul Open JDK (Choose the platform and version to download):
https://www.azul.com/downloads/zulu/
2. Follow steps specified in the Zulu Installation Guide at https://docs.azul.com/zulu/zuludocs/ depending
on your operating system.

Oracle JDK Installation

1. Download required Oracle Java version 8, 10, or 11 depending on your operating system.
• Java 8: Java SE Downloads
• Java 10: Java SE 10 Downloads
• Java 11: Java SE 11 Downloads

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 6
 1: Dependencies

2. Follow steps specified in the Installation Instructions section at the respective Java SE
Downloads website.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 7
 2
Installing Teradata Studio

Software Downloads

Downloading Teradata Studio

1. Go to https://support.teradata.com.
2. Click the Teradata Studio link to access the downloads page.

Note:
Make sure you download the 17.10.00.00 package.

3. Click the link for your operating system.

4. Accept the License Agreement by clicking I Agree.
5. In the File Download dialog, click Save, navigate to the location where you want to download the file,
and click Save again.
The zip file downloads to your local file system.

Installation on Windows Systems

Installing Teradata Studio Using the Wizard

1. Navigate to the directory where you downloaded the Teradata Studio package.
2. Unzip the Teradata Studio package to your local file system.
3. [Optional] Pre-configure connection profiles to be assigned at installation:
a. In the unzipped Teradata Studio package, navigate to the Config directory.
b. Edit the TeradataStudioDataSources_template.config file to define the connection profiles.
c. Save the file as TeradataStudioDataSources.config in the Config directory or any other
directory that is accessible by the installation process.
4. [Optional] Pre-configure preferences to be set at installation:

Note:
If you edited and saved the TeradataStudioDataSources.config file to an alternate directory
location in the previous step, then save the TeradataStudioPreferences.config file to this
same location.

a. In the unzipped Teradata Studio package, navigate to the Config directory.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 8
 2: Installing Teradata Studio

b. Edit the TeradataStudioPreferences_template.config file to define the preferences.

c. Save the file as TeradataStudioPreferences.config in the Config directory or any other
directory that is accessible by the installation process.
5. [Optional] If you intend to connect to systems using Kerberos Authentication, create a krb5.ini file.
This task is outside the scope of Teradata Studio.
6. Double-click setup.exe to start the Teradata Studio installer, accept the license, and select the Java
Runtime Environment.

Note:
If Oracle JRE 8, 10, or 11 is installed, the Installer dialog specifies the JRE path. If JRE from
another vendor is installed, such as Zulu, click Browse to select a compatible version.

If the selected Java Runtime Environment is different than system default JRE (JRE configured in the
PATH environment variable), the selected JRE location will be added in the TeradataStudio.ini file.
If the JRE is removed or upgraded after installing Teradata Studio, run the UpdateJRE.vbs as
administrator to update JRE path in the TeradataStudio.ini file. For example:
cscript UpdateJRE.vbs "C:\Program Files\Java\jre1.8.0_151\"
This script is in the same directory as TeradataStudio.exe.
7. In the Workspace Location step, keep the default or Browse to a different location.
The workspace directory contains workspace files, including the SQL project folder and log file.
8. [Optional] If you edited the TeradataStudioDataSources.config or
TeradataStudioPreferences.config file, do the following in the install wizard:
a. On the Pre-Configure Database Connection Profile page of the Install Wizard,
select Set up Studio with pre-configured TeradataStudioDataSources.config and/or
TeradataStudioPreferences.config files.
b. Browse for the location of the files.
9. [Optional] If you intend to connect to systems using Kerberos Authentication, do the following in the
install wizard:
a. On the Pre-Configure Database Connection Profile page of the Install Wizard, select Setup for
Kerberos environment. As noted, this will modify the registry so be sure you have registry edit
permission. The TeradataStudio.ini file will also be modified.
b. Browse to the location of your krb5.ini file and click OK and then Next.
10. Designate the Destination Folder options you want and click Next.
11. Click Install.
12. If you intend to connect to systems using Kerberos Authentication, you must run kinit to initialize your
Kerberos credential before launching Teradata Studio.

Installing Teradata Studio Using the Command Line

1. Navigate to the directory where you downloaded the Teradata Studio package.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 9
 2: Installing Teradata Studio

2. Unzip the Teradata Studio package to your local file system.

3. [Optional] Pre-configure connection profiles to assign at installation:
a. In the unzipped Teradata Studio package, navigate to the Config directory.
b. Edit the TeradataStudioDataSources_template.config file to define the connection profiles.
c. Save the file as TeradataStudioDataSources.config in the Config directory or any other
directory that is accessible by the installation process.
4. [Optional] Pre-configure preferences to set at installation:

Note:
If you edited and saved the TeradataStudioDataSources.config file to an alternate directory
location in the previous step, then save the TeradataStudioPreferences.config file to this
same location.

a. In the unzipped Teradata Studio package, navigate to the Config directory.

b. Edit the TeradataStudioPreferences_template.config file to define the preferences.
c. Save the file as TeradataStudioPreferences.config in the Config directory or any other
directory that is accessible by the installation process.
5. [Optional] If you intend to connect to systems using Kerberos Authentication, create a krb5.ini file.
This task is outside the scope of Teradata Studio.
6. Run the Studio installer by typing setup.exe /s /v/qn /v"/l*v studio.log" followed by any or all
of the following optional commands. Note that studio.log will contain a log file of the installation steps.
a. [Optional] /v"CHECK_KERBEROS_FILE=1" /v"KERBEROS_FILE_PATH=\"C:\tmp\\"" to use
Kerberos authentication.
The KERBEROS_FILE_PATH must point to the directory containing your krb5.ini file.
b. [Optional] /v"WORKSPACEPATH=\"C:\studio\WORKSPACEPATH\"" to use a workspace file
location other than the default.
The workspace directory contains workspace files, including the SQL project folder and log file.
c. [Optional] /v"CHECK_PRECONFIG_FILE=1" /v"CONFIGFILE_PATH=\"C:\Temp\config
files\"" to use specify the directory location of a pre-configured connection, which might
include both profiles and preferences.

Note:
When the path contains spaces, double quotes are required around the pathname.

7. [Optional] If connecting to systems using Kerberos Authentication you must run kinit to initialize your
Kerberos credential before launching Teradata Studio.

Installing Teradata Studio on Linux Systems

1. Navigate to the directory where you downloaded the Teradata Studio package.
2. Unzip the Teradata Studio package to your local file system:

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 10
 2: Installing Teradata Studio

gunzip TeradataStudio64__linux_x86_64.17.10.00.00-1.tar.gz
tar –xvf TeradataStudio64__linux_64.17.10.00.00-1.tar
3. Change to the Teradata Studio directory:
cd TeradataStudio.17.10.00.00
4. Switch to Super User or Root and install Teradata Studio:
sudo ./studioinstall TeradataStudio64-17.10.00.00-1_64.rpm.
5. Provide the path to install Teradata Studio.
The default is /opt/teradata.
A workspace directory that contains workspace files, including the SQL project folder and log file is
created in your home directory: \home\<user>\workspace.

Installing Teradata Studio on Apple macOS Systems

1. Unzip the Teradata Studio package to your local file system.
2. Open Teradata Studio.pkg to start the Teradata Studio installer.
3. Select the disk on which to install Teradata Studio.
4. [Optional] Enter a specific installation location.
The default location is /Applications.
A workspace folder called SQLA that contains workspace files, including the SQL project folder and log
file, is created in the Documents folder.

Changing the Workspace Directory Location

When Teradata Studio is first launched, a workspace directory called workspace-studio is created in a
default location. The workspace is used for storing files and preferences.

Operating System Default Workspace Location

Linux The directory in which Teradata Studio is run.

Apple macOS /Users/Username/Documents/StudioWorkspace

Windows C:\Users\Username\workspace-studio

You can change the location of the workspace directory from the default.

Changing the Workspace Directory Location on

Windows Systems
1. Right-click the Teradata Studio shortcut on the desktop and select Properties.
2. Add the –data option and new location for the workspace to the end of the Target field:
-data workspaceLocation.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 11
 2: Installing Teradata Studio

Changing the Workspace Directory Location on Linux Systems

1. Specify the new directory in the command line program execution string:
./opt/teradata/TeradataStudio/TeradataStudio –data /home /guestUser/MyWorkspace

Changing the Workspace Directory Location on Apple

macOS Systems
1. Open the Terminal application.
2. Specify the new directory in the command line program execution string:
/Applications/TeradataStudio/Teradata\ Studio.app/Contents/MacOS/TeradataStudio
–data /Users/guestUser/Documents/MyWorkspace.

Setting Up a Teradata Connector for Hadoop

Teradata Studio provides an option to transfer data to and from Hadoop systems. The Smart Loader for
Hadoop feature uses the Teradata connector for Hadoop (TDCH) installed on the Hadoop node. Oozie is
used for the data transfer workflow.
1. Download and install the TDCH onto your Hadoop system from https://support.teradata.com
under Connectivity.
2. Download the Configure Oozie script (configureOozie.sh) from https://support.teradata.com onto
your Hadoop system.
3. Change the mode so the script is executable:
chmod +x configureOozie.sh
4. Run configureOozie.sh to remove any hidden Windows characters from the file.
dos2unix configureOozie.sh
5. Execute configureOozie.sh as a root user, providing the locations of your Hadoop services:
Usage: ./configureOozie.sh
nn=nameNodeHost[jt=jobTrackerHost][oozie=oozieHost] [nnPort=nameNodePortNum]
[jtPort=jobTrackerPortNum][ooziePort=ooziePortNum][webhcatPort=webhcatPortNum]
[webhdfsPort=webhdfsPortNum] where
Parameter Definition Value

nameNodeHost The Name Node host name required

jobTrackerHost The Job Tracker host name uses nn parameter value if omitted

oozieHost The Oozie host name uses nn parameter value if omitted

nameNodePortNum The Name node port number 8020 if omitted

jobTrackerPortNum The Job Tracker port number 50300 if omitted

ooziePortNum The Oozie port number 11000 if omitted

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 12
 2: Installing Teradata Studio

Parameter Definition Value

webhcatPortNum The WebHCatalog port number 50111 if omitted

webhdfsPortNum The WebHDFS port number 50070 if omitted

Note:
The port numbers are HDP's defaults. 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 exits with an error message if the TDCH is not in its expected location. Otherwise the script
displays a message indicating the parameters values. For example:

The following is the specification of the Hadoop services used

by the Oozie workflows:
{
"Distribution":"HDP",
"DistributionVersion":"3.2.1",
"WebHCatalog":"hostname",
"WebHCatalogPort":50111,
"WebHDFS":"hostname",
"WebHDFSPort":50070,
"JobTracker":"hostname",
"JobTrackerPort":50300,
"NameNode":"hostname",
"NameNodePort":8020,
"Oozie":"hostname",
"OoziePort":11000
}

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 13
 3
Installing Teradata Studio Express

Software Downloads

Downloading Teradata Studio Express

1. Go to https://support.teradata.com.
2. Click Teradata Studio Express to access the downloads page.

Note:
Make sure you download the 17.10.00.00 package.

3. Click the link for your operating system.

4. Accept the License Agreement by clicking I Agree.
5. In the File Download dialog, click Save, navigate to the location where you want to download the file,
and click Save again.
The zip file downloads to your local file system.

Installing Teradata Studio Express on Linux Systems

1. Navigate to the directory where you downloaded the Teradata Studio Express package.
2. Unzip the Teradata Studio Express package to your local file system:
TeradataStudioExpress64__linux_x86_64.17.10.00.00-1.tar.gz
tar –xvf TeradataStudioExpress64-17.10.00.00-1.tar
3. Change to the Teradata Studio Express directory:
cd TeradataStudioExpress.17.10.00.00.
4. Switch to Super User or Root and install Teradata Studio Express:
sudo ./studioexpressinstall TeradataStudioExpress64-17.10.00.00-1_64.rpm.
5. Provide the path to install Teradata Studio Express.
The default location is /opt/teradata.
A workspace directory that contains workspace files, including the SQL project folder and log file is
created in your home directory: \home\<user>\workspace.

Installing Teradata Studio Express on Apple

macOS Systems
1. Unzip the Teradata Studio Express package to your local file system.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 14
 3: Installing Teradata Studio Express

2. Open Teradata Studio Express.pkg to start the Teradata Studio Express Installer.
3. Select the disk on which to install Teradata Studio Express.
4. [Optional] Enter a specific installation location.
The default location is /Applications.
A workspace folder called SQLA that contains workspace files, including the SQL project folder and log
file, is created in the Documents folder.

Installation on Windows Systems

Installing Teradata Studio Express Using the Wizard

1. Navigate to the directory where you downloaded the Teradata Studio Express package.
2. Unzip the Teradata Studio Express package to your local file system.
3. Create connection profiles to be used at installation:
a. In the unzipped Teradata Studio Express package, navigate to the Config directory.
b. Edit the TeradataStudioExpressDataSources_template.config file to define the
connection profiles.
c. Save the file as TeradataStudioExpressDataSources.config in the Config directory or any
other directory that is accessible by the install.
4. [Optional] Set preferences to be used at installation:
a. In the unzipped Teradata Studio Express package, navigate to the Config directory.
b. Edit the TeradataStudioExpressPreferences_template.config file to define the preferences.
c. Save the file as TeradataStudioExpressPreferences.config in the Config directory or any
other directory that is accessible by the installation process.
5. [Optional] If you intend to connect to systems using Kerberos Authentication, create a krb5.ini file.
This task is outside the scope of Teradata Studio Express.
6. Double-click setup.exe to start the Teradata Studio Express installer, accept the license, and select
the Java Runtime Environment.

Note:
If Oracle JRE 8, 10, or 11 is installed, the Installer dialog specifies the JRE path. If JRE from
another vendor is installed, such as Zulu, click Browse to select a compatible version.

If the selected Java Runtime Environment is different than system default JRE (JRE configured in the
PATH environment variable), the selected JRE location will be added in the TeradataStudioExpress.
ini file.
If the JRE is removed or upgraded after installing Teradata Studio, run the UpdateJRE.vbs as
administrator to update JRE path in the TeradataStudioExpress.ini file. For example:
cscript UpdateJRE.vbs "C:\Program Files\Java\jre1.8.0_151\"
This script is in the same directory as TeradataStudioExpress.exe.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 15
 3: Installing Teradata Studio Express

7. In the Workspace Location step, keep the default or Browse to a different location.
The workspace directory contains workspace files, including the SQL project folder and log file.
8. [Optional] If you edited the TeradataStudioExpressDataSources.config or
TeradataStudioExpressPreferences.config files, do the following in the install wizard:
a. On the Pre-Configure Database Connection Profile page of the Install Wizard,
select Set up Studio with pre-configured TeradataStudioDataSources.config and/or
TeradataStudioPreferences.config files.
b. Browse for the location of the files.
9. [Optional] If you intend to connect to systems using Kerberos Authentication, do the following in the
install wizard:
a. On the Pre-Configure Database Connection Profile page of the Install Wizard, select Setup for
Kerberos environment. As noted, this will modify the registry so be sure you have registry edit
permission. The TeradataStudioExpress.ini file will also be modified.
b. Browse to the location of your krb5.ini file and click OK.
c. Click Next.
10. Designate the Destination Folder options you want and click Next.
11. Click Install.

Installing Teradata Studio Express Using the Command Line

1. Navigate to the directory where you downloaded the Teradata Studio Express package.
2. Unzip the Teradata Studio Express package to your local file system.
3. [Optional] Pre-configure connection profiles to assign at installation:
a. In the unzipped Teradata Studio Express package, navigate to the Config directory.
b. Edit the TeradataStudioExpressDataSources_template.config file to define the
connection profiles.
c. Save the file as TeradataStudioExpressDataSources.config in the Config directory or any
other directory that is accessible by the installation process.
4. [Optional] Pre-configure preferences to set at installation:

Note:
If you edited and saved the TeradataExpressStudioDataSources.config file to an alternate
directory location in the previous step, then save the TeradataStudioPreferences.config file
to this same location.

a. In the unzipped Teradata Studio Express package, navigate to the Config directory.
b. Edit the TeradataStudioExpressPreferences_template.config file to define the preferences.
c. Save the file as TeradataStudioExpressPreferences.config in the Config directory or any
other directory that is accessible by the installation process.
5. [Optional] If you intend to connect to systems using Kerberos Authentication, create a krb5.ini file.
This task is outside the scope of Teradata Studio Express.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 16
 3: Installing Teradata Studio Express

6. Run the Studio Express installer by typing setup.exe /s /v/qn /v"/l*v studioexp.log"
followed by any or all of the following optional commands. Note that studio.log will contain a log
file of the installation steps.
a. [Optional] /v"CHECK_KERBEROS_FILE=1" /v"KERBEROS_FILE_PATH=\"C:\tmp\\"" to use
Kerberos authentication.
The KERBEROS_FILE_PATH must point to the directory containing your krb5.ini file.
b. [Optional] /v"WORKSPACEPATH=\"C:\studio\WORKSPACEPATH\"" to use a workspace file
location other than the default.
The workspace directory contains workspace files, including the SQL project folder and log file.
c. [Optional] /v"CHECK_PRECONFIG_FILE=1" /v"CONFIGFILE_PATH=\"C:\Temp\config
files\"" to use specify the directory location of a pre-configured connection, which might
include both profiles and preferences.

Note:
When the path contains spaces, double quotes are required around the pathname.

7. [Optional] If connecting to systems using Kerberos Authentication you must run kinit to initialize your
Kerberos credential before launching Teradata Studio.

Changing the Workspace Directory Location

When Teradata Studio Express is first launched, a workspace directory called workspace-studioexpress is
created in a default location. The workspace is used for storing files and preferences.

Operating System Default Workspace Location

Linux The directory in which Teradata Studio Express is run.

Apple macOS /Users/Username/Documents/StudioExpressWorkspace

Windows C:\Users\Username\workspace-studioexpress

You can change the location of the workspace directory from the default.

Changing the Workspace Directory Location on

Windows Systems
1. Right-click the Teradata Studio Express shortcut on the desktop and select Properties.
2. Add the –data option and new location for the workspace to the end of the Target field:
-data workspaceLocation.

Changing the Workspace Directory Location on Linux Systems

1. Specify the new directory in the command line program execution string:

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 17
 3: Installing Teradata Studio Express

/opt/teradata/TeradataStudioExpress/TeradataStudioExpress –data /home/

guestUser/MyWorkspace

Changing the Workspace Directory Location on Apple

macOS Systems
1. Open the Terminal application.
2. Specify the new directory in the command line program execution string:
/Applications/TeradataStudioExpress/Teradata\ Studio\ Express.app/Contents/
MacOS/TeradataStudioExpress –data /Users/guestUser/Documents/MyWorkspace

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 18
 A
Administrative Tasks

Updating the JDK or JRE Location in the

TeradataStudio.ini File
During the install of Teradata Studio, the TeradataStudio.ini file is created in your install directory. On
Windows for example, it is located at:
C:\Program Files\Teradata\Client\17.00\Teradata Studio
After you complete the Teradata Studio installation and the TeradataStudio.ini file is created, the
location of your JDK or JRE can change if you automatically update the versions from the Java vendor
download site (for example, Azul, OpenJDK, Oracle).
If your JDK or JRE location has changed, modify the TeradataStudio.ini file's reference to the location:
1. Identify the location of the files on your computer:
[Java 8] -vm C:\Program Files\Java\jre8\bin\javaw.exe
[Java 10] -vm C:\Program Files\Java\jre10\bin\javaw.exe
[Java 11] -vm C:\Program Files\Java\jdk11\bin\javaw.exe
2. Locate and open the teradatastudio.ini file.
C:\Program Files\Teradata\Client\17.00\Teradata Studio
3. Update the line in the .ini file that references the JDK or JRE location.

Changing Workspace and 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 by changing the Target parameter in the Windows desktop
shortcut or in the command window when launching Teradata Studio.
For example:
C:\Program Files\Teradata\Client\17.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 by changing
the Target parameter in the Windows desktop shortcut or in the command window when launching
Teradata Studio.

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 19
 A: Administrative Tasks

For example:
C:\Program Files\Teradata\Client\17.00\Teradata Studio\TeradataStudio.exe" -
configuration "c:\Teradata Studio
You can combine both the -data and -configuration options on a single command line.This is often
needed when using a Roaming Profile that is not always accessible when running applications.

Uninstalling Teradata Studio from Linux

1. Run the uninstall command:
rpm -e TeradataStudio64

Uninstalling Teradata Studio Express from Linux

1. Run the uninstall command:
rpm -e TeradataStudioExpress64

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 20
 B
Additional Information

Changes and Additions

Date Release Description

July 2021 17.10.00 • Updated version numbers to match this release

• Added support for Apple macOS BigSur 11.1

January 2021 17.00.12 Updated version numbers to match this release

October 2020 17.00.11 • Updated version numbers to match this release

• Added support for Apple macOS 10.15
• Removed support for Apple macOS 10.9, 10.10, 10.11, and 10.12
• Added support for CDH 6.2
• Added support for Java 11

April 2020 17.00.10 Updated version numbers to match this release.

December 2019 17.00 • Updated version numbers to match this release

• Added support for Advanced SQL Engine 17.00

Related Documentation
Publication Name Publication ID

Teradata Studio™ User Guide B035-2041

Teradata® Studio™ Express User Guide B035-2042

Teradata Links
Link Description

https://docs.teradata.com/ Search Teradata Documentation, customize content to your needs, and

download PDFs.
Customers: Log in to access Orange Books.

https://support.teradata.com One-stop source for Teradata community support, software downloads,

and product information.
Log in for customer access to:
• Community support
• Software updates
• Knowledge articles

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 21
 B: Additional Information

Link Description

https://www.teradata.com/University/Overview Teradata education network

https://support.teradata.com/community Link to Teradata community

Teradata® Studio™ and Studio™ Express Installation Guide, Release

17.10 22