December 24, 2003 at 7:14 am
I'm looking for a metadata management solution for our enterprise. The solution needs to support SQL Svr 2k and Yukon, integrate w/ DTS, AS, RS, and the RDBMS. It also should make its content available to end users via any number of reporting tools (traditional Q&A and OLAP). Other DB technologies that it should support are Tandem and Oracle. Ease of management and the ability to extend the meta model are also important. The solution will be used not only for the DW/BI environment but also for data stewardship / information quality auditing and also for EAI. If you've used something or have an opinion please pass it along.
Kurt Allebach
Kurt Allebach
December 29, 2003 at 8:00 am
This was removed by the editor as SPAM
December 29, 2003 at 10:52 am
I haven't done much with warehousing, but AFAIK, isn't the Meta Data Services in SQL Server supposed to do most of this?
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 29, 2003 at 12:38 pm
MSFTs repository is great for accessing the technical metadata for the RDBMS and AS but doesn't support the capture and maintenance of business metadata in any form. It does a fair job of managing low level technical metadata regarding DTS packages but little at the higher end...i.e. multi source mappings and workflow. We need to extend the elements to include the business definitions, business rules, data quality and certification scores (who evaluated the attribute, what were the findings, what issues and f/u actions were identified, date of next review, etc.), capture metadata from third party tools such as ERWin, Trillium, etc. and to support dependency mapping so we can id the impact on the total solution of schema changes...what DTS packages, applications, web services, EAI messaging, reports, etc. are impacted by making these changes. Finally, we'd like to link our business process models (developed in BPWin using IDEF0 notation) to the metadata via the BPWin/ERWin repository. Finally, how does one expose this wealth of information to the various users...data architects, compliance/data stewards, report consumers, developers, etc.?
Bottom line is we may go w/ the MS repository with some custom extensions. I'd be happy to get 80% of what we want and we can get there w/ MS...just wondering what experiences others have had.
Thx for your thoughts.
Kurt
Kurt Allebach
Kurt Allebach
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply