How to access metadata using Universe stage

jojipjohn · Post by **jojipjohn** » Thu Dec 14, 2006 3:36 am

Hi,

Can anyone tell me how to use Universe stage to access the metadata. I want to get the source and target tables or files and the SQL used.

Thanks & Regards
Joji John

jojipjohn · Post by **jojipjohn** » Thu Dec 14, 2006 3:42 am

Should I Create a DSN If so how... I adding an entry to the UVODBC.CONGFIG file but I am not getting this DSN while importing the table definitions.

DSguru2B · Post by **DSguru2B** » Thu Dec 14, 2006 7:05 am

use dsn as localuv.

jojipjohn · Post by **jojipjohn** » Thu Dec 14, 2006 10:03 am

But if I use localuv I am getting only Example1, none of the metadata information are there

DSguru2B · Post by **DSguru2B** » Thu Dec 14, 2006 10:27 am

Not sure about that. Never played with the repository a lot. Maybe someone else can throw some more light on it. But why do you want to do that? Its considered a hack and not supported.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 14, 2006 2:15 pm

Metadata are - deliberately - incompletely described in the Repository. Further, import of the table definitions from the Repository tables is deliberately blocked. You would need to create synonyms and import the definitions from those.

You may like to review [urlhttp://www.dsxchange.com/viewtopic.php?t=105807]this post[/url] and this post which are both recent attempts to get at Repository data.

If you can be more precise about your requirements, we should be able to help. But no-one is going to write the whole chapter and verse about getting everything out of the Repository on this forum. This is not least because, with version 8.0, it all changes.