Teradata

Learn how to set up and verify Teradata metadata sources using Cloudera Data Lineage (formerly Octopai).

Tool Permissions Prerequisites

Open Server Port for each Teradata Database Connection

Exiting/New Teradata user (OCTOPAI_USER*) for each connection with grant read permission for the following dictionary tables:

  • dbc.tablesv
  • dbc.indicesV
  • dbc.tvm
  • DBC.TVFields
  • DBC.triggersTbl
  • dbc.ColumnsV
  • dbc.dbase
  • dbc.texttbl
  • dbc.tablesv

Setting up Teradata Metadata Source

Metadata Sources are set on the Octopai Client

Figure 1. New Metadata Source wizard

Verify extraction results

After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.

Troubleshoot

If an error occurs during the extraction, see Troubleshoot connector extraction failures.