《Informatica-数据仓库解决方案-v1.1》由会员分享，可在线阅读，更多相关《Informatica-数据仓库解决方案-v1.1（38页珍藏版）》请在金锄头文库上搜索。
1、CTO MDM solutionfor LenovoDan BinInformatica CInformatica专专注于企注于企业业数据集成与管理数据集成与管理成立时间成立时间: : 19932012年收入为年收入为: : 8.116亿美元亿美元7年平均增长率年平均增长率: :每年每年17% %员工人数员工人数: : 3,000多人多人合作伙伴合作伙伴: : 450多家多家主要的系统集成商、独立软件供应商、原始设备制造商和按需生产的先驱客户客户: : 超过超过5,000家家客户遍布全球82个国家直接客户遍布全球28个国家客户忠诚度排名位居榜首 （已连续7年获此殊荣）2005200620072
2、0082009201020112012$900$800$700$600$500$400$300$200$100$0企企业内部内部如果我如果我们给客客户20%的折扣，的折扣，营收将会受收将会受到到多大多大影响？影响？最佳追加最佳追加销售和交叉售和交叉销售售组合？合？根据天气和数据制定的最佳根据天气和数据制定的最佳行行车路路线？根根据客据客户喜好制定的最佳喜好制定的最佳产品品方案？方案？哪哪个个账户风险最高？最高？风险最大的最大的客客户？云云SaaS虚虚拟化化大数据大数据社交社交物物联网网对业务灵活性的持灵活性的持续需求需求数据大爆炸数据大爆炸: 复复杂度、成本和度、成本和风险IT业务信息平台可可
3、执行行权威威安全安全实时 可信可信全全面面3Informatica 价价值值定位定位提升数据价值、降低IT成本、达成业务使命多域关多域关联 客客户/合作伙伴合作伙伴 订单 供供应商商 产品品中中软软国国际际概概览览4外包服务覆盖销售和提交中心n政府n制造与流通业n金融行业n高科技业n电信行业n保险行业n能源行业n公共事业n21个中国城市n美国n英国n日本nIT咨询服务nIT技术服务nIT外包服务nIT实训服务目录覆盖行业全球分布n公司注册资金：1,0200万元n总 部北京、香港n股票代码0354.HKn2012年总收入27.68亿元n2012年服务收入25.51亿元n2003-2012年 服务
4、收入CAGR52%n员工总数*18,946n核心价值观：奋斗为本，成就客户，创造分享，共同成长！*截止到2012年12月31日深厚的行深厚的行业积业积累：累：蓝蓝筹客筹客户户520个个中国政府部委级机构6个个“十二金”工程100%覆盖5大中国国有银行12个个20强全球银行2个个3强中国保险公司7个个GDP10强城市5个个国内能源巨头政府政府制造与流通制造与流通金融与金融与银行行交通交通电信信能源能源100%覆盖100强中国卷烟品牌2个个3强中国自主汽车品牌4个个5强中国机械制造企业5个个10强中国钢铁企业“金审”“金质”“金保”“金农”“金宏”“金卡”100%覆盖前3强中国电信运营商2个个前3
5、强全球电信设备供应商上海北京深圳天津重庆杭州青岛高科技高科技产业4个个5强全球软件公司AgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMProjectPlanandImplementation6Objectives1.BuildmasterdatahubinsteadofPeertoPeermasterdataintegration.2.CreatesingleandtrustiestMarketing&Salesdataview.3.Enhancemasterdatacollaborationfoundation
6、4.ImprovedatacollaborationviewtosupportdatagovernanceECCCRMIPCLOISMDME-ComPRMB2BVendavo.ModelingECCCRMIPCLOISJDAMDMMasterData|TransactionDataVendavoPRMOneMasterDataPlatformTrustMechanismIntegrated360DataViewCollaborationCapabilityAutomaticIntegrateBusinessDataIntoMDMHubAutomaticDeliverDatatoDownstre
7、amSystemsInteractiveUIforBusinessUserSupportDataGovernanceStrategyRequirementsECCCRMIPCLOISMDME-ComPlatformPRMB2BVendavo.ModelingBPPrice&CostProduct&BOMCTOProductAttributeTransactionDataDataCalculationRaw DataEnriched DataDataConsolidationDataCleansingData QualityDataReport&QualityReport2341Tasks fo
8、r Phase IAgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMSolutionArchitectureSolutionFunctionsSolutionImplementationArchitectureSolutionAdvantageProjectPlanandImplementationInformaticaMDMCaseStudies10MDMHubSolution ArchitectureMDMCTOModelingUI(Search,Configuration,Reports,Workflow)E
9、CCCRMVendavoPlanningWindchillLOISIPCCRMLPOSLEOSB2CSFDCetcMDMFoundationDataProcessingMasterDataStaging-inDataStaging-outDataDataInputDataOutputServicesWorkflowCTO MDM Function Matrix7majorCriteria1.Inputdatafromupstreamsystems,andloadintostaging-indatastore2.ModelingCTOdatabyGEO/country3.Processingda
10、tafromstaging-indatatoCTOmodel4.UIforCTOdatareview,configuration,approval5.Report CTOdatastatisticsintabularorchart6.Workflow managementbasedonCTOapproval7.Outputdatafromstaging-outdatastoretodownstreamsystems12Web ServicesMQSeriesJMSTIBCO webMethodsSAP NetWeaver XIEncyrypted streamPeoplesoftOracle
11、AppsSiebelSASSAP NetWeaverSAP IDOCSAP BCISAP DMISAP BWOracleDB2 UDBDB2/400SQL ServerSybaseInformixTeradataODBCFlat FilesWeb Logs XMLIndustry FormatsFlat FilesFTPComplex FilesTape FormatsERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTape Formats.PDF.DOC.XLS
12、EmailCloud AppsEDIDI DeveloperData InputECCCRMIPCLOISE-ComPlatformPRMB2BVendavo.Staging-inDataWeb ServicesMQSeriesJMSTIBCO webMethodsSAP NetWeaver XIEncyrypted streamPeoplesoftOracle AppsSiebelSASSAP NetWeaverSAP IDOCSAP BCISAP DMISAP BWOracleDB2 UDBDB2/400SQL ServerSybaseInformixTeradataODBCFlat Fi
13、lesWeb Logs XMLIndustry FormatsFlat FilesFTPComplex FilesTape FormatsERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTape Formats.PDF.DOC.XLSEmailCloud AppsEDIDI DeveloperData ProcessingECCCRMIPCLOISE-ComPlatformPRMB2BVendavo.Staging-inDataMasterData9majorpr
14、ocessesChar.SequenceCVVisibilityCTODefaultValueCTOCompatibilityCTOModelManagementFeatureManagementOptionManagementCustomModelQueryConfigurationSearchData Processing Core functionsData Processing business logic to programsGUI development and managementModeldesigntoolswithMDMspecialfunctionsOpendatamo
15、delMetadatatrackingIndustryReferenceDataModelEasytoextendCTO Model in storage layerFlexible Model to Support Current and Future Business Master Data Model Design (example)CTO CategoryCTO CategoryCategory NMCTO_C_1NPCTOCTO#CTO Category CTO Name CTO DescCTO_1CTO_C_1T430PCTO_2CTO_C_1X220iC TableC#C NMC
16、_1KeyboardC_2HDDV TableV#C#V DescV_1_1C_1ENV_1_2C_1CNV_1_3C_1USV_2_1C_2500GBV_2_2C_21TBV_2_3C_2320GBCTO ValueInstance#CTO#V#ChannelRegion HideI_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
17、_2V_2_3B2CCNYS TableS#S NMS_1MiniMouseS_2ExtCameraS_31 year warrantyCS TableC#S#CTO_1S_1CTO_1S_3CTO_2S_1Data as ServicesConfigurable services framework (SOA enabled) around the MDM Hub platform that enables reuse of the underlying logicAPIsforfine-grainedaccesstodataandobjectsintheHubPushbuttongener
18、ationofdataservicesforuseinaWebServicesbasedintegrationSIFSDK,atoolkitforbuildingcoarse-grainedbusinessservicesOD rules as a service: searchValidCVVariantTableSeqCVFlagNB_CRX2_ITL_TBL 00001NB_SPI5_3427U_MB0NB_CRX2_ITL_TBL 00001NB_WLANINTEL_CAN_6205S0NB_CRX2_ITL_TBL 00001NB_WLANINTEL_CAN_6205S_BR0NB_
19、CRX2_ITL_TBL 00001NB_INTEL_LABEL 2GEN_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_BLACK 0NB_WLAN INTEL_CAN_6205S NB_SPI5_3427U_MB0NB_WLAN INTEL_CAN_6205S NB_INT
20、EL_LABEL2GEN_CORE_I5_VPRO_BLACK 0ODruledatasearchValidCVInput:NB_SPI5_3427U_MBOutput:NB_WLANINTEL_CAN_6205SNB_WLANINTEL_CAN_6205S_BRNB_INTEL_LABEL2GEN_CORE_I5_VPRO_BLACK22UI Development PlatformUI Development Platform Biz Framework:Biz Framework:UI Components, Service Supporting Components , Sample
21、App.,UI Components, Service Supporting Components , Sample App., Code Template , Best Practice (Lib) Code Template , Best Practice (Lib)Component Framework:Component Framework:ComponentLife-CycleMgt.,ComponentLife-CycleMgt.,4A(AccessControl,4A(AccessControl,Authorization,Authentication,Authorization
22、,Authentication,Audit),SSOAudit),SSOService FrameworkService Framework/Resource Mgt/Resource Mgt. .Integration | Adaptor Framework /ESBIntegration | Adaptor Framework /ESBWorkflowWorkflowComponentComponentFormFormComponentComponentIntelligentAnalyticIntelligentAnalyticComponentComponentOrg.&UserOrg.
23、&UserMgtMgt. .Roles&PermissionMgt.Roles&PermissionMgt.OtherComponentsOtherComponentsBizFoundationCTO Application(Configuration and Modeling, CTO Application(Configuration and Modeling, ) )B2BB2BB2CB2CSource DataSource DataCTO DataCTO DataMDM DataMDM DataECCCRMIPCLOIS.B2C.B2BData ServiceData ServiceM
24、DMMDMUI based on services to manage CTO23UI Report and workflow1) Workflow-driven Task Inbox for Inserts, Updates, and Matches2)Drill-downnavigationtoMasterDataRecord4)TaskPriorities5)Visualizationofreport3)TaskDetailsCTOUserMDMCTOManagerDataStewardDatadeliverInformaticaMDMhasembededworkflowCanbeint
25、egratedbyapplications：Inquiry/modifytaskstatusQuery/UpdatedatabyWSWorkflow engineData OutputExportapproveddatatodownstreamsystembasedonscheduleandrules26Security Access Manager (SAM)SecurityAccessManager(SAM)isMDMHubscomprehensivesecurityframeworkAresourceisconfiguredtobesecureEachsecureresourceisco
26、nfiguredwithspecificprivilegesArolecanhaveaccesstooneormoresecureresources.AuserisassignedoneormorerolesScalability28PartitionGridHadoopCluster DeploymentNon Distributed High AvailabilitySupportscontinuousopswithsinglefailureDoesnotfullyhandlenetworkorphysicalhardwarefailuresRecommended Architecture
27、RedundantEnterpriseClassLoadBalancersApplicationServerFarmorthefullJ2EEclusterRedundantnetworkconnectionsandothernetworkinfrastructureOracleRACorVeritasDBclusterSANstoragewithredundantconnectionstoDBServerNetwork LB and FailoverWeb AppComposite ServicesDBCluster (E.g. RAC)App Cluster- Infrastructure
28、 - Application Stack ComponentsHub ServicesHub ServerHub ORS- MDM HubLB and FailoverInfrastructureWeb AppDisaster Recovery DeploymentComposite ServicesDB ReplicationDBCluster (E.g. RAC)AppClusterActive (A)- Infrastructure - Application Stack ComponentsHub ServicesHub ServerHub ORS- MDM HubDBCluster
29、(E.g. RAC)AppClusterPassive (B)Distributed High AvailabilitySupportscontinuousopswithsinglefailureHandlesnetworkorphysicalhardwarefailuresRecommended ArchitectureRedundantLoadBalancersGeographicallyDistributedHubs(HOT/HOTorHOT/WARMconfiguration)ApplicationServerFarmRedundantnetworkconnectionsOracleR
30、ACSANstoragewithredundantconnectionstoDBServerDBlogbasedreplicationbetweenenvironmentsSolution AdvantageTotalsolutionwithfasttimetovaluePhasebyphaseapproachStartsmall,extendtomorewithinuniqueplatformConfigurableplatformwithefficiency,scalabilityandextensibilityFlexibledatamodelingConfigurerulebyGUIS
31、calablesystemarchitectureExtensiblefunctionsEasetointegratewithupstream/downstreamsystemswithopenplatformUnique configurable platform deduct extra costs, decrease TCO31AgendaCTOMDMObjectivesandRequirementsInformaticaSolutionforCTOMDMProjectPlanandImplementation32Velocity Core MethodologyVelocity is
32、the blueprint for delivering efficient and successful Informatica solutions that solve business problems.Velocity Core MethodologyPhases, Tasks, SubtasksBest PracticesRolesTemplates & AcceleratorsSample DeliverablesAvailable at Velocity MDM Implementation Overview ManageAnalyzeArchitect & DesignBui
33、ld &TestDeploy & OperateActivitiesDefineVisionandScopePlanProjectManageProjectActivitiesGatherHigh-LevelRequirementsPerformDataAssessmentDefinePreliminarySolutionArchitectureSpecifyDetailedRequirementsAnalyzeDataStewardshipActivitiesFinalizeSolutionArchitectureDesignPhysicalDataModelDesignTechnicalS
34、olutionDesignBusinessRulesDesignPoliciesandProceduresActivitiesSetupDev.EnvironmentBuildMDMHubBuildHierarchiesTunetheRulesBuildInterfacesBuildReportsPlanandPrepareTestPerformSystemTestingPerformVolume/PerformanceTestingPerformUserAcceptanceTestingActivitiesSetupProd.EnvironmentPreparetoDeployRollout
35、SolutionDeliverablesVisionandScopeProjectPlanProjectRiskAssessmentandMitigationPlanProjectRoleMatrixDeliverablesDataQualityAuditRequirementsSpecificationRequirementsTraceabilityMatrixDeliverablesTechnicalSolutionArchitectureMDMHubTechnicalDesignSpecificationUserInterfaceRequirementsandDesignSpecific
36、ationDeliverablesTestPlanandScriptsTestResultsandApprovalsTestReportDocumentedConfigurationConfiguredMDMHubDeliverablesProductionJobSchedulesApprovaltoDeployOperationsManualRunBookMajorMilestoneChartCheckpointReviewsProjectStatusReportsDeliverableAcceptanceEndofProjectReportSOW and resource plan for
37、 phase one (B2B)35Lenovo CTO Modeling SOW：B2B（Phrase I）阶段计划周期(Weeks)备注1一、项目准备12二、系统规格定义23三、系统设计34四、配置和开发125五、系统集成测试36六、系统上线准备27七、系统优化调整2系统上线上线后支持系统优化配置系统优化测试SOW and resource plan for phase two (B2C)36Lenovo CTO Modeling SOW：B2C（Phrase II）阶段计划周期(Weeks)备注1一、项目准备12二、系统规格定义23三、系统设计4四、配置和开发5五、系统集成测试36六、系统上线准备27七、系统优化调整2系统上线上线后支持系统优化配置系统优化测试Q&A谢谢！2013Informatica.ProprietaryandConfidential38
