DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
dukesbrent



Group memberships:
Premium Members

Joined: 27 Jul 2016
Posts: 25

Points: 280

Post Posted: Fri Sep 16, 2016 7:57 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Unix
Is anyone aware of a data dictionary that is published by IBM or a third party on the XMETA database that is used to store IGC metadata?

We're looking for additional options for querying the metadata in the database, specifically around Business Glossary terms and Information Assets.

Any information you have would be greatly appreciated. Additionally, if you attempted to use the database in this way and had success or run into challenges I would appreciated any feedback.

Thanks,
Brent
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3743

Points: 29959

Post Posted: Fri Sep 16, 2016 1:26 pm Reply with quote    Back to top    

Hi Brent. Several years ago there were a set of SQL views that were formally published and documented for exactly this purpose. They exist on your server already, and are designed for doing w ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
dukesbrent



Group memberships:
Premium Members

Joined: 27 Jul 2016
Posts: 25

Points: 280

Post Posted: Fri Sep 16, 2016 1:53 pm Reply with quote    Back to top    

Thanks Ernie, these Views look very promising. On my first quick review, it looks like they cover Glossary terms but not other Information Asset types like Applications and BI Reports, but that was just based on my quick review. I'll take a closer look.

Thanks,
Brent
Rate this response:  
Not yet rated
dukesbrent



Group memberships:
Premium Members

Joined: 27 Jul 2016
Posts: 25

Points: 280

Post Posted: Tue Sep 20, 2016 12:40 pm Reply with quote    Back to top    

FYI: Also heard back from IBM support folks and they confirmed that what Ernie previously provided is the extent of documentation on the XMETA database.

Thanks again Ernie!

Brent
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54166
Location: Sydney, Australia
Points: 293772

Post Posted: Tue Sep 20, 2016 7:35 pm Reply with quote    Back to top    

It's probably worth mentioning that it has been a deliberate vendor decision not to publish the structure of the metadata repository, as it may (does) change over time. In earlier versions than 1 ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
rkashyap



Group memberships:
Premium Members

Joined: 02 Dec 2011
Posts: 514
Location: Richmond VA
Points: 4628

Post Posted: Wed Sep 21, 2016 9:02 am Reply with quote    Back to top    

ray.wurlod wrote:
In earlier versions than 11.x you could use Metadata Workbench to get a model of the metadata repository, but this seems to have disappeared from Information Governance Catalog in version 11.x. Crying or Very sad

If someone has used pre 11.X version of Metadata Workbench to generated a model of the metadata repository, then can you please share it. Even a dated model will a big help, as compared to guesswork and brute force validation that some of us resort to. Crying or Very sad
Rate this response:  
Not yet rated
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3573
Location: Australia, Melbourne
Points: 27832

Post Posted: Mon Sep 26, 2016 6:25 pm Reply with quote    Back to top    

There are four sets of views . CMVIEWS, IAVIEWS, IGVIEWS and REMVIEWS. IGVIEWS is terms and rules. CMVIEWS has other information assets metadata. I've written custom views in the past to pivot and flatten out custom attributes. You can also write metadata queries using the IGC query tool and dump that to file. You can use open IGC web services to get to objects in the repository.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours