Documentation

Table of Contents:


    Teradata support (ODBC)

    Marcin Nagly - Dataedo Team Marcin Nagly 2019-03-14

    Teradata is currently not officially supported. Connection is possible with generic ODBC driver. Metadata returned depends on driver version and provider.

    We have tested and successfully connected to and imported metadata from Teradata with ODBC drivers listed below. It is highly likely it will work with other drivers as well.

    Tested ODBC Driver: Teradata ODBC

    We have tested and successfully connected to and imported metadata in following environment:

    ODBC version: 16.20 64-bit

    Teradata version: 16.20

    Supported schema elements and metadata

    Dataedo reads following metadata from Teradata databases.

    • Tables
      • Columns
        • Data type with length
        • Nullable
        • Default value
    • Views
      • Columns
        • Data type with length
        • Nullable

    Comments

    Dataedo reads Teradata comments from following objects:

    • Tables
      • Columns
    • Views
      • Columns

    Limitations

    Following schema/metadata elements currently are not supported:

    • Function/Procedure
    • View script
    • Trigger
    • Foreign keys
    • Primary keys/Primary index
    • Unique constraints

    ODBC Driver

    Download Teradata ODBC driver

    ODBC configuration

    Learn more

    Connect to Teradata

    Found issue with this article? Comment below
    0
    There are no comments. Click here to write the first comment.