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.
Connection properties
After you configure a connection to Teradata Database in Informatica Intelligent Cloud Services Administrator, you can view the connection properties for that connection on the Registration page in Metadata Command Center.
The following table describes the Teradata connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
Teradata
Runtime Environment
A runtime environment is either Informatica Cloud Secure Agent or a serverless runtime environment.
TDPID
Teradata Director Program Identifier (TDPID) specifies the host name or IP address of the Teradata database to which you connect.
Database Name
The Teradata database name.
If you do not enter a database name, Teradata PT API uses the default login database name.
Authentication Type
Select on of the following methods of authentication that verify the identity of a user connecting to Teradata database:
- Native. Default authentication type.
- LDAP authentication.
- KRB5. Kerberos authentication.
Metadata Advanced Connection Properties
Optional. Use to configure advanced behavior and performance of the Teradata Metadata Services (MDS) component of the Teradata database. Default is tmode=ANSI. Separate multiple options with an ampersand as in the following example: key1=value1&key2=value2
User Name
Name of the user account that connects to the Teradata database.
Password
Password for the user account that connects to the Teradata database.