Working with Data Transfer Wizard - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Each data transfer operation requires that you specify the Source Type and Destination Type for the transfer operation.

Select the destination for the data transfer:

Transfer Data From Options

Teradata Table

Export data from a Vantage table (Source Type = Teradata) to:
  • Another table in the same database or in a different database.
  • An external file in the file system, such as a text file or Microsoft Excel spreadsheet.
  • A Hadoop table.

To select which type of data transfer to perform, select a Vantage table object in Data Source Explorer from which you want to export data (Data > Export Data).

  • Teradata – Specify the Vantage table that receives data.
  • External File (FastExport) – Specify the external file for the data transfer. The Teradata FastExport utility performs the data transfer operation.
  • Hadoop – Specify the Hadoop table object for the data transfer.

Hadoop Table

You can export data from a Hadoop table (Source Type = Hadoop). Select the destination for the data transfer:

  • Teradata – Specify the Vantage table object that receives data.
  • Aster – Specify the Aster table object that receives the data.
    SQL-H is not supported in Hadoop 3.01. Data transfer from Hadoop 3.01 to Aster will not work.
  • External File – Export data from Hadoop to an external file in your system.

Aster

You can export data from an Aster Database (Source Type = Aster).

External File – Exports data from Aster to an external file in your system.
Transfer Data To Options

Teradata Table

You can transfer data to a Teradata table (Desintation Type = Teradata). Select the source for the data transfer:

  • Hadoop – Specify the Teradata table object for the data transfer from Hadoop.
  • Teradata – Loads the data from a specified Teradata table.
  • External File (FastLoad) – Specify the external file in your file system to which the data is loaded using the Teradata FastLoad utility.

Hadoop Table

You can load data to a Hadoop table (Desintation Type = Hadoop). Select the source for the data transfer:

  • 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.

Aster

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

External File – Loads data from an external file in your system.