Skip to main content Skip to complementary content

Teradata (TPT) Connector

The QlikView Teradata (TPT) Connector enables QlikView to efficiently load data into an application from a Teradata database with the Teradata Parallel Transport service. The connector uses the Teradata FastExport utility to export data from the database.

The realtime output of the FastExport utility is piped into the connector where it is processed and piped into the QlikView application. The BTEQ utility is used to retrieve table metadata. The metadata is used by the QlikView Create Select Statement dialog to specify the table and columns to select for the SQL SELECT statement.

To use the QlikView Teradata (TPT) Connector, you must install the Teradata Tool Utilities (TTU) V13.10 or more recent. The TTU components that are required are the FastExport utility and the BTEQ utility. The TTU must be acquired directly from the Teradata Download Center:

Supported offerings

  • QlikView (Requires separate installation)

Check the Release Notes for details on compatibility and version history.

Supported Teradata (TPT) data types

All data is string. The following Teradata (TPT) data types are supported by the Teradata (TPT) Connector:

  • Char
  • VARCHAR
  • LONGVARCHAR

Three Teradata data types are converted to string data:

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

Calculated columns are not supported. Columns must be specified as a delimited list of column names.

The total length of the columns selected (66430) exceeds the maximum allowed length. The length must be less than 64000.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!