how can metadata management simplify boe maintenance and
TRANSCRIPT
Steve Hill – OEM Solutions EngineerWednesday, March 11, 2009
How Can Metadata Management SimplifyBOE Maintenance and Deployments?
AGENDA
1. Introduction2. Metadata Management Overview3. Product Walkthrough4. What is Metapedia?5. Q & A
Do you have any doubts about the accuracy ofyour reports?
BI deployments involve numerous tools
Each create its own metadata - Lots ofoverlap
Each metadata may have its own formatsand representation
Nearly impossible to view metadatarelationships across tools
Difficult metadata traceability
Metadata silos by IT and businessorganizations
ModelingTools
DatabasesETL
Challenges with Metadata Today
Metadata ManagementOverview
Consolidates, integrates,audits, and trust yourmetadata
Gets an accurate picture ofBI and data migration projects
Impact analysis and datalineage at your fingertips
Annotation, tagging, andsupplementing metadata
Advance searches
Custom attributesCustom AttributesAnnotations, Metapedia
Consolidate
Integrate Audit
BusinessMetadata
UniverseCreation
Metadata Management
Metadata ManagementBusiness User Benefits
Understand your BI and DataMigration projects
Manage metadata from variousdata sources, technologies, andsystems
Lower your TCO by tracking usageof data and reports
Improve decision making andregulatory compliance
Get an accurate picture of theentire BI project
Trusted data for accurate analysis,audit, and compliance
Estimate the cost of change,Impact analysis for the entireproject
Information you can trust
Metadata Integrators
Metadata Integrators bundled with Metadata Management
BOE XI/R2 - XI 3.1Data Integrator XI/R2Data Services XI 3.0 - XI 3.1Data Federator XI/R2, XI 3.0CWM XMLRDBMS - Oracle, MS SQL Server, DB2, Teradata, and JDBC sources
Metadata Integrators from MITI (OEM partner)(MITI - Meta Integration Technology Inc)
CA ERwin, Excel, Rational Rose, Sybase PowerDesigner, Oracle OWBplus metadata from other design tools, ETL tools, and OLAP/BI toolsApproximately 50 distinct metadata sourcesDetails list found athttp://www.metaintegration.net/Products/MIMB/SupportedTools.html
Product Walkthrough
What you will see:1. Integration with BOE2. Viewing Lineage3. Viewing Impact
Integration with CMC
Configure and scheduleBOMM integrators and
Source groups
Configure BOMM application:Properties, User securities,
Repository, and Utilities
Configure BOMM
Configure and scheduleBOMM integrators and
Source groups
Configuring BOE Integrator
Integration with InfoView
1. Launch BOMMwith single-sign on
2. View Reportlevel Data Linear
3. View Universe Objectlevel Data Lineage for
WebI reports
Metadata Management ExplorerView all objects
Metadata Management ExplorerView Lineage
Metdata Management ExplorerViewing Impact
Source Groups
New analysissettings: Source
groups and WhereClause
What’s Metapedia?
Metapedia – Business Metadata Encyclopedia
A business view of information resources
Relate business terms to objectsBridge the gap between business users and ITEnable business users access to information assets from theirperspectivePromote common, consistent and current understanding ofbusiness termsImprove data quality through consistent implementation ofbusiness conceptsEnable data governance, data stewardship and pro-activecompliance
MetapediaBusiness Metadata Encyclopedia
1. New business metadatafunctionality
2. Search includes businessterms and categories
3. Categorizebusiness terms
Metapedia – associate objects
1. Define business terms.Add custom attributes.
2. Relate to other terms
3. Associate to any metadataobjects
How Can Metadata Management SimplifyBOE Maintenance and Deployments?
Understand your BI and Data Migration projects
Estimate the cost of change, Impact analysis for the entire project
Manage metadata from various data sources, technologies, and systems
Lower your TCO by tracking usage of data and reports
Get an accurate picture of the entire BI project
Trusted data for accurate analysis, audit, and compliance
