Parse Views to Tree Structure

Database

Parse Views to Tree Structure

I'm searching for a tool or utility that will take views and create a tree structure. My task is develop a comprehensive mapping of my company's inbound and outbound processes. Since a majority of our outbounds are sourced from views an automatic method of generating a tree-like strucutre in text or xml would be a huge help.

I found a post (http://forums.teradata.com/forum/database/query-to-find-out-the-table-name-and-the-columns-of-that-table-associated-with-a-view) that mentions Teradata Utility Pack's Meta Data Services but doesn't explain which function to use or point to any documentation.
Tags (4)
3 REPLIES

Re: Parse Views to Tree Structure

bump
Senior Apprentice

Re: Parse Views to Tree Structure

I don't know much about the MDS, but there's documentation available:

http://www.info.teradata.com/templates/eSrchResults.cfm?txtrelno=&nm=Teradata%20Meta%20Data%20Services&srtord=Desc&txtttlkywrd=MetaDataServices&txtpid=&prodline=&rdSort=Date

It probably provides all you need, but it's not a client to be installed on your PC, it's a complex environment.

Dieter
Teradata Employee

Re: Parse Views to Tree Structure

Actually most of MDS is a client component that can be easly installed & used from a PC or laptop. One of the features of MDS is that it can provide analysis of Views which includes information on nested views (views that reference views).
The MDS web application called MetaSurf provides this type of nested view information as well as providing base table information for views.