About Transferring Data - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata Studio and Teradata Plug-in for Eclipse provide the capability for users and administrators to seamlessly transfer data among the key component data platforms of Teradata's UDA: Teradata Databases, Teradata Aster Databases, and Hadoop file systems. Data transfer features use drag-and-drop and point-and-click interfaces in the Data Source Explorer, Transfer View, and Data Lab View to move data from one system or table to another.

Integrated tools and features include:
Tool/Feature Description
Data Transfer Wizard The Data Transfer Wizard lets you select the source type and destination type of a data transfer operation
Copy Object Wizard The Copy Object lets you copy tables and table data from one Teradata system to another
Smart Load Wizard Use Smart Load for ad-hoc data movement. You can move data to external files from Teradata Databases, Teradata Aster Databases, and Hadoop file systems. You also can move data stored in external files back into a Teradata, Aster, or Hadoop system.
Load Data Wizard The Load Data Wizard loads data from an external file in a file system.
Export Data Wizard The Export Data Wizard exports data from a table to an external file.
Transfer Hadoop Table to Teradata Table Wizard The Transfer Hadoop Table to Teradata Table Wizard imports data from a Teradata Database table to Hadoop.
Transfer Teradata Table to Hadoop Table Wizard The Transfer Teradata Table to Hadoop Table Wizard exports data from Hadoop to a new Teradata table or to an existing Teradata table.
Transfer Hadoop Table to Aster The Transfer Hadoop Table to Aster Wizard imports data from a Hadoop table to an Aster table.