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: