16.20 - Exporting Data from an ODBC-Compliant Source - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
  1. From the Source Type list in the Job Source dialog box, select ODBC DSN.
  2. In the ODBC Logon dialog box, type the host name, user ID, and password to log on.
  3. (Optional) Select the check boxes to include your user ID and password in the generated scripts. The default is to enter placeholders.
  4. Click OK.
    The Job Source dialog box displays the database and table hierarchy of the ODBC-compliant data source you logged onto.


  5. In the left pane, select a database and a table as the data source for the job.
    Do not select tables that contain character large object (CLOB) or binary large object (BLOB), JSON or XML data types.
    In the right pane, select up to 450 columns to be included in the source schema, or click Select All or Select None. (Press Ctrl+ click to select multiple columns.)
    The values under TPT Type are names of the data types associated with the Teradata PT columns; the values under DBS Type are the data types from the source database. When Teradata PT gets a column name from a source table, it looks at the definition schema of the table to determine an accurate data type. Sometimes these types can be recorded incorrectly or as a “?” when the Wizard cannot properly determine the data type. This often occurs when reading user-defined data types (UDTs).

    To change or correct a Teradata PT data type, click Edit Type (or right-click), and select the correct data type from the shortcut menu. You can also enter the length, precision, and scale if it is applicable, but the precision and scale data types are only available when Decimal/Numeric is selected.

  6. Click Next to open the Job Destination dialog box.


  7. Continue with Step 3 - Select a Destination.