The Importance of Metadata

1. The Importance of Metadata JP Morgenthal Chief Architect, Professional Services Software AG, Inc.

2. Challenges Facing Most Organizations • About 80% of the Information Systems in Production Suffer from these Drawbacks: • Require IT assistance for end-user access • Difficult for end users to identify relevant information • Overload of information delivery • Provide only partial answers to questions • Often present out-of-date information • Contain enormous amounts of redundant information • Expensive to develop and maintain We’re Still Delivering Data, Not Information

3. The Analyst View • Integration is still #1 issue for the CIO • Ranked in Morgan Stanley CIO survey as the #1 problem • According to Gartner, 90% of business applications involve integration • Integration market is expected to grow 9.8% CAGR Gartner, August 2003 • Imperative need to provide a single view of information • “Developing an enterprise view of the customer is one of the primary requirements of a CRM-based sales and service strategy.” TowerGroup Research, March 2003 • Abundance of monolithic, mission-specific, silo systems • “More than 90% of enterprise applications in production are monolithic. Their business logic isnot externally accessible in a modular form that allows easy reuse in other applications.” Gartner, The Agile Enterprise, October 2003 • Inability to effectively aggregate data • "I feel like we are missing a major opportunity because our systems aren't integrated. We have to do a ton of custom coding right now, and unfortunately no one has shown us a solution that doesn't ask us to change our business model to fit the package." Insurance Company, Forrester Research

4. If we knew then what we know now… • How would your systems look if 20 years ago you knew what you know now Composite Application Business Rule Data Business Rule Composite Application Business Rule EMR

5. Enterprise Metadata RepositoryThe 3 Faces Metadata Management EMR Information Model Data Integration

6. Information Information Information Knowledge Moving From Data to Knowledge Mainframe Data Transformation Raw Data Accounting & Financial Data Aggregation Business Rules Filtering CRM Data Mainframe Data

7. EII Methodology XML Back Office Front Office XML Enabled Align Information Internet Intranet Mobile Forms Significantly improve the ROI of integration infrastructures .NETJ2EE Packaged Apps Web Services • Incremental Approach to an integrated enterprise • Flexible IT environment that leads to business agility • Fast, simplified, cost-effective integration • Reduces dependence on proprietary technologies New and Packaged Applications Non - XML Enabled Deliver Views Unlock Data Unlock Legacy for seamless participation in modern architecture On-demand business views give instant access to enterprise information Cobol CICS, IMSNatural, 3270 Mainframe, Unix, AS400 Analysis Tools Sales Force Automation • Instant access to enterprise information • Quick and easy definition of Business Vocabulary • Systematic mapping of Business terms to data sources • Speed implementation & reduce cost • Quick and easy transformation into services • Manages the mix of technology adoption Legacy Applications

8. Types of Metadata • Business Taxonomy • A categorical organization of the business semantics • Physical Data Asset Inventory • The metadata that comprises existing data sources and applications • Mappings • Data management models • E/R, OLAP, Transformations, XML Schemas, etc. • Web Services metadata • Business Process Metadata • Definitions of the rules that the business operates under • Metadata Relationships • How the metadata relates to other metadata components

9. Questions? • jp.morgenthal@softwareagusa.com