Working with Data Transfer Wizard - 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

The Data Transfer Wizard enables you to identify the source and destination for exporting and loading data. The wizard displays the profile name of the database connection to be used to transfer the data. Be sure to verify that you selected the correct profile.

Each data transfer operation requires that you specify the source and destination for the transfer operation. The Source Type and Destination Type fields indicate the type of data transfer operation you selected.

Transfer Data from Teradata Table

You can export data from a Teradata table (Source Type = Teradata):
  • To another table in the same Teradata Database or in a different Teradata Database.
  • To an external file in the file system, such as a text file or Microsoft Excel spreadsheet.
  • To a Hadoop table.

To select which type of data transfer to perform, select a Teradata table object in Data Source Explorer from which you want to export data ( Data > Export Data). In the Data Transfer Wizard, select the destination for the data transfer. The options are:

Option Description
Teradata Opens the Copy Teradata Table wizard for specifying the Teradata table that receives data.
External File (FastExport) Opens the Export Data Wizard which enables you to specify the external file for the data transfer. The Teradata FastExport utility performs the data transfer operation.
Hadoop Opens the Export Table to Hadoop wizard which enables you to specify the Hadoop table object for the data transfer.

Transfer Data from Hadoop Table

You can export data from a Hadoop table (Source Type = Hadoop). Select one of the following Destination Type options:

Option Description
Teradata Opens the Hadoop Table Load to Teradata wizard for specifying the Teradata table object that receives data.
Aster Opens the Transfer Hadoop table to Aster wizard for specifying the Aster table object that receives the data.
External File Export data from Hadoop to an external file in your system.

Transfer Data to Teradata Table

You can transfer data to a Teradata table (Destination Type = Teradata). Select one of the following Source Type options:

Option Description
Hadoop Opens the Hadoop Table Load to Teradata wizard which enables you to specify the Teradata table object for the data transfer from Hadoop.
External File (FastLoad) Opens the Load Data Wizard which enables you to specify the external file in your file system to which the data is loaded using the Teradata FastLoad utility.

Transfer Data to Hadoop Table

You can load data to a Hadoop table (Destination Type - Hadoop). Select one of the following Source Type options:

Option Description
Teradata Loads the data from a specified Teradata table.
External File (FastLoad) If Smart Loader is enabled for this connection, this option opens the Load Data Wizard which enables you to specify the external file in your file system to which the data is loaded.

Transfer Data to Aster

You can load data to a Teradata Aster Database (Destination Type - Aster).

Option Description
Hadoop Loads data from the selected Hadoop table to an Aster table.
External File Loads data from an external file in your system.

Transfer Data from Aster

You can export data from a Teradata Aster Database (Source Type = Aster)

Option Description
External File Exports data from Aster to an external file in your system.