Contribute in GitHub: Edit online

Teradata Integration Requirements

The following are the prerequisites necessary for IBM Manta Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

• Teradata: version 12, 13, 14, 15, 16, or 17 including Vantage (remote)

• User having the following rights:

  • Read-only access to the DBC database (tables DBase, TVM, TVFields, All_RI_ChildrenV, indexes)
  • Permission to call SHOW VIEW, SHOW MACRO, and SHOW PROCEDURE statements
  • Creation of volatile tables

• Connection parameters:

  • Name or IP address of the Teradata server
  • Port on which the Teradata server listens
  • User name
  • User password
  • Database where the volatile tables are created (usually the same as the user name)

• Server must be accessible via network

• Teradata JDBC driver

  • The Manta Flow client distribution might not contain Teradata JDBC drivers that work with the version of the Teradata database you have, or it might not contain the most recent version of those drivers. Check if the file terajdbc-<version>.jar is present in the directory <MANTA_DIR_HOME>/scenarios/manta-dataflow-cli/lib-ext in the most recent compatible version. If not, download the most recent compatible version of the JDBC drivers from the Teradata website ( https://downloads.teradata.com/download/connectivity/jdbc-driver), remove the old drivers from the lib-ext directory, and place the new driver there.
  • Note that older versions or distributions of the Teradata JDBC driver may have used different names such as terajdbc4-<version>.jar and/or require additional files such as tdgssconfig-<version>.jar.

• BTEQ scripts

  • BTEQ scripts available on the filesystem in the form of files

  • BTEQ scripts need to be pure BTEQ—no Linux shell, PowerShell, or batch file wrappers are supported

  • Parameter mapping if placeholders are used in BTEQ scripts; a mapping to actual values in the format placeholderName=actualValue must be available in the form of a file on the filesystem

• TPT scripts

  • TPT scripts available on the filesystem in the form of files

  • TPT scripts need to be pure TPT—no Linux shell, PowerShell, or batch file wrappers are supported

Known Unsupported Features

IBM Manta Data Lineage does not support the following Teradata features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

• Lineage through dynamically executed code through EXECUTE IMMEDIATE
• TPT, BTEQ, or SQL files wrapped in Linux Shell, Windows Batch, or any other programming language