- Connect to a Teradata Aster Database using a Connection Profile.
- Open Data Source Explorer and navigate to the Aster table you want to export.
- Right-click the table name and select .
- In the Data Transfer Wizard, verify the Connection and Object names are correct.
- Select External File (default) as the Destination Type and click Launch.
- In the Export Data Wizard, type the directory path and name of the output file that receives the data. You can find a file in your file system by clicking Browse to navigate to and select the file.
-
Select one of the following options in File Type:
Option Description Delimited Text Text file that uses delimiters to separate data; such as, commas or semicolons in a TXT or CSV file. Excel (.xlsx) Microsoft Excel file with.xlsx file extension. Excel 87-2003 (.xls) Microsoft Excel file with.xls file extension. - [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
-
If you selected Delimited Text as the file type, complete these fields:
Field Description/Action Column Delimiter Type of delimiter to use in the output file using the list. The options are: - Comma
- Semicolon
- Space
- Tab
- | (vertical bar)
Character String Delimiter Distinguishes a string text. The options are: - " (double-quotes)
- ' (single quote)
- None
File Encoding Character set used to encode the data. The options are: - UTF-8
- utf-16
- ISO-8859-1
- UTF-16BE
- UTF-16LE
- US-ASCB
- Cp1252
If you selected Excel (.xlsx) or Excel 97-2003 (.xls), there are no additional options to complete.
- Click Next to filter the Aster table data when it is exported and preview the generated SQL. You can click Finish at any time to export data.
-
In Filter Selected Table indicate whether to filter by columns or by data for each column to be exported using one of these methods:
Filter Option Action Filter by a column Check the box beside the column name Filter by data For each table column select a filter value from the Select By list and type the paired value. For example, the filter "> 200"" includes only those values greater than the numeric value 200. - Review the generated SQL/DDL in the SQL Preview Filter and edit the SQL/DDL statements if needed.
- Click Finish.