Before you can extract catalog source metadata, complete prerequisite tasks.
Perform the following tasks:
•Save the Teradata FastExport Script files from which you want to extract metadata on the runtime environment where you want to run the metadata extraction job.
•Verify permissions to access the Teradata FastExport Script catalog source and the Teradata database source system.
•Create a connection.
Verify permissions
To extract Teradata FastExport Script metadata, you need account access and permissions to the Teradata FastExport Script catalog source and the Teradata database source system.
Verify that the Metadata Command Center administrator has the following permissions:
•Read permissions to access the folder containing scripts
•Permission to run the following queries on the Teradata database:
- HELP PROCEDURES
- HELP MACROS
- HELP VIEWS
- SHOW PROCEDURES
- SHOW MACROS
- SHOW VIEWS
•Permissions to configure the Teradata database connection:
- select on dbc.COLUMNSV
- select on dbc.TABLESV
- select on dbc.TABLETEXTV
- select on dbc.INDICESV
- select on dbc.ALL_RI_CHILDRENV
Create a connection
Before you configure the Teradata FastExport Script catalog source, create a connection object in Administrator.
Ensure that you have database source information to connect to the Teradata database.
1In Administrator, select Connections.
2Click New Connection.
3Enter the connection details.
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.