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