SAP_如何将SAP内存计算应用(SAPHANA)集成到你的系统布

MattKangas/CSAAmericasHongGunCho/CSATechnologyDennisSchwerer/CSATechnologySeptember,2011TEC104如何将SAP内存计算应用(SAPHANA)集成到你的系统布局中©2011SAPAG.Allrightsreserved.2DisclaimerThispresentationoutlinesourgeneralproductdirectionandshouldnotbereliedoninmakingapurchasedecision.ThispresentationisnotsubjecttoyourlicenseagreementoranyotheragreementwithSAP.SAPhasnoobligationtopursueanycourseofbusinessoutlinedinthispresentationortodeveloporreleaseanyfunctionalitymentionedinthispresentation.ThispresentationandSAP'sstrategyandpossiblefuturedevelopmentsaresubjecttochangeandmaybechangedbySAPatanytimeforanyreasonwithoutnotice.Thisdocumentisprovidedwithoutawarrantyofanykind,eitherexpressorimplied,includingbutnotlimitedto,theimpliedwarrantiesofmerchantability,fitnessforaparticularpurpose,ornon-infringement.SAPassumesnoresponsibilityforerrorsoromissionsinthisdocument,exceptifsuchdamageswerecausedbySAPintentionallyorgrosslynegligent.©2011SAPAG.Allrightsreserved.3日程什么是SAPHANA?SAPHANA–体系结构与系统环境概览数据抽取数据加载的选项使用SLT进行数据抽取系统扩展规模选型SAPHANA系统环境简化推荐使用的方法什么是SAPHANA?©2011SAPAG.Allrightsreserved.5什么是SAPHANA?硬件技术的创新当前服务器中的64bit地址空间–2TB100GB/s的数据吞吐量价格剧烈下降，性能飞速上升多核体系结构(每台刀片服务器8x8核CPU)使用多个刀片服务器进行批量并行扩展1台刀片服务器约$50,000=1台企业级服务器行存储与列存储数据压缩数据分割无汇总表只对增量数据进行插入SAP软件技术的创新更加便宜的硬件与技术创新相结合，使SAP有能力在具有内存计算业务应用的实时企业环境规划下发布产品©2011SAPAG.Allrightsreserved.6维护运营什么是SAPHANA?SAPHANA–预打包的解决方案，以预安装和定义的形式向客户发布–内嵌工具，管理生命周期、安全优化与日常运营–为持续运营提供其必需的任务、概念与过程的最佳实践体系结构与系统环境安装升级，打补丁管理监控备份与恢复©2011SAPAG.Allrightsreserved.7SAPHANA将软件与硬件结合起来内存计算引擎（软件）预先安装好的系统（硬件）+©2011SAPAG.Allrightsreserved.8SAPHANA–“Appliance”的含义Appliance生命周期管理与运营的概念作为预安装的虚拟机镜像发布作为软件Appliance安装作为预安装好的硬件Appliance接收时间价值（便于安装）降低总拥有成本（便于维护）©2011SAPAG.Allrightsreserved.9SAPHANA-“Appliance”的含义传统软件发布方式：on-premise解决方案SAP仅提供软件客户负责管理整个产品生命周期Appliance的发布一种“SaaS式的正规客户”SAP定义整体解决方案SAP与合作伙伴管理产品生命周期Appliance运营概念基础设施*运营*安装/咨询支持（软件、维护、基础设施）SAP软件开发软件与许可证硬件与技术合作伙伴SAP托管与云计算的发布基础设施运营安装/咨询支持（软件、维护、基础设施）SAP软件开发软件与许可证*可以外包或由客户所拥有SAP的职责客户的职责合作伙伴的职责SAPHANA-体系结构与系统环境概览©2011SAPAG.Allrightsreserved.11体系结构概览SAPHANAAppliance与周边环境SAPHANAApplianceERP日志ERP数据库ClientsBI4ExplorerDashboard设计SAPBI4universes(WebI,...)MSExcelBI4AnalysisSAPHANA数据库处理请求/执行控制SQLParserMDXSQLScriptCalcEngineTransactionManager会话管理RelationalEnginesRowStoreColumnStorePersistenceLayerPageManagementLogger磁盘存储LogVolumesDataVolumesAuthorizationManagerMetadataManagerSAPHANAStudio管理建模LoadControllerReplicationAgentReplicationServerSAPBusinessObjectsBI4DataServicesDesignerSBOBI4servers(programforclient)SBOBI4InformationDesignTool其他数据源SAPNetWeaverBW第三方系统DataServicesSLTAdd-on©2011SAPAG.Allrightsreserved.12SAPHostAgentSybaseReplicationServerSAPHANAstudioSAPHANAapplianceSAPHANALoadControllerSAPHANA构件体系结构SAPHANA1.0SPS02–SAPHANAdatabase–SAPHANAdatabaseclients–SAPHANAstudio(P2repository)–SybaseReplicationServer–SAPHANALoadController–SAPHostAgent–LMStructurefiles–SAPCAR–OSconfiguration&usersSLToolset1.0SPS02–SoftwareUpdateManagerforSAPHANA–SAPJVMLMStructurefilesSAPHANAdatabaseclientsSAPCARSAPHANAdatabaseSLES11SP1硬件厂商特定的服务器管理工具存储子系统SAPSWUpdateManager(SUM)forSAPHANASLToolset1.0SAPJVM从部署的角度看TheSAPHANAappliance软件经过适当定义与验证的硬件和软件库©2011SAPAG.Allrightsreserved.13数据源AdminWorkstations•SAPHANAstudio•SAPHANAdatabaseclients•DataServicesDesigner•InformationDesigner•MSExcel2010•WebaccesstoBIadmintoolsEndusersWorkstations•MSExcel2010•SAPHANAdatabaseclients1.0•WebaccesstoBIclientsSAPHANAappliance(SLES11SP1)•SAPHANAdatabase,-clients,studio•SAPHANALoadController•SAPHostAgent7.20•SybaseReplicationServer15.5+ECDADataServices•DataServices4.0•DataServicesJobServer•Repository(sharedwithBOE)BOE•BIPlatform•WebAppserver•RepositorySAPERPSystem••SAPERP•SAPHostAgent7.20•SybaseReplicationAgent(HPUNIX,SLES,AIX)SAPBWSystemNon–SAPSystemSAPHANA系统环境LTSystem••NW7.02•Add-onDMIS2010_1_700©2011SAPAG.Allrightsreserved.14DBServerSAPHANA1.0SAPHANAJDBCODBCODBOSQLDBCSAPIn-MemoryDatabaseReplicationServerSAPHANAStudioSAPBusinessApplicationReplicationAgentSAPBusinessObjectsDataServices4.0任意数据源SAPBusinessObjectsBI4.0RepositorySAPBusinessObjectsBIclientsSQLMDXBICSAuthenticationContentmgmtsync管理与模型控制load(可选的)(可选的)(可选的)(现存系统)StudioSLT数据抽取数据加载的可选方案©2011SAPAG.Allrightsreserved.16SAPHANA数据复制技术©2011SAPAG.Allrightsreserved.17加载数据的可选方式LoadController&SybaseReplicationServer(基于数据库日志的复制)SAPLTReplication(基于触发器的复制)DataServices4.0(基于ETL的复制)R3load(非正式–用于概念验证)1.主安装中，为全面导出数据而进行的系统复制PythonimportManager.py&exportManager.py1.从SAPHANA导出2.向SAPHANA导入SQL语句:1.使用SQL语句创建MARA表(难以手工完成)2.LOADfrom'/server/HANA/HN1_COPA_TABLES/MARA.ctl‘THREADS4BATCH100;©2011SAPAG.Allrightsreserved.18从SAPERP表向SAPHANA复制参考SAPnote#1513496以获取关于这些限制的最新信息数据库技术可用性及其认证LogFileReplicationSLTReplicationDataServices4.0MSFTSQLServerEnterpriseEditionPlannedtbdOKOKPlannedtbdOKOKOracleEnterpriseEditionPlannedtbdOKOKPlannedtbdOKOKIBMDB2LUW/UDBOKOKOKOKOKOKIBMDB/2zSeriesNotPlannedOKOKNotPlannedOKOKIBMDB2iSeries(formerAS/400)NotPlannedOKOKIBMInformixNotPlannedOKOKNotPlannedOKOKSAPMaxDBNotPlannedOKOKNotPlannedOKOKSybaseASEPlannedtbdOKOKPlannedtbdOKOK许可证限制仍可能存在©2011SAPAG.Allrightsreserved.19支持能力矩阵参考SAPNote15134