Exporting Data from Aster - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Connect to a Teradata Aster Database using a Connection Profile.
  2. Open Data Source Explorer and navigate to the Aster table you want to export.
  3. Right-click the table name and select Data > Export Data.
  4. In the Data Transfer Wizard, verify the Connection and Object names are correct.
  5. Select External File (default) as the Destination Type and click Launch.
  6. 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.
  7. 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.
  8. [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.
  9. 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.

  10. 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.
  11. 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.
  12. Review the generated SQL/DDL in the SQL Preview Filter and edit the SQL/DDL statements if needed.
  13. Click Finish.