Teradata Studio provides the capability for users and administrators to seamlessly transfer data among the key component data platforms of Teradata's Unified Data Architecture (UDA): Vantage, Aster Databases, and Hadoop file systems. The following data transfer tools and 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.
| Tool/Feature | Description |
|---|---|
| Data Transfer Wizard | Select the source type and destination type of a data transfer operation |
| Copy Object Wizard | Copy tables and table data from one Teradata system to another |
| Smart Load Wizard | Used for ad hoc data movement. You can move data to external files from Vantage, Teradata Aster Databases, and Hadoop file systems. You also can move data stored in external files back into a Vantage, Aster, or Hadoop system. |
| Load Data Wizard | Loads data from an external file in a file system. |
| Export Data Wizard | Exports data from a table to an external file. |
| Transfer Hadoop Table to Teradata Table Wizard | Imports data from a Vantage table to Hadoop. |
| Transfer Teradata Table to Hadoop Table Wizard | Exports data from Hadoop to a new Vantage table or to an existing Vantage table. |
| Transfer Hadoop Table to Aster | Imports data from a Hadoop table to an Aster table. SQL-H is not supported in Hadoop 3.01. Data transfer from Hadoop 3.0.1 to Aster will not work.
|