Metadata Manager: 360 View of your BI Deployment

1 Metadata manager : 360 view of your BI Deployment360 view of your BI DeploymentMaria SilvaProject ManagerDunn Solutions GroupVinod NairTechnical LeadDunn Solutions GroupChaos2 Learning Points What is Metadata ? An effective way to manage your Metadata from multiple sources How to setup Metadata Integrator to connect to various sources that encompass your BI 3sources that encompass your BI infrastructure Key functionality of SAP Metadata manager toolMetadata: Metadata is definitional data that provides information about data managed within an application or system Attributes such as name, size, data type Structures such as length, fields, columns Properties such as where it is located, how it is associated, ownership Properties such as where it is located, how it is associated, ownership Descriptive information 4 Return on Investment Corporate data is a key strategic asset, Metadata in no exception Metadata is everywhere but is it organized? Is it easy to access? Is it easy to find?

2 Is it consistent? SAP Metadata manager can provide SAP Metadata manager can provide ROI in a few weeks: Centralize Organize Easy Access5 Identify MetadataIdentify Source of MetadataRetire MetadataMetadata LifecycleCapture MetadataApply semantics with MetapediaMaintain Metadata6 Best Practices Setting up a business glossary ( Metapedia ) Impact analysis reports Data stewardship 7 Different types of systems8 Architecture9 InstallationMetadata Management ComponentBOE Component it runs onAdministration and ExplorerBOE Application ServerMM Repository ObjectsCMSM etadata IntegratorsMM Job Server (Adaptive JS 10 Metadata IntegratorsMM Job Server (Adaptive JS & PS)Relationship ServerAdaptive Processing ServerSearch ServerAdaptive Processing ServerBusiness Glossary (Metapedia)Metapedia entry is a term or description that defines a business concept in your Glossary (Metapedia)Then associate a Metadata object(s) with the term12 Data LineageLineage analysis allows you to trace back from a universe object to the source13 Data Lineage14 Data Lineage 215 Metadata manager Demonstration16 Conclusion Proliferation of Metadata is a fact nowadays.)

3 We need effective tools to help us manage the overload and provide value to the corporate Metadata Business Metadata is the hardest one to capture. SAP Metadata manager can help us merge technical and business Metadata through the use of data stewardship 17business Metadata through the use of data stewardship and Matapedia