Welcome to Teradata Studio - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities

Using Teradata Studio User Guide

Teradata Studio is built on the Eclipse Rich Client Platform (RCP) framework to build and deploy native GUI applications. It extends the Eclipse Data Tools Platform (DTP) to provide enhancements for accessing objects and data stored in Teradata-supported databases.

Teradata Studio supports the Teradata Unified Data Architecture (UDA) by integrating administration, data management and transfer, and SQL query development across the Vantage, Aster, and Hadoop platforms.

Database administrators, developers, and users can use this guide to perform database administration, external data access, query development, and management tasks.

Why Would I Use this Content?

This guide makes you acquainted with the Teradata Studio user interface, understands its capabilities, and performs the following tasks:
  • Database administrative tasks
  • Develop and run SQL queries
  • Data transfer between Vantage databases, Aster databases, and Hadoop file systems
  • Access Data Lab (sandbox) to explore, analyze new data, and test data value theories.

    Work on the Table Data Editor for viewing and editing table data stored in Vantage or Aster Databases.

    View and troubleshoot Eclipse error messages

How Do I Use this Content?

As a database administrator, you can use this content to:
  • Create, view, modify, and administer database objects
  • Create new database users
  • Manage database privileges and space
As a database user, you can use this content to:
  • Develop and run SQL queries
  • Transfer data between Vantage 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 section to know about the Teradata Studio 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.
  • For information about which privileges are associated with the Public Role and User grantee type, see Teradata Vantage™ - SQL Data Control Language, B035-1149.
  • For information about Trigger properties, Roles, and authorizations, see:
    • Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
    • Teradata Vantage™ - SQL Fundamentals, B035-1141