Metadata Manager

& Business Glossary

Overview
& What’s new in 8.6.1

Erwin Dral, Product Manager

Wednesday, December 10, 2008

1
Metadata Manager & Business Glossary

• Why is metadata important

• How does Metadata Manager help
• What’s New in Metadata Manager 8.6.1
• What is Business Glossary
• Demo!
• How do customers use it?
• What’s coming?
• Q&A

2
What questions are you asking about your
data?
How it is What data exists in
transformed my enterprise?
from system to How does one
system across data element
the enterprise? relate to
another?

Where does it How should

comes from? business terms
and data
elements be
defined?

Who
Can I trust my understands
data? what our data
means?

3
The Data Integration Refinery
What does this button do?

4
 Metadata Manager
Predefined Metadata Extraction
Business Glossary

Relational &
Mainframe ERP Data Modeling Tools BI Tools
Flat Files
DB2/zOS SAP R/3 Oracle PowerCenter CA ER/win Oracle BI
IBM DB2 (incl Logical model) Business Objects
SQL Server Oracle Designer Cognos
Sybase Sybase PowerDesigner Microstrategy
Informix IBM Rational ER Hyperion EssbaseIS
Teradata Microsoft Visio DM DB2 Cubeviews
Netezza Embarcadero ER Studio
Flat Files

Custom

* blue: introduced in this release

5
 Metadata Manager
What’s New in 8.6.1

6
What’s New in Metadata Manager 8.6.1?
• New, Cleaner User Interface
• Export to Excel of Lineage Diagram
• For off-line, in-depth analysis
• Lineage URL API
• Cookie to bypass login
• Improved Manageability
• More logging information
• New Metadata Exchange for Advanced Edition (xConnects)
• Oracle BI
• CA ER/win (including Logical models)
• New version certifications for Metadata Exchange AE
• Business Objects XI R3
• Cognos 8.3
• Teradata 12

7
Oracle BI EE

8
CA ER/win including Logical Models

9
Link to lineage from 3rd Party tools

10
 Business Glossary in
Metadata Manager

11
 Business Glossary
Key to Cross-functional Collaboration

Specification Developer
Data Analyst
Mapping “What am I
“How do I ensure business
requirements are translated supposed to build?”
correctly?”

Metadata
• Business
• Technical

Glossary
Report
Data Steward Business User
“How can I ensure everyone “What am I looking at
uses data consistently?” and can I trust it?”

12
 Business Glossary
Simple, Extensible Model

Business Glossary
• Category
(Name, Description, Usage, Data Steward, Owner)
• Business Term
(Name, Description, Context, Business Rule, Status, Data Steward, Owner, Reference Table)

• You can
• add new properties to these classes
• add new classes (ie for Project, Application)
• have more than one glossary
• Have one term in multiple categories (in different glossaries!)
• use picklists for Status, Data Steward, Owner
• Use RTM to view and manage valid values

• You can not

• rename existing BG classes or properties

13
Business Glossary 8.6.1
Screenshot - alphabetic view

14
Business Glossary 8.6.1
view by Category

15
Business Glossary 8.6.1
Reference Table for Valid Values of a Term

16
Business Glossary 8.6.1
Screenshot – Lineage for a Term

17
 Motorola Case Study

18
 Motorola
Empowering the Business with Metadata
KEY BUSINESS IMPERATIVE

• Data Governance with data ownership across 7 key

IT INITIATIVE tracks of the organization
Data Governance • Complete business “usership” of data sources
• Enhance the efficiency of their IRB project
DATA INTEGRATION PROJECT (Information to Run the Business)
Metadata Management

THE CHALLENGE INFORMATICA ADVANTAGE RESULTS/BENEFITS

• Business was not getting • Single integration metadata • Increased confidence and
information quick enough catalog capturing both understanding to the data
• Lack of single repository for business and technical used to run the business
business and technical metadata. • Enhanced alignment
metadata • Ability to trace source to between IT and the
• Data from legacy systems target across repositories, business
and packaged software track changes and see where • Quick access to business
spread across different data came from terms and definitions to
platforms • Personalized data lineage perform business impact
with progressive disclosure analysis

Informatica Confidential - Internal Use Only

19
Metadata Manager & Business Glossary
Summary

Increasing Insight into Complex Data Relationships

Across the Enterprise
• Deliver trusted data • Integrated Data Profiling
• Rich Metadata Analysis (Lineage)
• Definition of Valid Values and
Business Rules by SME
• Facilitate Cross • Common Definitions of Business Information
Functional Collaboration • Linking Business and Technical metadata

• Improve • Basic and Advanced Search

Responsiveness • Personalization
• Comprehensive Impact Analysis
• Metadata Reporting

20
 Additional Information

• Updated Velocity (IPS Best Practices)

with Metadata Manager
• Metadata Manager Website
• http://www.informatica.com/ and search for Metadata Manager

• Contacts
• Kin Cheung, Product Marketing – [email protected]
• Erwin Dral, Product Management – [email protected]

21
Your Questions wrt Metadata Manager

22