IBM Infosphere Server Metadata mangement

IBM infosphere metadata mangement

1. ®
IBM Software Group
© IBM Corporation
IBM Information Server
Metadata Management

2. IBM Software Group
IBM Information Server
Delivering information you can trust
2
Understand Cleanse Transform Deliver
Parallel Processing
Rich Connectivity to Applications, Data, and Content
IBM Information Server
Discover, model, and
govern information
structure and
content
Standardize, merge,
and correct information
Combine and
restructure
information for new
uses
Synchronize, virtualize
and move information
for in-line delivery
Unified Deployment
Unified Metadata Management

3. IBM Software Group
What Is Metadata, anyway?
3

4. IBM Software Group
Metadata Primer
Business Metadata
Business rules, Definitions, Terminology, Glossaries, Algorithms
and Lineage using business language. Audience: Business
users.
Technical Metadata
Defines Source and Target systems, their Table and Fields
structures and attributes, Derivations and Dependencies.
Audience: Specific Tool Users – BI, ETL, Profiling, Modeling.
Operational Metadata
Information about application runs: their frequency, record
counts, component by component analysis and other statistics.
Audience: Operations, Management and Business Users.
Administrative Metadata
Documents and audits development efforts, assigns Stewards,
and handles change management and governance. Audience:
Operations, Stewards, Tool Users and Management.
4

5. IBM Software Group
Developers
Subject Matter
Experts
Data
Analysts
Business
Users
Architects
DBAs
Why aren’t my tools
more integrated?
How do I know that that
I have an accurate view?
How can I actively collaborate
with developers?
What about Governance,
Security, Scalability?
Simplify administration,
deployment, & maintenance
How do I keep track of all
my transformations? How
do I know if they are using
the right rules?
What do our users need from their metadata?
5

6. IBM Software Group
Simplify Integration Increase trust and
confidence in information
Increase compliance to
standards
Facilitate change
management & reuseDesignOperational
DevelopersSubject Matter
Experts
Data
Analysts
Business
Users
Architects DBAs
Unified Metadata Management
What does Information Server help them achieve?
6

7. IBM Software Group
What don’t we do with metadata?
Information Server is not providing a general-
purpose enterprise metadata repository
There is no intent to maintain third-party metadata
The metadata goal for Information Server is to
provide linkages to what is known within the
domain of “data integration.”
7

8. ®
IBM Software Group
© IBM Corporation
IBM Information Server
Business Glossary
Metadata Workbench
NOTE: These slides are Copyright © 2007 by IBM and are for the intended
recipient only. Unauthorized copying or re-distribution is prohibited.

9. IBM Software Group
IBM WebSphere Business Glossary
9
Web-based
tool for
authoring,
managing,
and sharing an
enterprise
vocabulary &
classification
system

10. IBM Software Group
What is Business Metadata
Documents the business meaning of data and related
technology assets
Emphasis is on “the language of the business,”
independent of technology
Goals
Define a shared meaning of data
Establish responsibility, accountability,
and traceability
Help govern access and “state”
Share insights & experiences among users
Managed by those that
understand the meaning and importance
of the information assets to the business
Better aligns the efforts of IT with the goals of the business
10

11. IBM Software Group
Key features of Business Glossary
Support for the definition of a business taxonomy
Data governance “enabler” with strong emphasis on
stewardship
Ability to import externally created hierarchies
Web enabled search and browse interface
Provides business level tie to all data integration meta
data
11

12. IBM Software Group
Shared
Metadata Server
& Repository
Term: Tax Expense
Full Name: Tax to be
paid on Gross Income
“The expense due to
taxes …..”
(John Walsh is
responsible for updates.
90% reliable source)
Status: CURRENT
Database = DB2
Schema = NAACCT
Table = DLYTRANS
Column = TAXVL
data type = Decimal
(14,2)
Derivation: SUM(TRNTXAMT)
Achieve a common vocabulary between business & technical users!
DataStage Business Glossary
12

13. IBM Software Group
Business Glossary helps enterprises establish and
manage a business “taxonomy”
What is a “taxonomy?”
Represents “controlled vocabularies” whose terms exist in hierarchical relationships
Helps guide the browsing of “vocabularies”
Models the relationship between broad and more narrow terms
13
- Consumer Products Retailing
- Finance
- General Ledger
- Account Number
- Account Type
Example:

14. IBM Software Group
Benefits of WebSphere Business Glossary
14
 Consolidated and single view of enterprise wide business information
 Facilitates the organization of business terms into a logical and
hierarchical structure
 Supports assignment of ownership to business metadata to
augment and strengthen corporate governance policies
 Relates business terms to technical facts
 Encourages interaction among professionals throughout the
organization (who know the business information best)
 Provide a feedback facility for data owners

15. IBM Software Group
What is the IBM Metadata Workbench?
Includes out of the box reporting on:
Data movement
Data lineage
Business meaning
Impact of changes
Dependencies
15
Web-based interface for exploration and management of
assets produced and consumed by Information Server

16. IBM Software Group
How does it work?
16
IBM WebSphere Metadata Server
Metadata Services
Import/Export
Manager
IBM WebSphere
Metadata Workbench
Metadata
Workbench
WebSphere
Federation Server
WebSphere
Business Glossary
Information Server
Components
WebSphere
DataStage &
QualityStage
Information
Analyzer
Enterprise Information
Assets,
e.g. Business Reports
Information Server
components generate design
time and runtime metadata,
automatically storing it in the
Metadata Server
Metadata Workbench allows
users to explore, analyze, and
enrich the metadata in the
Metadata Server

17. IBM Software Group
Metadata Workbench Feature Overview
Explore & analyze Information Server assets
 Browse individual objects or utilize cross-suite views
 Simple and advanced search
 Review asset relationships graphically
 Build queries
 Trace data movement to/from databases, Jobs and reports
 Understand business meaning
 Measure the impact of change
17

18. IBM Software Group
Metadata Workbench Feature Overview
Manage Information Server assets
 Edit names and descriptions
 Reconcile duplicates
 Access runtime information to enrich reporting
18

19. ®
IBM Software Group
© IBM Corporation
IBM Information Server
Metadata Management
NOTE: These slides are Copyright © 2007 by IBM and are for the intended
recipient only. Unauthorized copying or re-distribution is prohibited.

20. IBM Software Group
VP Sales North America is looking at the annual customer
activity report – what is the ultimate source for the column
Customer Name?
Analyze data lineage for a report column
20

21. IBM Software Group
21

22. IBM Software Group
A DataStage ETL developer wants to make a change to the
column CUST_NAME and needs to understand which jobs
or reports will be impacted by this change.
Impact Analysis based on a column
22

23. IBM Software Group
23

24. IBM Software Group
Analyze system dependencies
24
The data warehouse server needs to be upgraded. Who
should I notify and coordinate downtime with?

25. ®
IBM Software Group
© IBM Corporation
Thank you