Transcription
Deliver Trusted Information WheneverNeededAndrew TC LauSenior Sales Specialist, InfoSphere, IBM
Pain Point: Understanding Core Information Assets“I don’t have theinformation I need” –Business Analyst“This data does notlook right” –Business User“We are not leveragingour information” Architect“How can I seehow this is used” –GovernanceSteward“What systems will beimpacted from this change” DBA3“I’m not sure what thebusiness wants” Developer
Who are Looking for Trusted Information?Target Audience Data/Business Analysts Subject Matter ExpertsData/BusinessAnalysts ArchitectsSubject Matter ExpertsArchitectsGovernanceStewardsWhat do these roles do today? Governance Stewards Manage information manually in disconnected tools,documents,and spreadsheetsTrustedInformationWhat are they working on? 1. AccurateWhat is wrong with what they do today?Information-centric projects:2. Complete Time consuming – churn between business & IT BI & Data Warehousing Imprecise & error prone – manual processes not3. Insightful Master Data Managementthorough enough4.RealTime Application Implementation,Consolidation or Migration No collaboration – different roles work in silos Information Architecture Lacks audit trail – no ongoing record Governance Initiatives Redundancy – duplication of effort & storage4
Trusted Information ManagementCreate, manage, govern and deliver trusted informationGet A single view of your businessIBM InfoSphere MDM ServerGet your arms aroundyour dataDeliver better businessintelligence fasterIBM InfoSphereFoundation ToolsIBM InfoSphereWarehouseConsolidate your application infrastructureIBM InfoSphere Information Server5
InfoSphere Foundation ToolsConvert information into a trusted strategic assetOnly IBM hasinvested to providethe breadth ofcapabilities todefine and governyour information Business Vocabulary Data Relationships Data Quality Compliance Data Models andMapping Business SpecificationRules Provenance ofinformation Discover and understand the data acrossheterogeneous systems Design trusted information structures for businessoptimization Govern that information over time
InfoSphere Foundation ToolsBusinessGlossaryTerm PackManage BusinessTermsDesign EnterpriseModelsBusiness GlossaryData ArchitectTarget ModelAssess Monitor,Manage DataQualityInformation AnalyzerShared MetadataLeverageIndustryPracticesIBM IndustryModels7Understand DataRelationshipsDiscoveryDevelop MappingSpecificationsFastTrackTrack Data LineageMetadata Workbench
InfoSphere Foundation ToolsEnterprise ProjectsTest Data GenerationApplication Retirement &ConsolidationData ArchivalData De-identificationData QualityData IntegrationMaster Data ManagementData WarehousingManage BusinessTermsDiscover DataRelationshipsDesign EnterpriseModelsCapture DesignSpecificationsAssess, Monitor,Manage Data QualityMonitor Data FlowsBusiness GlossaryDiscoveryData ArchitectFastTrackInformation AnalyzerMetadata WorkbenchDiscover8DesignGovernance
InfoSphere Business Glossary Starting point for designinginformation governanceWeb-based authoring, sharing &management of business metadataEnhanced collaboration– Aligns the goals of thebusiness with the efforts of IT– Accelerate project delivery withinformation sharingDefine relationship betweenbusiness definitions and IT assetsDrive information trust acrossenterprise applications– From any application, click andautomatically search glossaryEstablish accountability– Creation of stewards andassignment of responsibilitiesGovernance StewardsAny UserInfoSphere Business GlossaryDesign &GovernCreate and manage businessvocabulary and relationships andrelated to physical sourcesBusiness Context View
Create a Common VocabularyCategory: CostsDatabase DB2Term: Tax ExpenseSchema NAACCTFull Name: Tax to be paid onGross IncomeTable DLYTRANSColumn TAXVL“The expense due to taxes .”data type Decimal(14,2)(John Walsh is responsiblefor updates. 90% reliablesource)Derivation: SUM(TRNTXAMT)Status: CURRENTAchieve a common vocabulary between business & technical users!SharedMetadata Server& RepositoryInfoSphere DataStageInfoSphere Business Glossary
InfoSphere Business Glossary Anywhere3. Select term to viewfull details.2. Candidate termsreturned.1. Highlight term Active and clickto look up in Business Glossary
Cognos Integration with Glossary12
InfoSphere Business GlossaryRequirementsCreate and manage businessvocabulary and relationships andrelated to physical sourcesBusiness Glossary Capture business terms andclassifications Link business terms andclassifications to IT assets Identify data stewards andmake glossary accessibleBenefits Context for information isavailable to everyone,immediately IT projects are aligned withdata governance Collaboration increasesacross business and IT13
InfoSphere Foundation ToolsEnterprise ProjectsTest Data GenerationApplication Retirement &ConsolidationData ArchivalData De-identificationData QualityData IntegrationMaster Data ManagementData WarehousingManage BusinessTermsDiscover DataRelationshipsDesign EnterpriseModelsCapture DesignSpecificationsAssess, Monitor,Manage Data QualityMonitor Data FlowsBusiness GlossaryDiscoveryData ArchitectFastTrackInformation AnalyzerMetadata WorkbenchDiscover14DesignGovernance
InfoSphere Discovery Leverage unique capabilities of Discovery for rapiddevelopment Automate data relationship analysis and share withInformation Analyzer for quality programs and DataArchitect for enhanced enterprise modeling Migrate off legacy applications easier - discovertransformation logic and generate replacement ETL jobswith FastTrack Leverage prototype consolidation capabilities withDataStage/QualityStage – get it right the 1st time Create business objects (logical units such as“customer”) for test data management, data growth andapplication retirement projects with Optim portfolio Extended heterogeneous connectivity DB2 zOS; IMS, VSAM, ADABAS, DataCom, IDMS, zOSflat files through Classic Federation Server15
InfoSphere DiscoveryRequirementsAccelerate project deployment byautomating discovery of yourdistributed data landscapeDiscovery Discover datatransformation rules andheterogeneous relationships Identify hidden sensitivedata for privacy Define business objects forarchival, test data and otherintegration applicationsBenefits Automation of manualactivities accelerates timeto value Business insight into datarelationships reducesproject risk Provides consistencyacross information agendaprojects16
InfoSphere Foundation ToolsEnterprise ProjectsTest Data GenerationApplication Retirement &ConsolidationData ArchivalData De-identificationData QualityData IntegrationMaster Data ManagementData WarehousingManage BusinessTermsDiscover DataRelationshipsDesign EnterpriseModelsCapture DesignSpecificationsAssess, Monitor,Manage Data QualityMonitor Data FlowsBusiness GlossaryDiscoveryData ArchitectFastTrackInformation AnalyzerMetadata WorkbenchDiscover17DesignGovernance
IBM Industry ModelsRequirementsLeverage industry standard practicesand processes, models andterminology to accelerate projectsIBM Industry Models Leverage industry standardpractices and processes Populate Business Glossarywith full industry vocabulary Accelerate data modelingactivities for target systemsBenefits Accelerate yourInformation Agenda Optimize business aroundkey indicators Streamline workflows withindustry templates18
IBM Industry Data Models Address the FollowingBusiness AreasBankingFinancial MarketsHealth Plan(Banking Data Warehouse)(Financial Markets Data Warehouse)(Health Plan Data Warehouse) Profitability Risk Management Claims Relationship Marketing Asset and Liability Mgmt Medical Management Risk Management Compliance Provider and Network Asset and Liability Mgmt Sales, Marketing and Membership Compliance FinancialsInsuranceRetailTelco(Insurance Information Warehouse)(Retail Data Warehouse)(Telecommunications Data Warehouse) Customer centricity Claims Customer centricity Churn Management Operational efficiency Merchandising Management Relationship Mgmt & Segmentation Underwriting; Pricing; Profitability Store Operations & Product Mgmt Sales and Marketing Intermediary Performance Supply Chain Management Service Quality & Product Lifecycle Compliance Compliance Usage Profile Risk Management
InfoSphere Data Architect Design information infrastructuremodeling assets– Leverage profiling results fromInformation Analyzer– Create and optimize physical andlogical data models– Design and deploy federateddatabasesDefine enterprise standards to governdata models– Analyze models for conformance– Compare and synchronize acrossmodelsEnhance collaboration– Create glossary models andexchange with Business Glossary– SQL & XML generation capabilitiesData AnalystsDesign &GovernArchitectsData ArchitectModel, visualize, and relate diverseand distributed data assetsData Modeling, Mapping & Reconciliation
InfoSphere Data ArchitectRequirementsModel, visualize, and relate diverseand distributed data assetsData Architect Design and manageenterprise models Enforce model conformanceto enterprise standards Leverage industry datamodels for best practicesBenefits Speed design activities Populate BusinessGlossary from model terms Validate models forenterprise conformance21
InfoSphere Foundation ToolsEnterprise ProjectsTest Data GenerationApplication Retirement &ConsolidationData ArchivalData De-identificationData QualityData IntegrationMaster Data ManagementData WarehousingManage BusinessTermsDiscover DataRelationshipsDesign EnterpriseModelsCapture DesignSpecificationsAssess, Monitor,Manage Data QualityMonitor Data FlowsBusiness GlossaryDiscoveryData ArchitectFastTrackInformation AnalyzerMetadata WorkbenchDiscover22DesignGovernance
InfoSphere FastTrack Single managedinfrastructure for dataintegration projects to trackrequirements todeploymentDefine mappingspecification withbusiness rules andterms Create requiredtransformation rules forsource-to-target mappings Define and link businessterms to physical structures Generate DataStage jobs Generate historicaldocumentation for trackingAuto-generateDataStage jobsFlexible reportingand tracking
InfoSphere FastTrackRequirementsCapture Design Specifications andaccelerate translation into dataintegration projectsFastTrack Capture businessrequirements for source totarget mappings Leverage source analysisand business vocabulary Generate candidate ETLjobsBenefits Accelerate development ofintegration processes Centralized management ofspecifications Audit design decisions overtime24
InfoSphere Foundation ToolsEnterprise ProjectsTest Data GenerationApplication Retirement &ConsolidationData ArchivalData De-identificationData QualityData IntegrationMaster Data ManagementData WarehousingManage BusinessTermsDiscover DataRelationshipsDesign EnterpriseModelsCapture DesignSpecificationsAssess, Monitor,Manage Data QualityMonitor Data FlowsBusiness GlossaryDiscoveryData ArchitectFastTrackInformation AnalyzerMetadata WorkbenchDiscover25DesignGovernance
InfoSphere Information Analyzer In-depth analysis of heterogeneousinformation – IBM or non-IBM sources– Data-centric analysis of databases,files and enterprise applications forcontent, quality, and structure– Secure, detailed profiling of fields,and relationship analysis acrossfields and across sources On-going measurement and baselinereporting of information quality Know where information is managedacross systemsSubject MatterExpertsBusiness & DataAnalystsInfoSphere Information Analyze source datastructures, andGlossarymonitor adherence to integration andquality rules– Capture fitness of sources and reengineering requirements fordownstream usePhysical Understanding
Monitor Results over Time Data Quality Monitoring – scheduled processing Schedule & adhoc Data Rules,Rule Sets, andMetrics AnnotateExecution HistoryEvents Analyze SpecificResults, Trends, &Statistics View ExecutionDetails27
View Summarized Results Customize DataQuality Displaysand Scorecardsby project Organize byresults by userdefined folders Display StandardCharts & Trendsfor OngoingViews Track AnalysisStatus, DataTrends,Variances overBenchmarks, View OnlineDocumentation &ScreenInformation Dashboard Views & Alerts; Quality Reports28
InfoSphere Information AnalyzerRequirementsInformation AnalyzerAnalyze source data quality andmonitor adherence to integrationand quality rules Perform data qualityassessment Define business rules tomonitor data quality Establish stewards forgovernance of dataqualityBenefits Identify data qualityissues early to reduceproject risks Monitor quality metricsover time for compliance Create businessconfidence with trustedinformation29
InfoSphere Foundation ToolsEnterprise ProjectsTest Data GenerationApplication Retirement &ConsolidationData ArchivalData De-identificationData QualityData IntegrationMaster Data ManagementData WarehousingManage BusinessTermsDiscover DataRelationshipsDesign EnterpriseModelsCapture DesignSpecificationsAssess, Monitor,Manage Data QualityMonitor Data FlowsBusiness GlossaryDiscoveryData ArchitectFastTrackInformation e
InfoSphere Metadata Workbench Understand your end-to-endinformation infrastructureProactively manage and administeryour information infrastructure– Web-based exploration ofmetadata relationships –InfoSphere, modeling and BIapplications– Explore and analyze bothgraphically and textually– Perform searches andcustomized queriesAssess and mitigate changemanagement risk– Assess dependencies acrossInfoSphere and 3rd party tools– Trace data lineage of modeling,BI reports and InfoSphereobjectsSubject MatterExpertsGovernance StewardsArchitectsInfoSphere Metadata WorkbenchDesign &GovernSupport information governance withtraceability on InfoSphere data movement,modeling & BI applicationsImpact Analysis & Lineage
Where does a Field of Data in this Report Come From? We can trace data linage beyond just BI tools.–FTP–Stored Procedures–MQ–Anything .
Where Happens if I Change this Column? Show complete change impact in graphical or list formIncludes impact on reports in BI toolsVisually navigate through impacted objects across toolsAllows impact analysis on any object type
Using Cognos to trace Data LineageWe want to know where the data comes from where it flows to how it is transformedas it travels through the enterprise34
InfoSphere Metadata WorkbenchRequirementsSupport information governance withtraceability on data movement,modeling & BI applicationsMetadata Workbench Understand the impact ofmaking changes toinformation environment Visualize and traceinformation flows acrossenterprise landscape Access and report onoperational metadataBenefits Avoid system disruptions Provide audit informationfor data governance Build trust with LOB users35
Integrates Foundation Tools & Beyond13Establish Platform Import& Enhance Industry Model7Understand DataRelationshipsCognosDiscoveryData ArchitectDeliver ReportsPopulates2Define BusinessRequirement & Glossary4Assess, Monitor, ManageData Quality Rules5Map Sources to TargetModel6Generate Logic to LoadWarehouseLinksBusiness GlossaryInformation AnalyzerFastTrackDataStage &QualityStageMetadata ServerSimplification & Content: reduces project time, risk and cost!36
Your Choice Point Products? Models ETLCleansing WarehouseMDM Integrated Platform37 MashupsBI ?
Leading the way ETL ToolsBusiness Intelligence PlatformsData WarehousingData Quality ToolsData Integration ToolsCustomer Data Integration
Thank You!
Trusted Information Management Create, manage, govern and deliver trusted information Get your arms around your data IBM InfoSphere Foundation Tools Deliver better business intelligence faster IBM InfoSphere Warehouse Get A single view of your business IBM InfoSphere MDM Server Consolidate your application infrastructure IBM InfoSphere .
