Before you can extract catalog source metadata, complete prerequisite tasks.
Verify the following prerequisites:
•Ensure that you have Teradata BTEQ Script files saved on the runtime environment from which you want to extract metadata.
•Verify permissions to access the Teradata BTEQ Script catalog source and the Teradata database source system.
•Create a connection.
Verify permissions
To extract Teradata BTEQ Script metadata, you need account access and permissions to the Teradata BTEQ 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 execute 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 BTEQ 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 following connection details:
Property
Description
Connection Name
Name of the Teradata BTEQ Script connection. Must be unique within the organization.
Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Maximum length is 100 characters.
Connection names are not case sensitive.
Description
Optional description of the connection.
Maximum length is 255 characters.
Type
Type of connection. Ensure that the type is Teradata.
4Enter properties specific to the Teradata BTEQ Script connection:
Property
Description
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
Name of the Teradata database that you want to access.
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
Username
Name of the user that connects to the Teradata database instance.
Password
Password to connect to the Teradata database instance.