Select Teradata (TPT) data

After you have connected to a Teradata database using the Teradata Parallel Transport service, the connector uses the Teradata FastExport utility to export data you select from the database.

Selecting data

Do the following:

1. Click the enabled Select... button on the Data tab in the lower part of the Edit Script dialog.

   The Edit Script dialog has two Select… buttons when the Teradata Connector has been connected but only the bottom button is enabled.

2. Select a table from the list of Database Tables in the Create Select Statement - Teradata dialog.. 

3. Select the fields to load from the list of Fields.

   The Fields list does not include fields that contain data types that are not supported. The unsupported types are: BLOB, CLOB, BYTE, and VARBYTE. Three Teradata data types are converted to string data:

   • Timestamp with TimeZone
   • Time with TimeZone
   • Year to Month interval

   The SQL SELECT statement that will be used to load data from the Teradata database displays under the Script tab in the bottom portion of the dialog box.

4. Click OK when you are finished making your selections.

   Once the SQL SELECT statement has been built, you can add a WHERE clause, if needed, directly in the script editor panel in the Edit Script dialog. The SQL SELECT statement for the Teradata (TPT) Connector does not support nested queries, calculated columns, or the JOIN statement. The columns must be a comma-delimited list.

The Teradata (TPT) Connector cannot be used to load data with Direct Discovery. A Teradata (TPT) Connector load statement can be used in the same script with a Direct Discovery load statement, but a DIRECT QUERY statement cannot load data across the Teradata Parallel Transport (TPT).