About Transferring Data - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.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 and Teradata Aster Databases. You also can move data stored in external files back into a Teradata or Aster system.
Load Data Wizard The Load Data Wizard loads data from an external file in a file system to a Teradata or Aster database table.
Export Data Wizard The Export Data Wizard exports data from a Teradata or Aster 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.