Ispirer Ispirer
 

How to: extract sources from a Teradata database

To retrieve sources from a Teradata database you can use the Teradata command interface, BTEQ (Basic Teradata Query). Zip archive with the batch script running the BTEQ script is available for download here:

http://www.ispirer.net/downloads/Teradata_Metadata_Extraction.zip

The BTEQ script contains queries into the database to generate SHOW statements and place them into separate files.

Then the SHOW commands are run against the database to extract the sources to separate files for each object type: Tables, Views, Macros, UDFs, SPs, and TRGs.

Please note, that before running the BTEQ script you need to change the path to the BTEQ utility in the batch script and the .logon command in the BTEQ script to specify the correct credentials:

1. IP address of the database host

2. User

3. Password

sqlways/teradata/extract-sources-from-teradata.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement