Informatica數(shù)據(jù)倉庫解決方案課件

CTOMDMsolution

forLenovoDanBinInformatica

Chinabdan@CTOMDMsolution

forLenovoDanInformatica專注于企業(yè)數(shù)據(jù)集成與管理

成立時(shí)間:19932012年收入為:8.116億美元7年平均增長(zhǎng)率:每年17%員工人數(shù):3,000多人合作伙伴:

450多家主要的系統(tǒng)集成商、獨(dú)立軟件供應(yīng)商、原始設(shè)備制造商和按需生產(chǎn)的先驅(qū)客戶:超過5,000家客戶遍布全球82個(gè)國(guó)家直接客戶遍布全球28個(gè)國(guó)家客戶忠誠度排名位居榜首

（已連續(xù)7年獲此殊榮）Informatica專注于企業(yè)數(shù)據(jù)集成與管理

成立時(shí)間:企業(yè)內(nèi)部如果我們給客戶20%的折扣，營(yíng)收將會(huì)受到多大影響？最佳追加銷售和交叉銷售組合？根據(jù)天氣和數(shù)據(jù)制定的最佳行車路線？根據(jù)客戶喜好制定的最佳產(chǎn)品方案？哪個(gè)賬戶風(fēng)險(xiǎn)最高？風(fēng)險(xiǎn)最大的客戶？云SaaS虛擬化大數(shù)據(jù)社交物聯(lián)網(wǎng)對(duì)業(yè)務(wù)靈活性的持續(xù)需求數(shù)據(jù)大爆炸:復(fù)雜度、成本和風(fēng)險(xiǎn)IT業(yè)務(wù)信息平臺(tái)可執(zhí)行權(quán)威安全實(shí)時(shí)

可信全面3Informatica價(jià)值定位

提升數(shù)據(jù)價(jià)值、降低IT成本、達(dá)成業(yè)務(wù)使命多域關(guān)聯(lián)客戶/合作伙伴訂單

供應(yīng)商產(chǎn)品企業(yè)內(nèi)部如果我們給客戶20%的折扣，營(yíng)收將會(huì)受到多大影響？最中軟國(guó)際概覽4外包服務(wù)覆蓋銷售和提交中心政府制造與流通業(yè)金融行業(yè)高科技業(yè)電信行業(yè)保險(xiǎn)行業(yè)能源行業(yè)公共事業(yè)21個(gè)中國(guó)城市美國(guó)英國(guó)日本IT咨詢服務(wù)IT技術(shù)服務(wù)IT外包服務(wù)IT實(shí)訓(xùn)服務(wù)目錄覆蓋行業(yè)全球分布公司注冊(cè)資金：

1,0200萬元總部北京、香港股票代碼0354.HK2012年總收入27.68億元2012年服務(wù)收入25.51億元2003-2012年服務(wù)收入CAGR52%員工總數(shù)*18,946核心價(jià)值觀：

奮斗為本，成就客戶，創(chuàng)造分享，共同成長(zhǎng)！*截止到2012年12月31日中軟國(guó)際概覽4外包服務(wù)覆蓋銷售和提交中心政府21個(gè)中國(guó)城市I深厚的行業(yè)積累：藍(lán)籌客戶520個(gè)中國(guó)政府部委級(jí)機(jī)構(gòu)6個(gè)“十二金”工程100%覆蓋5大中國(guó)國(guó)有銀行12個(gè)20強(qiáng)全球銀行2個(gè)3強(qiáng)中國(guó)保險(xiǎn)公司7個(gè)GDP10強(qiáng)城市5個(gè)國(guó)內(nèi)能源巨頭政府制造與流通金融與銀行交通電信能源100%覆蓋100強(qiáng)中國(guó)卷煙品牌2個(gè)

3強(qiáng)中國(guó)自主汽車品牌4個(gè)5強(qiáng)中國(guó)機(jī)械制造企業(yè)5個(gè)10強(qiáng)中國(guó)鋼鐵企業(yè)“金審”“金質(zhì)”“金?！薄敖疝r(nóng)”“金宏”“金卡”100%覆蓋前3強(qiáng)中國(guó)電信運(yùn)營(yíng)商2個(gè)前3強(qiáng)全球電信設(shè)備供應(yīng)商上海北京深圳天津重慶杭州青島高科技產(chǎn)業(yè)4個(gè)5強(qiáng)全球軟件公司深厚的行業(yè)積累：藍(lán)籌客戶520個(gè)中國(guó)政府部委級(jí)機(jī)構(gòu)100%AgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMProjectPlanandImplementation6AgendaCTOMDMObjectivesandRObjectivesBuildmasterdatahubinsteadofPeertoPeermasterdataintegration.CreatesingleandtrustiestMarketing&Salesdataview.EnhancemasterdatacollaborationfoundationImprovedatacollaborationviewtosupportdatagovernanceECCCRMIPCLOISMDME-ComPRMB2BVendavo......ModelingECCCRMIPCLOISJDAMDMMasterData|TransactionDataVendavoPRM……ObjectivesBuildmasterdatahuOneMasterDataPlatformTrustMechanismIntegrated360?DataViewCollaborationCapabilityAutomaticIntegrateBusinessDataIntoMDMHubAutomaticDeliverDatatoDownstreamSystemsInteractiveUIforBusinessUser……SupportDataGovernanceStrategyRequirementsOneMasterDataPlatformRequirECCCRMIPCLOISMDME-ComPlatformPRMB2BVendavo......ModelingBPPrice&CostProduct&BOMCTOProductAttributeTransactionDataDataCalculationRawDataEnrichedDataDataConsolidationDataCleansingDataQualityDataReport&QualityReport2341TasksforPhaseIECCCRMIPCLOISE-ComPlatformPRMAgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMSolutionArchitectureSolutionFunctionsSolutionImplementationArchitectureSolutionAdvantageProjectPlanandImplementationInformaticaMDMCaseStudies10AgendaCTOMDMObjectivesandRMDMHubSolutionArchitectureMDMCTOModelingUI(Search,Configuration,Reports,Workflow)ECCCRMVendavoPlanningWindchillLOISIPCCRMLPOSLEOSB2CSFDC…etcMDMFoundationDataProcessingMasterDataStaging-inDataStaging-outDataDataInputDataOutputServicesWorkflowSolutionArchitectureMDMCTOMoCTOMDMFunctionMatrix7majorCriteriaInputdatafromupstreamsystems,andloadintostaging-indatastoreModelingCTOdatabyGEO/countryProcessingdatafromstaging-indatatoCTOmodelUI

forCTOdatareview,configuration,approvalReportCTOdatastatisticsintabularorchartWorkflowmanagementbasedonCTOapprovalOutputdatafromstaging-outdatastoretodownstreamsystems12CTOMDMFunctionMatrix7majorWebServicesMQSeriesJMSTIBCOwebMethodsSAPNetWeaverXIEncyryptedstreamPeoplesoftOracleAppsSiebelSAS…SAPNetWeaverSAPIDOCSAPBCISAPDMISAPBWOracleDB2UDBDB2/400SQLServerSybaseInformixTeradataODBCFlatFilesWebLogs…XMLIndustryFormatsFlatFilesFTPComplexFilesTapeFormats…ERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTapeFormats.PDF.DOC.XLSEmailCloudAppsEDIDIDeveloperDataInputECCCRMIPCLOISE-ComPlatformPRMB2BVendavo......Staging-inDataWebServicesPeoplesoftOracleXMWebServicesMQSeriesJMSTIBCOwebMethodsSAPNetWeaverXIEncyryptedstreamPeoplesoftOracleAppsSiebelSAS…SAPNetWeaverSAPIDOCSAPBCISAPDMISAPBWOracleDB2UDBDB2/400SQLServerSybaseInformixTeradataODBCFlatFilesWebLogs…XMLIndustryFormatsFlatFilesFTPComplexFilesTapeFormats…ERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTapeFormats.PDF.DOC.XLSEmailCloudAppsEDIDIDeveloperDataProcessingECCCRMIPCLOISE-ComPlatformPRMB2BVendavo......Staging-inDataMasterDataWebServicesPeoplesoftOracleXM9majorprocessesChar.SequenceCVVisibilityCTODefaultValueCTOCompatibilityCTOModelManagementFeatureManagementOptionManagementCustomModelQueryConfigurationSearchDataProcessingCorefunctions9majorprocessesDataProcessiDataProcessingbusinesslogictoprogramsDataProcessingbusinesslogicGUIdevelopmentandmanagementGUIdevelopmentandmanagementModeldesigntoolswithMDMspecialfunctionsOpendatamodelMetadatatrackingIndustryReferenceDataModelEasytoextendCTOModelinstoragelayer

FlexibleModeltoSupportCurrentandFutureBusinessCTOModelinstoragelayer

FleMasterDataModelDesign(example)CTOCategoryCTOCategoryCategoryNMCTO_C_1NPCTOCTO#CTOCategoryCTONameCTODescCTO_1CTO_C_1T430P

CTO_2CTO_C_1X220i

CTableC#CNMC_1KeyboardC_2HDDVTableV#C#VDescV_1_1C_1ENV_1_2C_1CNV_1_3C_1USV_2_1C_2500GBV_2_2C_21TBV_2_3C_2320GBCTOValueInstance#CTO#V#ChannelRegionHideI_1CTO_1V_1_1B2CUSNI_1CTO_1V_1_3B2CUSNI_1CTO_1V_2_2B2CUSYI_2CTO_1V_1_2B2CCNNI_2CTO_1V_2_3B2CCNNI_2CTO_1V_2_1B2CCNNI_3CTO_2V_1_2B2CCNNI_3CTO_2V_2_1B2CCNNI_3CTO_2V_2_3B2CCNYS

TableS#SNMS_1MiniMouseS_2ExtCameraS_31yearwarrantyCSTableC#S#CTO_1S_1CTO_1S_3CTO_2S_1MasterDataModelDesign(examDataasServicesConfigurableservicesframework(SOAenabled)aroundtheMDMHubplatformthatenablesreuseoftheunderlyinglogicAPIsforfine-grainedaccesstodataandobjectsintheHubPushbuttongenerationofdataservicesforuseinaWebServicesbasedintegrationSIFSDK,atoolkitforbuildingcoarse-grainedbusinessservicesDataasServicesConfigurablesODrulesasaservice:searchValidCVVariantTableSeqCVFlagNB_CRX2_ITL_TBL00001NB_SPI5_3427U_MB0NB_CRX2_ITL_TBL00001NB_WLANINTEL_CAN_6205S0NB_CRX2_ITL_TBL00001NB_WLANINTEL_CAN_6205S_BR0NB_CRX2_ITL_TBL00001NB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK021ODtableanddataCVValid_CValid_VFlagNB_SPI5_3427U_MBNB_WLANINTEL_CAN_6205S0NB_SPI5_3427U_MBNB_WLANINTEL_CAN_6205S_BR0NB_SPI5_3427U_MBNB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK0NB_WLANINTEL_CAN_6205SNB_SPI5_3427U_MB0NB_WLANINTEL_CAN_6205SNB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK0ODruledatasearchValidCVInput:<C>NB_SP</C><V>I5_3427U_MB</V>Output:<validC>NB_WLAN</validC><validV>INTEL_CAN_6205S</validV><validC>NB_WLAN</validC><validV>INTEL_CAN_6205S_BR</validV><validC>NB_INTEL_LABEL</validC><validV>2GEN_CORE_I5_VPRO_BLACK</validV>ODrulesasaservice:searchV22UIDevelopmentPlatformUIDevelopmentPlatformBizFramework:UIComponents,ServiceSupportingComponents,SampleApp.,CodeTemplate,BestPractice(Lib)ComponentFramework:ComponentLife-CycleMgt.,4A(AccessControl,Authorization,Authentication,Audit),SSOServiceFramework/ResourceMgt.Integration|AdaptorFramework/ESBWorkflowComponentFormComponentIntelligentAnalyticComponentOrg.&UserMgt.Roles&PermissionMgt.OtherComponentsBizFoundationCTOApplication(ConfigurationandModeling,…)B2BB2CSourceDataCTODataMDMDataECCCRMIPCLOIS......B2C......……B2BDataServiceMDM22UIDevelopmentPlatformUIDeUIbasedonservicestomanageCTO23UIbasedonservicestomanageUI–Reportandworkflow1)Workflow-drivenTaskInboxforInserts,Updates,andMatches2)Drill-downnavigationtoMasterDataRecord4)TaskPriorities5)Visualizationofreport3)TaskDetailsUI–Reportandworkflow1)WorExitTask1StartTask2CTOUserTask3MDMCTOManagerDataStewardDatadeliverInformaticaMDMhasembededworkflowCanbeintegratedbyapplications：Inquiry/modifytaskstatusQuery/UpdatedatabyWSWorkflowengineExitTask1StartTask2CTOUserTDataOutputExportapproveddatatodownstreamsystembasedonscheduleandrules26DataOutputExportapproveddatSecurityAccessManager(SAM)SecurityAccessManager(SAM)isMDMHub’scomprehensivesecurityframeworkAresourceisconfiguredtobesecureEachsecureresourceisconfiguredwithspecificprivilegesArolecanhaveaccesstooneormoresecureresources.AuserisassignedoneormorerolesSecurityAccessManager(SAM)SScalability28PartitionGridHadoopScalability28PartitionGridHadoClusterDeploymentNonDistributedHighAvailabilitySupportscontinuousopswithsinglefailureDoesnotfullyhandlenetworkorphysicalhardwarefailuresRecommendedArchitectureRedundantEnterpriseClassLoadBalancersApplicationServerFarmorthefullJ2EEclusterRedundantnetworkconnectionsandothernetworkinfrastructureOracleRACorVeritasDBclusterSANstoragewithredundantconnectionstoDBServerNetworkLBandFailoverWebAppCompositeServicesDBCluster(E.g.RAC)AppCluster-Infrastructure-ApplicationStackComponentsHubServicesHubServerHubORS-MDMHubClusterDeploymentNonDistribuLBandFailoverInfrastructureWebAppDisasterRecoveryDeploymentCompositeServicesDBReplicationDBCluster(E.g.RAC)AppClusterActive(A)-Infrastructure-ApplicationStackComponentsHubServicesHubServerHubORS-MDMHubDBCluster(E.g.RAC)AppClusterPassive(B)DistributedHighAvailabilitySupportscontinuousopswithsinglefailureHandlesnetworkorphysicalhardwarefailuresRecommendedArchitectureRedundantLoadBalancersGeographicallyDistributedHubs(HOT/HOTorHOT/WARMconfiguration)ApplicationServerFarmRedundantnetworkconnectionsOracleRACSANstoragewithredundantconnectionstoDBServerDBlogbasedreplicationbetweenenvironmentsLBandFailoverWebAppDisasterSolutionAdvantageTotalsolutionwithfasttimetovaluePhasebyphaseapproachStartsmall,extendtomorewithinuniqueplatformConfigurableplatformwithefficiency,scalabilityandextensibilityFlexibledatamodelingConfigurerulebyGUIScalablesystemarchitectureExtensiblefunctionsEasetointegratewithupstream/downstreamsystemswithopenplatformUniqueconfigurableplatformdeductextracosts,decreaseTCO31SolutionAdvantageTotalsolutiAgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMProjectPlanandImplementation32AgendaCTOMDMObjectivesandRVelocityCoreMethodologyVelocityistheblueprintfordeliveringefficientandsuccessfulInformaticasolutionsthatsolvebusinessproblems.VelocityCoreMethodologyPhases,Tasks,SubtasksBestPracticesRolesTemplates&AcceleratorsSampleDeliverablesAvailableat

VelocityCoreMethodologyVelocVelocityMDMImplementationOverviewManageAnalyzeArchitect&DesignBuild&TestDeploy&OperateActivitiesDefineVisionandScopePlanProjectManageProjectActivitiesGatherHigh-LevelRequirementsPerformDataAssessmentDefinePreliminarySolutionArchitectureSpecifyDetailedRequirementsAnalyzeDataStewardshipActivitiesFinalizeSolutionArchitectureDesignPhysicalDataModelDesignTechnicalSolutionDesignBusinessRulesDesignPoliciesandProceduresActivitiesSetupDev.EnvironmentBuildMDMHubBuildHierarchiesTunetheRulesBuildInterfacesBuildReportsPlanandPrepareTestPerformSystemTestingPerformVolume/PerformanceTestingPerformUserAcceptanceTestingActivitiesSetupProd.EnvironmentPreparetoDeployRolloutSolutionDeliverablesVisionandScopeProjectPlanProjectRiskAssessmentandMitigationPlanProjectRoleMatrixDeliverablesDataQualityAuditRequirementsSpecificationRequirementsTraceabilityMatrixDeliverablesTechnicalSolutionArchitectureMDMHubTechnicalDesignSpecificationUserInterfaceRequirementsandDesignSpecificationDeliverablesTestPlanandScriptsTestResultsandApprovalsTestReportDocumentedConfigurationConfiguredMDMHubDeliverablesProductionJobSchedulesApprovaltoDeployOperationsManualRunBookMajorMilestoneChartCheckpointReviewsProjectStatusReportsDeliverableAcceptanceEndofProjectReportVelocityMDMImplementationOvSOWandresourceplanforphaseone(B2B)35LenovoCTOModelingSOW：

B2B（PhraseI）

階段計(jì)劃周期(Weeks)備注1一、項(xiàng)目準(zhǔn)備1

2二、系統(tǒng)規(guī)格定義2

3三、系統(tǒng)設(shè)計(jì)3

4四、配置和開發(fā)12

5五、系統(tǒng)集成測(cè)試3

6六、系統(tǒng)上線準(zhǔn)備2

7七、系統(tǒng)優(yōu)化調(diào)整2

系統(tǒng)上線

上線后支持

系統(tǒng)優(yōu)化配置

系統(tǒng)優(yōu)化測(cè)試

SOWandresourceplanforphasSOWandresourceplanforphasetwo(B2C)36LenovoCTOModelingSOW：

B2C（PhraseII）

階段計(jì)劃周期(Weeks)備注1一、項(xiàng)目準(zhǔn)備1

2二、系統(tǒng)規(guī)格定義2

3三、系統(tǒng)設(shè)計(jì)１

4四、配置和開發(fā)８

5五、系統(tǒng)集成測(cè)試3

6六、系統(tǒng)上線準(zhǔn)備2

7七、系統(tǒng)優(yōu)化調(diào)整2

系統(tǒng)上線

上線后支持

系統(tǒng)優(yōu)化配置

系統(tǒng)優(yōu)化測(cè)試

SOWandresourceplanforphasQ&AQ&A謝謝！?2013Informatica.ProprietaryandConfidential38謝謝！?2013Informatica.ProprietCTOMDMsolution

forLenovoDanBinInformatica

Chinabdan@CTOMDMsolution

forLenovoDanInformatica專注于企業(yè)數(shù)據(jù)集成與管理

成立時(shí)間:19932012年收入為:8.116億美元7年平均增長(zhǎng)率:每年17%員工人數(shù):3,000多人合作伙伴:

450多家主要的系統(tǒng)集成商、獨(dú)立軟件供應(yīng)商、原始設(shè)備制造商和按需生產(chǎn)的先驅(qū)客戶:超過5,000家客戶遍布全球82個(gè)國(guó)家直接客戶遍布全球28個(gè)國(guó)家客戶忠誠度排名位居榜首

（已連續(xù)7年獲此殊榮）Informatica專注于企業(yè)數(shù)據(jù)集成與管理

成立時(shí)間:企業(yè)內(nèi)部如果我們給客戶20%的折扣，營(yíng)收將會(huì)受到多大影響？最佳追加銷售和交叉銷售組合？根據(jù)天氣和數(shù)據(jù)制定的最佳行車路線？根據(jù)客戶喜好制定的最佳產(chǎn)品方案？哪個(gè)賬戶風(fēng)險(xiǎn)最高？風(fēng)險(xiǎn)最大的客戶？云SaaS虛擬化大數(shù)據(jù)社交物聯(lián)網(wǎng)對(duì)業(yè)務(wù)靈活性的持續(xù)需求數(shù)據(jù)大爆炸:復(fù)雜度、成本和風(fēng)險(xiǎn)IT業(yè)務(wù)信息平臺(tái)可執(zhí)行權(quán)威安全實(shí)時(shí)

可信全面41Informatica價(jià)值定位

提升數(shù)據(jù)價(jià)值、降低IT成本、達(dá)成業(yè)務(wù)使命多域關(guān)聯(lián)客戶/合作伙伴訂單

供應(yīng)商產(chǎn)品企業(yè)內(nèi)部如果我們給客戶20%的折扣，營(yíng)收將會(huì)受到多大影響？最中軟國(guó)際概覽42外包服務(wù)覆蓋銷售和提交中心政府制造與流通業(yè)金融行業(yè)高科技業(yè)電信行業(yè)保險(xiǎn)行業(yè)能源行業(yè)公共事業(yè)21個(gè)中國(guó)城市美國(guó)英國(guó)日本IT咨詢服務(wù)IT技術(shù)服務(wù)IT外包服務(wù)IT實(shí)訓(xùn)服務(wù)目錄覆蓋行業(yè)全球分布公司注冊(cè)資金：

1,0200萬元總部北京、香港股票代碼0354.HK2012年總收入27.68億元2012年服務(wù)收入25.51億元2003-2012年服務(wù)收入CAGR52%員工總數(shù)*18,946核心價(jià)值觀：

奮斗為本，成就客戶，創(chuàng)造分享，共同成長(zhǎng)！*截止到2012年12月31日中軟國(guó)際概覽4外包服務(wù)覆蓋銷售和提交中心政府21個(gè)中國(guó)城市I深厚的行業(yè)積累：藍(lán)籌客戶4320個(gè)中國(guó)政府部委級(jí)機(jī)構(gòu)6個(gè)“十二金”工程100%覆蓋5大中國(guó)國(guó)有銀行12個(gè)20強(qiáng)全球銀行2個(gè)3強(qiáng)中國(guó)保險(xiǎn)公司7個(gè)GDP10強(qiáng)城市5個(gè)國(guó)內(nèi)能源巨頭政府制造與流通金融與銀行交通電信能源100%覆蓋100強(qiáng)中國(guó)卷煙品牌2個(gè)

3強(qiáng)中國(guó)自主汽車品牌4個(gè)5強(qiáng)中國(guó)機(jī)械制造企業(yè)5個(gè)10強(qiáng)中國(guó)鋼鐵企業(yè)“金審”“金質(zhì)”“金?！薄敖疝r(nóng)”“金宏”“金卡”100%覆蓋前3強(qiáng)中國(guó)電信運(yùn)營(yíng)商2個(gè)前3強(qiáng)全球電信設(shè)備供應(yīng)商上海北京深圳天津重慶杭州青島高科技產(chǎn)業(yè)4個(gè)5強(qiáng)全球軟件公司深厚的行業(yè)積累：藍(lán)籌客戶520個(gè)中國(guó)政府部委級(jí)機(jī)構(gòu)100%AgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMProjectPlanandImplementation44AgendaCTOMDMObjectivesandRObjectivesBuildmasterdatahubinsteadofPeertoPeermasterdataintegration.CreatesingleandtrustiestMarketing&Salesdataview.EnhancemasterdatacollaborationfoundationImprovedatacollaborationviewtosupportdatagovernanceECCCRMIPCLOISMDME-ComPRMB2BVendavo......ModelingECCCRMIPCLOISJDAMDMMasterData|TransactionDataVendavoPRM……ObjectivesBuildmasterdatahuOneMasterDataPlatformTrustMechanismIntegrated360?DataViewCollaborationCapabilityAutomaticIntegrateBusinessDataIntoMDMHubAutomaticDeliverDatatoDownstreamSystemsInteractiveUIforBusinessUser……SupportDataGovernanceStrategyRequirementsOneMasterDataPlatformRequirECCCRMIPCLOISMDME-ComPlatformPRMB2BVendavo......ModelingBPPrice&CostProduct&BOMCTOProductAttributeTransactionDataDataCalculationRawDataEnrichedDataDataConsolidationDataCleansingDataQualityDataReport&QualityReport2341TasksforPhaseIECCCRMIPCLOISE-ComPlatformPRMAgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMSolutionArchitectureSolutionFunctionsSolutionImplementationArchitectureSolutionAdvantageProjectPlanandImplementationInformaticaMDMCaseStudies48AgendaCTOMDMObjectivesandRMDMHubSolutionArchitectureMDMCTOModelingUI(Search,Configuration,Reports,Workflow)ECCCRMVendavoPlanningWindchillLOISIPCCRMLPOSLEOSB2CSFDC…etcMDMFoundationDataProcessingMasterDataStaging-inDataStaging-outDataDataInputDataOutputServicesWorkflowSolutionArchitectureMDMCTOMoCTOMDMFunctionMatrix7majorCriteriaInputdatafromupstreamsystems,andloadintostaging-indatastoreModelingCTOdatabyGEO/countryProcessingdatafromstaging-indatatoCTOmodelUI

forCTOdatareview,configuration,approvalReportCTOdatastatisticsintabularorchartWorkflowmanagementbasedonCTOapprovalOutputdatafromstaging-outdatastoretodownstreamsystems50CTOMDMFunctionMatrix7majorWebServicesMQSeriesJMSTIBCOwebMethodsSAPNetWeaverXIEncyryptedstreamPeoplesoftOracleAppsSiebelSAS…SAPNetWeaverSAPIDOCSAPBCISAPDMISAPBWOracleDB2UDBDB2/400SQLServerSybaseInformixTeradataODBCFlatFilesWebLogs…XMLIndustryFormatsFlatFilesFTPComplexFilesTapeFormats…ERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTapeFormats.PDF.DOC.XLSEmailCloudAppsEDIDIDeveloperDataInputECCCRMIPCLOISE-ComPlatformPRMB2BVendavo......Staging-inDataWebServicesPeoplesoftOracleXMWebServicesMQSeriesJMSTIBCOwebMethodsSAPNetWeaverXIEncyryptedstreamPeoplesoftOracleAppsSiebelSAS…SAPNetWeaverSAPIDOCSAPBCISAPDMISAPBWOracleDB2UDBDB2/400SQLServerSybaseInformixTeradataODBCFlatFilesWebLogs…XMLIndustryFormatsFlatFilesFTPComplexFilesTapeFormats…ERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTapeFormats.PDF.DOC.XLSEmailCloudAppsEDIDIDeveloperDataProcessingECCCRMIPCLOISE-ComPlatformPRMB2BVendavo......Staging-inDataMasterDataWebServicesPeoplesoftOracleXM9majorprocessesChar.SequenceCVVisibilityCTODefaultValueCTOCompatibilityCTOModelManagementFeatureManagementOptionManagementCustomModelQueryConfigurationSearchDataProcessingCorefunctions9majorprocessesDataProcessiDataProcessingbusinesslogictoprogramsDataProcessingbusinesslogicGUIdevelopmentandmanagementGUIdevelopmentandmanagementModeldesigntoolswithMDMspecialfunctionsOpendatamodelMetadatatrackingIndustryReferenceDataModelEasytoextendCTOModelinstoragelayer

FlexibleModeltoSupportCurrentandFutureBusinessCTOModelinstoragelayer

FleMasterDataModelDesign(example)CTOCategoryCTOCategoryCategoryNMCTO_C_1NPCTOCTO#CTOCategoryCTONameCTODescCTO_1CTO_C_1T430P

CTO_2CTO_C_1X220i

CTableC#CNMC_1KeyboardC_2HDDVTableV#C#VDescV_1_1C_1ENV_1_2C_1CNV_1_3C_1USV_2_1C_2500GBV_2_2C_21TBV_2_3C_2320GBCTOValueInstance#CTO#V#ChannelRegionHideI_1CTO_1V_1_1B2CUSNI_1CTO_1V_1_3B2CUSNI_1CTO_1V_2_2B2CUSYI_2CTO_1V_1_2B2CCNNI_2CTO_1V_2_3B2CCNNI_2CTO_1V_2_1B2CCNNI_3CTO_2V_1_2B2CCNNI_3CTO_2V_2_1B2CCNNI_3CTO_2V_2_3B2CCNYS

TableS#SNMS_1MiniMouseS_2ExtCameraS_31yearwarrantyCSTableC#S#CTO_1S_1CTO_1S_3CTO_2S_1MasterDataModelDesign(examDataasServicesConfigurableservicesframework(SOAenabled)aroundtheMDMHubplatformthatenablesreuseoftheunderlyinglogicAPIsforfine-grainedaccesstodataandobjectsintheHubPushbuttongenerationofdataservicesforuseinaWebServicesbasedintegrationSIFSDK,atoolkitforbuildingcoarse-grainedbusinessservicesDataasServicesConfigurablesODrulesasaservice:searchValidCVVariantTableSeqCVFlagNB_CRX2_ITL_TBL00001NB_SPI5_3427U_MB0NB_CRX2_ITL_TBL00001NB_WLANINTEL_CAN_6205S0NB_CRX2_ITL_TBL00001NB_WLANINTEL_CAN_6205S_BR0NB_CRX2_ITL_TBL00001NB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK059ODtableanddataCVValid_CValid_VFlagNB_SPI5_3427U_MBNB_WLANINTEL_CAN_6205S0NB_SPI5_3427U_MBNB_WLANINTEL_CAN_6205S_BR0NB_SPI5_3427U_MBNB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK0NB_WLANINTEL_CAN_6205SNB_SPI5_3427U_MB0NB_WLANINTEL_CAN_6205SNB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK0ODruledatasearchValidCVInput:<C>NB_SP</C><V>I5_3427U_MB</V>Output:<validC>NB_WLAN</validC><validV>INTEL_CAN_6205S</validV><validC>NB_WLAN</validC><validV>INTEL_CAN_6205S_BR</validV><validC>NB_INTEL_LABEL</validC><validV>2GEN_CORE_I5_VPRO_BLACK</validV>ODrulesasaservice:searchV60UIDevelopmentPlatformUIDevelopmentPlatformBizFramework:UIComponents,ServiceSupportingComponents,SampleApp.,CodeTemplate,BestPractice(Lib)ComponentFramework:ComponentLife-CycleMgt.,4A(AccessControl,Authorization,Authentication,Audit),SSOServiceFramework/ResourceMgt.Integration|AdaptorFramework/ESBWorkflowComponentFormComponentIntelligentAnalyticComponentOrg.&UserMgt.Roles&PermissionMgt.OtherComponentsBizFoundationCTOApplication(ConfigurationandModeling,…)B2BB2CSourceDataCTODataMDMDataECCCRMIPCLOIS......B2C......……B2BDataServiceMDM22UIDevelopmentPlatformUIDeUIbasedonservicestomanageCTO61UIbasedonservicestomanageUI–Reportandworkflow1)Workflow-drivenTaskInboxforInserts,Updates,andMatches2)Drill-downnavigationtoMasterDataRecord4)TaskPriorities5)Visualizationofreport3)TaskDetailsUI–Reportandworkflow1)WorExitTask1StartTask2CTOUserTask3MDMCTOManagerDataStewardDatadeliverInformaticaMDMhasembededworkflowCanbeintegratedbyapplications：Inquiry/modifytaskstatusQuery/UpdatedatabyWSWorkflowengineExitTask1StartTask2CTOUserTDataOutputExportapproveddatatodownstreamsystembasedonscheduleandrules64DataOutputExportapproveddatSecurityAccessManager(SAM)SecurityAccessManager(SAM)isMDMHub’scomprehensivesecurityframeworkAresourceisconfiguredtobesecureEachsecureresourceisconfiguredwithspecificprivilegesArolecanhaveaccesstooneormoresecureresources.AuserisassignedoneormorerolesSecurityAccessManager(SAM)SScalability66PartitionGridHadoopScalability28PartitionGridHadoClusterDeploymentNonDistributedHighAvailabilitySupportscontinuousopswithsinglefailureDoesnotfullyhandlenetworkorphysicalhardwarefailuresRecommendedArchitectureRedundantEnterpriseClassLoadBalancersApplicationServerFarmorthefullJ2EEclusterRedundantnetworkconnectionsandothernetworkinfrastructureOracleRACorVeritasDBclusterSANstoragewithredundantconnectionstoDBServerNetworkLBandFailoverWebAppCompositeServicesDBCluster(E.g.RAC)AppCluster-Infrastructure-ApplicationStackComponentsHubServicesHubServerHubORS-MDMHubClusterDeploymentNonDistribuLBandFailoverInfrastructureWebAppDisasterRecoveryDeploymentCompositeServicesDBReplicationDBCluster(E.g.RAC)AppClusterActive(A)-Infrastructure-ApplicationStackComponentsHubServicesHubServerHubORS-MDMHubDBCluster(E.g.RAC)AppClusterPassive(B)DistributedHighAvailabilitySupportscontinuousopswithsinglefailureHandlesnetworkorphysicalhardwarefailuresRecommendedArchitectureRedundantLoadBalancersGeographicallyDistributedHubs(HOT/HOTorHOT/WARMconfiguration)ApplicationServerFarmRedundantnetworkconnectionsOracleRACSANstoragewithredundantconnectionstoDBServerDBlogbasedreplicationbetweenenvironmentsLBandFailoverWebAppDisasterSolutionAdvantageTotalsolutionwithfasttimetovaluePhasebyphaseapproachStartsmall,extendtomorewithinuniqueplatformConfigurableplatformwithefficiency,scalabilityandextensibilityFlexibledatamodelingConfigurerulebyGUIScalablesystemarchitectureExtensiblefunctionsEasetointegratewith