16.00 - Transfer View - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

The Transfer View enables you to select a profile for a Teradata Database or Hadoop system, connect to the system, and view a list of databases and tables in that system. The view displays the database objects in a tree hierarchy that allows you to explore the structure of the data. For example, you can view a list of tables in the selected database as well as stored procedures and macros.

Use the Transfer View in combination with the Data Source Explorer to transfer data from one Teradata or Hadoop system to another. By dragging and dropping objects from one to the other, you can import and export data between Teradata Databases and Hadoop systems. You can also copy table data from one Teradata Database system to another. The appropriate dialogs automatically display to help you complete the data transfer action.

Select Profile

Select a Connection profile from the list. The list displays the connection profiles to which you are already connected. If you do not see the profile you want, it is probably not connected. To connect to a connection profile, right-click Database Connections and select New. In the Connection Profile dialog select the type of database to which you want to connect and complete the dialog information. See About Connection Profiles for information about connecting.

Data Object Selection

After you select the profile, the Transfer View shows the hierarchical structure of the data in the database to which you are connected. You can browse the structure to see the data it contains. The view shows lists of indexes, macros, stored procedures, tables, user-defined functions, and views. You can drag and drop most objects to a Teradata or Hadoop database displayed in the Data Source Explorer to export data to a different database or user.