Informatica数据仓库解决方案v11

[e-mail]专注于企业数据集成与管理•成立时间:1993•2012年收入为:8.116亿美元•7年平均增长率:每年17%•员工人数:3,000多人•合作伙伴:450多家•主要的系统集成商、独立软件供应商、原始设备制造商和按需生产的先驱•客户:超过5,000家•客户遍布全球82个国家•直接客户遍布全球28个国家•客户忠诚度排名位居榜首（已连续7年获此殊荣）$0$100$200$300$400$500$600$700$800$90020052006200720082009201020112012企业内部如果我们给客户20%的折扣，营收将会受到多大影响？最佳追加销售和交叉销售组合？根据天气和数据制定的最佳行车路线？根据客户喜好制定的最佳产品方案？哪个账户风险最高？风险最大的客户？云SaaS虚拟化大数据社交物联网对业务灵活性的持续需求数据大爆炸:复杂度、成本和风险IT业务信息平台可执行权威安全实时可信全面3Informatica价值定位提升数据价值、降低IT成本、达成业务使命多域关联客户/合作伙伴订单供应商产品中软国际概览4外包服务覆盖销售和提交中心政府制造与流通业金融行业高科技业电信行业保险行业能源行业公共事业21个中国城市美国英国日本IT咨询服务IT技术服务IT外包服务IT实训服务目录覆盖行业全球分布公司注册资金：1,0200万元总部北京、香港股票代码0354.HK2012年总收入27.68亿元2012年服务收入25.51亿元2003-2012年服务收入CAGR52%员工总数*18,946核心价值观：奋斗为本，成就客户，创造分享，共同成长！*截止到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强全球电信设备供应商•上海•北京•深圳•天津•重庆•杭州•青岛高科技产业4个5强全球软件公司Agenda•CTOMDMObjectivesandRequirements•InformaticaSolutionforCTOMDM•ProjectPlanandImplementation6Objectives1.BuildmasterdatahubinsteadofPeertoPeermasterdataintegration.2.CreatesingleandtrustiestMarketing&Salesdataview.3.Enhancemasterdatacollaborationfoundation4.ImprovedatacollaborationviewtosupportdatagovernanceECCCRMIPCLOISMDME-ComPRMB2BVendavo......ModelingECCCRMIPCLOISJDAMDMMasterData|TransactionDataVendavoPRM……•OneMasterDataPlatform•TrustMechanism•Integrated360˚DataView•CollaborationCapability•AutomaticIntegrateBusinessDataIntoMDMHub•AutomaticDeliverDatatoDownstreamSystems•InteractiveUIforBusinessUser•……•SupportDataGovernanceStrategyRequirementsECCCRMIPCLOISMDME-ComPlatformPRMB2BVendavo......ModelingBPPrice&CostProduct&BOMCTOProductAttributeTransactionDataDataCalculationRawDataEnrichedDataDataConsolidationDataCleansingDataQualityDataReport&QualityReport2341TasksforPhaseIAgenda•CTOMDMObjectivesandRequirements•InformaticaSolutionforCTOMDM•SolutionArchitecture•SolutionFunctions•SolutionImplementationArchitecture•SolutionAdvantage•ProjectPlanandImplementation•InformaticaMDMCaseStudies10MDMHubSolutionArchitectureMDMCTOModelingUI(Search,Configuration,Reports,Workflow)ECCCRMVendavoPlanningWindchillLOISIPCCRMLPOSLEOSB2CSFDC…etcMDMFoundationDataProcessingMasterDataStaging-inDataStaging-outDataDataInputDataOutputServicesWorkflowCTOMDMFunctionMatrix•7majorCriteria1.Inputdatafromupstreamsystems,andloadintostaging-indatastore2.ModelingCTOdatabyGEO/country3.Processingdatafromstaging-indatatoCTOmodel4.UIforCTOdatareview,configuration,approval5.ReportCTOdatastatisticsintabularorchart6.WorkflowmanagementbasedonCTOapproval7.Outputdatafromstaging-outdatastoretodownstreamsystems12WebServicesMQSeriesJMSTIBCOwebMethodsSAPNetWeaverXIEncyryptedstreamPeoplesoftOracleAppsSiebelSAS…SAPNetWeaverSAPIDOCSAPBCISAPDMISAPBWOracleDB2UDBDB2/400SQLServerSybaseInformixTeradataODBCFlatFilesWebLogs…XMLIndustryFormatsFlatFilesFTPComplexFilesTapeFormats…ERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTapeFormats.PDF.DOC.XLSEmailCloudAppsEDIDIDeveloperDataInputECCCRMIPCLOISE-ComPlatformPRMB2BVendavo......Staging-inDataWebServicesMQSeriesJMSTIBCOwebMethodsSAPNetWeaverXIEncyryptedstreamPeoplesoftOracleAppsSiebelSAS…SAPNetWeaverSAPIDOCSAPBCISAPDMISAPBWOracleDB2UDBDB2/400SQLServerSybaseInformixTeradataODBCFlatFilesWebLogs…XMLIndustryFormatsFlatFilesFTPComplexFilesTapeFormats…ERPDatabasesXMLFlatfilesMainframeUnstructuredDataMessagesADABASDatacomDB2IDMSIMSVSAMC-ISAMTapeFormats.PDF.DOC.XLSEmailCloudAppsEDIDIDeveloperDataProcessingECCCRMIPCLOISE-ComPlatformPRMB2BVendavo......Staging-inDataMasterData•9majorprocesses•Char.Sequence•CVVisibility•CTODefaultValue•CTOCompatibility•CTOModelManagement•FeatureManagement•OptionManagement•CustomModelQuery•ConfigurationSearchDataProcessingCorefunctionsDataProcessingbusinesslogictoprogramsGUIdevelopmentandmanagement•ModeldesigntoolswithMDMspecialfunctions•Opendatamodel•Metadatatracking•IndustryReferenceDataModel•EasytoextendCTOModelinstoragelayerFlexibleModeltoSupportCurrentandFutureBusinessMasterDataModelDesign(example)CTOCategoryCTOCategoryCategoryNMCTO_C_1NPCTOCTO#CTOCategoryCTONameCTODescCTO_1CTO_C_1T430PCTO_2CTO_C_1X220iCTableC#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_3B2CCNYSTableS#SNMS_1MiniMouseS_2ExtCameraS_31yearwarrantyCSTableC#S#CTO_1S_1CTO_1S_3CTO_2S_1DataasServicesConfigurableservicesframework(SOAenabled)aroundtheMDMHubplatformthatenablesreuseoftheunderlyinglogic•APIsforfine-grainedaccesstodataandobjectsintheHub•PushbuttongenerationofdataservicesforuseinaWebServicesbasedintegration•SIFSDK,atoolkitforbuildingcoarse-grainedbusinessservicesODrulesasaservice:searchValidCVVariantTableSeqCVFlag