Welcome to Teradata Studio Express - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Begin using Teradata Studio Express by creating a Connection Profiles for your database.

Then in the Data Source Explorer open the Connection Profile where you can browse the Databases, Indexes, Macros, Tables, Stored Procedures, User-defined Functions, User-defined Types, and Views folders to discover the database objects.

The highest level in the tree is the database server node, indicated by the database name provided in the Connection Profile. If no database name was provided, the default database name 'DBC' is used.

Clicking on an object in the Data Source Explorer displays the object in the Object Viewer.

An SQL Editor is provided for you to start entering your SQL statements.

Using Teradata Studio Express User Guide

Teradata Studio Express is an information discovery tool that retrieves data from Teradata and Aster Database systems and allows the data to be manipulated and stored on the desktop.

A user who does not have to perform any administrative work can use this guide to explore, discover, and manage Vantage-supported databases, develop and run SQL queries, and transfer data between databases.

Why Would I Use this Content?

This guide makes you acquainted with the Teradata Studio Express user interface, learns its capabilities, and performs the following tasks:
  • Create connection profiles using the Teradata or Aster JDBC Driver.
  • View and edit database object like databases, users, tables, macros, stored procedures, user-defined functions, user-defined types, views, and triggers.
  • Create, modify, and run individual or multiple SQL Statements.
  • Manually control auto-commit of SQL Statements.
  • View the stored historical data for executed SQL statements with time values and status information.
  • Visually build and edit SQL queries (Teradata only).
  • Extract data from the Teradata or Aster Database to a file on the desktop.
  • Load data from the desktop file system to the Teradata or Aster Database.
  • Load delimited text or Excel files into Teradata or Aster.

How Do I Use this Content?

As a database user, you can use this content to:
  • Develop and run SQL queries
  • Transfer data between Teradata databases, Aster databases, and Hadoop file systems.

As a database developer, you can use this content to launch menus, toolbars, and views that focus on developing databases such as Oracle, IBM DB2, and Microsoft SQL Server.

How Do I Get Started?

Start with the Getting Started With Studio Express section to know about the Teradata Studio Express workbench, perspectives, and views. Proceed to the following sections according to your requirements:

References to Other Relevant Content

To install Studio, see Teradata Studio™ and Studio Express Installation Guide, B035-2037.