Teradata RDBMS Connector

Overview

Used for OneTrust Data Discovery, the Teradata RDBMS connector connects to the multi-cloud data platform that hosts enterprise analytics typically used for large-scale data warehousing applications.

Pod Residency

rdbms-scanner

Connection Method

JDBC URL

Supported Scan Actions

Scan Type

Description

Catalog

Only the metadata in the database like details of schema, table, or column are scanned.

Catalog & Scan

Scans both metadata and data under the tables and returns the appropriate labels.

Credential & System Permissions

Important:

OneTrust recommends to adhere to your organization's security and infrastructure policy and include system engineer resources or other qualified subject matter experts to set up credentials on data sources. For specific instructions for how to enable these credentials, refer to your data source's implementation documentation, knowledge base and/or support resources.

This connector relies on a JDBC URL with username and password credentials. For more information, see Using the Teradata JDBC Driver.

Vault JSON:

JSON 
{
 "connectionUrl": "jdbc:teradata://<HOST>:<PORT>",  
 "user": <DB USERNAME>,  
 "password": <PASSWORD>
}

Default Credential Helper Fields:

JSON 
{
 connectionUrl": "jdbc:teradata://1.1.1.1:1025", 
 "user": "your_user", 
 "password": "your_password"
}

Scan Profile Support

Note:

For additional details on scan profile configuration and management, see Setting Up Scan Profiles.

Limits

  • Maximum number of schemas.

  • Maximum number of tables per schema.

  • Maximum number of rows per table.

Wildcard

Wildcards are not supported for column inclusion or exclusion.

  • Example: *Name* will not work to include/exclude both firstName and lastName columns

  • Instead, you must specify the exact column names separated by commas (e.g. firstName,lastName).

Important:

Columns Excluded in the Data Dictionary

When a column is excluded, it is still cataloged by the Data Dictionary. This means:

  • Basic metadata for the column is retrieved.

  • During extraction, the actual column content is skipped based on the configuration.

Include/Exclude Path Configuration Fields

  • Schema

  • Table

  • Column

Collected Objects & Fields

Objects

  • Schemas

  • Tables

  • Columns

  • Keys

Fields

  • Name

  • Field Type

  • Product family

  • Owner

  • Product Version

  • Product Name

  • Rows Estimate

  • Size Estimate

  • Comment

  • Column Index

  • Nullable

  • Primary Key Name

  • Foreign Key Name

  • Primary Key Columns

  • Foreign Key Columns