Teradata Database is a Relational Database Management System (RDBMS) solution for data warehousing applications.
Objects extracted
The metadata extraction service extracts the following objects from a Teradata Database source system:
•Database
•Schema. The service extracts schemas along with descriptions.
•Table
•View
•Column
•Stored Procedure
Prerequisites for configuring the Teradata Database catalog source
•Use the Teradata connector to connect to the Teradata Database source system.
For information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.
•To extract metadata from a Teradata source system, copy the Teradata drivers to the following location in your Secure Agent installation:
- On Windows: <agent_installation_location>\ext\connectors\thirdparty\teradata
- On Linux: <agent_installation_location>/ext/connectors/thirdparty/teradata
Note: For Teradata Database versions lower than 16.20, copy the terajdbc.jar and tdgssconfig.jar drivers to the Secure Agent location. For versions higher than 16.20, copy only the terajdbc.jar driver to the Secure Agent location.
Configure permissions
To extract metadata and run profiles, you need account access and permissions for the Teradata database user account that you use to connect to the Teradata database.
Permissions to extract metadata
The following table lists the schema objects and system tables on which configure SELECT permissions for the Teradata database user account:
Schema Objects
System Tables
- Tables
- Views
- Functions
- Database
- select on dbc.COLUMNSV
- select on dbc.TABLESV
- select on dbc.DATABASESV
- select on dbc.TABLETEXTV
- select on dbc.INDICESV
- select on dbc.ALL_RI_CHILDRENV
You need permission on System tables to execute the help macro on the database for offline catalog purposes only.
Permissions to run data profiles
To perform data profiling, grant the Read permission to read data from the Teradata database.
Data profiling for Teradata objects
Configure data profiling to run profiles on the metadata extracted from a Teradata source system. You can view the profiling statistics in Data Governance and Catalog.
The data profiling task runs profiles on the following objects:
•Tables
•Views
The data profiling task runs profiles on the following data types:
•Bigint
•Byte
•Byteint
•Char
•Date
•Decimal
•Float
•Integer
•Smallint
•Time
•Timestamp
•Varbyte
•Varchar
Sampling type
Determine the sample rows on which you want to run the data profiling task.
You can choose one of the following sampling types for a Teradata Database catalog source:
- All Rows. Runs the profile on all rows in the metadata.
- Limit N Rows. Runs the profile on a limited number of rows. You can specify the number of rows to run the profile on.
- Custom Query. Enter a custom SQL clause to select sample rows to run the data profiling task on. For example, SAMPLE 100 or WHERE ID = 90. Verify that the syntax of the SQL clause matches the syntax of the database.
Data classification for Teradata objects
Configure data classification for Teradata catalog sources to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.