Before you can extract catalog source metadata, complete prerequisite tasks.
Perform the following tasks:
•Save the Teradata MultiLoad Script files from which you want to extract metadata on the runtime environment.
•Verify permissions to access the Teradata MultiLoad Script catalog source and the Teradata database source system.
•Create a connection.
Verify permissions
To extract Teradata MultiLoad Script metadata, you need account access and permissions to the Teradata MultiLoad 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 MultiLoad 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 MultiLoad 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 MultiLoad 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 one 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.
Default is Native.
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.