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

1、Matt Kangas/CSA AmericasHong Gun Cho/CSA TechnologyDennis Schwerer/CSA TechnologySeptember, 2021TEC104如何将SAP内存计算运用(SAP HANA)集成到他的系统规划中 DisclaimerThis presentation outlines our general product direction and should not be relied on in making a purchase decision. This presentation is not subject to you

2、r license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release any functionality mentioned in this presentation. This presentation and SAPs strategy and possible future developments are subject to cha

3、nge and may be changed by SAP at any time for any reason without notice. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no

4、 responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.日程什么是SAP HANA?SAP HANA 体系构造与系统环境概览数据抽取数据加载的选项运用SLT进展数据抽取系统扩展规模选型SAP HANA系统环境简化引荐运用的方法什么是SAP HANA?什么是SAP HANA?硬件技术的创新当前效力器中的64 bit地址空间 2 TB100 GB/s的数据吞吐量价钱猛烈下降，性能飞速上升

5、多核体系构造 (每台刀片效力器8 x 8核CPU)运用多个刀片效力器进展批量并行扩展1台刀片效力器约$50,000 = 1台企业级效力器行存储与列存储数据紧缩数据分割无汇总表只对增量数据进展插入SAP软件技术的创新更加廉价的硬件与技术创新相结合，使SAP有才干在具有内存计算业务运用的实时企业环境规划下发布产品什么是SAP HANA?SAP HANA预打包的处理方案，以预安装和定义的方式向客户发布内嵌工具，管理生命周期、平安优化与日常运营为继续运营提供其必需的义务、概念与过程的最正确实际SAP HANA 将软件与硬件结合起来内存计算引擎软件预先安装好的系统硬件+SAP HANA “Applian

6、ce的含义时间价值便于安装降低总拥有本钱便于维护SAP HANA - “Appliance的含义传统软件发布方式：on-premise处理方案SAP仅提供软件客户担任管理整个产品生命周期Appliance的发布一种“SaaS式的正规客户SAP定义整体处理方案SAP与协作同伴管理产品生命周期 Appliance运营概念根底设备*运营*安装/咨询支持软件、维护、根底设备SAP 软件开发软件与答应证硬件与技术协作同伴SAP托管与云计算的发布根底设备运营安装/咨询支持软件、维护、根底设备SAP软件开发软件与答应证* 可以外包或由客户所拥有SAP的职责客户的职责协作同伴的职责SAP HANA-体系构造与

7、系统环境概览体系构造概览SAP HANA Appliance与周边环境SAP HANA ApplianceERP日志ERP数据库ClientsBI4 ExplorerDashboard设计SAP BI4 universes (WebI,.)MS ExcelBI4 AnalysisSAP HANA数据库处置恳求/执行控制SQL ParserMDXSQL ScriptCalc EngineTransaction Manager会话管理Relational EnginesRow StoreColumn StorePersistence LayerPage ManagementLogger磁盘存储Lo

8、g VolumesData VolumesAuthorization ManagerMetadata ManagerSAP HANA Studio管理建模Load ControllerReplication AgentReplication ServerSAP Business Objects BI4Data Services DesignerSBO BI4 servers (program for client)SBO BI4 Information Design Tool其他数据源SAP NetWeaver BW第三方系统Data ServicesSLT Add-onSAPHost Age

9、ntSybase Replication Server SAP HANAstudioSAP HANA applianceSAP HANA Load ControllerSAP HANA构件体系构造SAP HANA 1.0 SPS 02SAP HANA databaseSAP HANA database clientsSAP HANA studio (P2 repository)Sybase Replication ServerSAP HANA Load ControllerSAP Host AgentLM Structure filesSAPCAROS configuration & user

10、sSL Toolset 1.0 SPS 02Software Update Manager for SAP HANASAP JVMLM Structure filesSAP HANAdatabase clientsSAPCARSAP HANAdatabaseSLES 11 SP1硬件厂商特定的效力器管理工具存储子系统SAP SW Update Manager (SUM) for SAP HANASL Toolset 1.0SAP JVM从部署的角度看The SAP HANA appliance软件经过适当定义与验证的硬件和软件库数据源Admin Workstations SAP HANA st

11、udio SAP HANA database clients Data Services Designer Information Designer MS Excel 2021 Web access to BI admin tools End users Workstations MS Excel 2021 SAP HANA database clients 1.0 Web access to BI clients SAP HANA appliance (SLES 11 SP1) SAP HANA database, - clients, studio SAP HANA Load Contro

12、ller SAP Host Agent 7.20 Sybase Replication Server 15.5 + ECDA Data Services Data Services 4.0 Data Services Job Server Repository (shared with BOE) BOE BI Platform WebApp server RepositorySAP ERP System SAP ERP SAP Host Agent 7.20 Sybase Replication Agent (HP UNIX, SLES, AIX) SAP BW SystemNon SAP S

13、ystemSAP HANA系统环境LT System NW7.02 Add-on DMIS 2021_1_700DB ServerSAP HANA 1.0SAP HANA JDBCODBCODBOSQL DBCSAP In-Memory DatabaseReplication ServerSAP HANA StudioSAP Business ApplicationReplication AgentSAP BusinessObjects Data Services 4.0恣意数据源SAP BusinessObjects BI 4.0RepositorySAP BusinessObjects B

14、I clientsSQLMDXBICSAuthenticationContent mgmtsync管理与模型控制load(可选的)(可选的)(可选的)(现存系统)StudioSLT数据抽取数据加载的可选方案SAP HANA数据复制技术加载数据的可选方式Load Controller & Sybase Replication Server (基于数据库日志的复制)SAP LT Replication (基于触发器的复制)Data Services 4.0 (基于ETL的复制)R3load (非正式 用于概念验证)主安装中，为全面导出数据而进展的系统复制Python importManager.p

15、y & exportManager.py从SAP HANA导出向SAP HANA导入SQL语句:运用SQL语句创建MARA表(难以手工完成)LOAD from /HANA/HN1_COPA_TABLES/MARA.ctl THREADS 4 BATCH 100; 从SAP ERP表向SAP HANA复制参考SAP note # 1513496 以获取关于这些限制的最新信息截至2021年7月的方案数据库技术可用性及其认证Log File ReplicationSLT ReplicationData Services 4.0MSFT SQL Server Enterprise EditionPla

16、nned tbdOKOKPlanned tbdOKOKOracle Enterprise EditionPlanned tbdOKOKPlanned tbdOKOKIBM DB2 LUW/ UDBOK OKOKOKOK OK IBM DB/2 zSeriesNot PlannedOKOKNot PlannedOK OK IBM DB2 iSeries (former AS/400)Not PlannedOK OK IBM InformixNot PlannedOKOKNot PlannedOK OK SAP MaxDBNot PlannedOK OK Not PlannedOKOKSybase

17、 ASEPlanned tbdOKOKPlanned tbdOKOK答应证限制仍能够存在支持才干矩阵 参考SAP Note 1513496来获取最新的正式发布的限制能力日志文件的复制SLT复制Data Services 4.0数据库表类型Minimum ERP VersionECC 6.0ERP 4.6cERP 4.6cUnicode/Non-UnicodeUnicode OnlyYesYesMDMPNoYesYesTransparent TablesYesYesYesCluster & Pool TablesNoYesYesNon-SAP ERP SourcesYesNoYesCompres

18、sed Values DB TableDB2 (9.1, 9.5, 9.7)YesYesRow Compression DB TableDB2 9.7 only (no support for 9.1 or 9.5)YesYesSAP ERP DB Support DB2 LUW/UDB Only*All DBs supported under ERPAll DBs supported under ERPSAP ERP OS SupportAIX, HP-UNIX, SUSE LINUX 10 & SUSE Linux 11, SPARC/Solaris, (see PAM for versi

19、on details)All OS supported under ERPAll OS supported under ERPMulti-Source SupportSingle Source SystemMultiple Source SystemsMultiple Source Systems抽取器Minimum ERP VersionN/AN/ASee SAP Note:1558737Unicode/Non-UnicodeYesMDMPPartial (Not recommended)Transparent TablesN/ACluster & Pool TablesN/ANon-SAP

20、 ERP SourcesN/ASAP ERP DB SupportAll DBs supported under ERPSAP ERP OS SupportAll OS supported under ERPMulti-Source SupportMultiple Source Systems数据抽取运用SLT进展数据抽取LT Replication的概念:基于触发器方式的体系构造与关键构件SAP HANA systemLT system (NW7.02)运用程序数据库表源系统Write ModulesControler Modules数据库衔接RFC衔接Read ModulesLogging

21、Tables运用程序数据库表DB Trigger高效率的数据初始复制，基于数据库触发器的和增量日志概念 接近零关机时间灵敏可靠的数据复制流程，包括数据迁移为TDMS和SAP LT所运用经过数据库衔接进展数据复制无其他交互LT replicator不用作为单独的SAP系统部署，可以运转在任何版本为7.02 ABAP stack (Kernel 7.20EXT) 的SAP NetWeaver 上LT Replicator 的技术要求和系统设置SAP HANA系统LT系统(NW7.02)源系统系统需求:- SAP Basis: Netweaver 702，Kernel 7.20EXT 目前有限的平台

22、可用性 - 文件系统：100 GB- RAM: 16-32 GB CPU: 2-4核数据库衔接RFC衔接系统需求 SAP Basis 4.6C或更高 一切数据库安装： 各DMIS 2021版本 最低支持包程度：最近可用安装： Add-on DMIS 2021_1_700 最低支持包程度： SP04 (与SAP HANA 1.0 GA同步发布)* I安装： SAP HANA SPS02：包括LT复制功能完选集成到HANA Modeler的用户界面根本配置： 定义到源系统的RFC衔接- 定义到HANA系统的数据库衔接- 定义数据复制所需的最大作业数根本配置： 可选：为日志表定义分别的表空间 为RF

23、C用户定义适当的授权根本配置：- 创建数据库用户假设需求LT replicator的实例可以运转在恣意SAP NetWeaver 7.02 ABAP 系统运用SAP Kernel 7.20EXT上，例如Solution Manager 7.1，源系统甚至HANA效力器需求安装SAP NetWeaver 7.02 ABAP Stack作为 LT Replicator的根底-它不用是一个独立的SAP系统！系统扩展分布式系统运用共享文件系统的多节点，以进展负载分配SAP HANA分布式系统源系统SAP HANA数据库存储系统节点4 节点1节点2 节点3 高可用性特点情境单一数据中心失效由于火灾，断电

24、，地震等单一节点失效硬件缺点概念冗余数据中心包括冗余SAP HANA系统-热待命同步镜像单一SAP HABA数据库系统环境内的待命系统-冷待命失效恢复被自动触发2个独立的系统环境抗灾难才干冗余硬件数据中心1数据中心2源系统源系统SAP HANA数据库SAP HANA数据库存储系统节点4节点1节点2 节点3 节点4节点1节点2存储系统节点3切换镜像操作镜像操作 代理失效恢复节点冷待命Cold Standby节点将替代失效节点HANA分布式待命系统源系统SAP HANA数据库存储系统节点4 节点1节点2 节点3 待命节点规模选型DISCLAIMERSizing recommendations ap

25、ply for certified hardware only. Please contact hardware vendor for suitable hardware configuration.Note that SAP HANA is constantly being optimized. This might have impact on sizing recommendations, which will be reflected in this document. Therefore, check for the latest version of this document a

26、nd the note.Note that the sizing guideline in this document refers to SAP HANA Platform only. Additional applications running on top of SAP HANA (e.g. Business Information Warehouse, etc.) are not covered in this document. Application specific sizing guidelines will be available for these cases soon

27、.经过认证的硬件service.sap/pam包含最新列表经过认证的硬件service.sap/pam包含最新列表*Intel Nehalem CPU将被 Intel Westmere CPU替代SAP HANA平台规模选型：总结内存磁盘CPU内存 = 数据源规模 * 2 / 5CPU: 每个活动用户0.2个CPU内核磁盘日志 = 1 * 内存磁盘存储 = 4 * 内存内存大小：静态数据静态数据对内存的需求从源数据库相应的表的大小推出必需运用数据库特定的类目信息决议数据库大小如Oracle数据库：dba_segments; DB2数据库：syscat.tables).数据库特定脚本，以及决议数

28、据库大小的更多细节可参见SAP Note 1609322.数据库表平均紧缩比率：SAP HANA 内存 = 5 : 1需留意，这一紧缩比率是参考未紧缩数据库表得出的，并未包含数据库索引所占用的空间内存静态 = 源数据大小 / 5内存大小：运转时对象动态创建的对象需求更多的内存 当加载新数据时 当执行检索时我们引荐，为动态对象保管与静态对象同等大小的内存空间：因此，内存总量为：内存静态 = 内存动态内存 =内存静态 +内存动态 =源数据规模* 2 / 5磁盘大小耐久层所需磁盘大小：上述磁盘空间不包括备份的需求。日志文件/操作性磁盘空间所需的磁盘大小：磁盘日志 = 1 * 内存磁盘耐久 = 4 *

29、 内存CPU规模选型规模选型的方法类似于为BW和BWA进展的基于用户的CPU规模选型经过多用户情境最大化查询吞吐量10-20M条，这些情境带有复杂度不等的查询，来自所发布的内容假定：- 三个不同的查询复杂度类别- 三类不同的用户特性点击率，查询复杂度- 用户类别与查询复杂度的分布与BW一样查询吞吐量对于每核/每核活动用户的正态化CPU: 0.2 CPU核/用户SAP HANA系统环境简化企业数据仓库公司商业智能数据库本地商业智能SAP ERP 1(或CRM, SRM, SCM)数据库数据集市数据库抽取商业智能SAP ERP n(或CRM, SRM, SCM)数据库数据集市数据库抽取商业智能非S

30、AP业务运用数据库数据集市数据库. . .This presentation outlines our general product direction and should not be relied on in making a purchase decision.今天的情况企业数据仓库(BW)公司商业智能数据库本地商业智能SAP ERP 1(或CRM, SRM, SCM)数据库同步xSAP ERP n(或CRM, SRM, SCM)数据库SAP HANA 1.0非SAP业务运用数据库SAP HANA 1.0. . .BWASAP HANA 1.0This presentation ou

31、tlines our general product direction and should not be relied on in making a purchase decision.阶段1SAP HANA 1.0普遍可用企业数据仓库(BW)公司商业智能SAP ERP 1(或CRM, SRM, SCM)数据库SAP ERP n(或CRM, SRM, SCM)数据库非SAP业务运用数据库. . .SAP HANA (nxt)虚拟数据集市虚拟数据集市虚拟数据集市本地商业智能This presentation outlines our general product direction and

32、 should not be relied on in making a purchase decision.正在任务中阶段2为BW提供主要的耐久化企业数据仓库(BW)公司商业智能SAP ERP 1(或CRM, SRM, SCM)数据库SAP ERP n(或CRM, SRM, SCM)数据库非SAP业务运用数据库. . .SAP HANA (nxt)虚拟数据集市虚拟数据集市虚拟数据集市本地商业智能新运用This presentation outlines our general product direction and should not be relied on in making a

33、purchase decision.正在任务中阶段3新运用公司商业智能非SAP业务运用数据库SAP HANA虚拟数据集市虚拟数据集市虚拟数据集市本地商业智能新运用ERP 1ERP nEDW (BW). . .This presentation outlines our general product direction and should not be relied on in making a purchase decision.前景阶段4 未来的运用库前景This presentation outlines our general product direction and should

34、 not be relied on in making a purchase decision.简化企业数据仓库公司商业智能数据库本地商业智能SAP ERP 1(或CRM, SRM, SCM)数据库数据集市数据库抽取商业智能SAP ERP n(或CRM, SRM, SCM)数据库数据集市数据库抽取商业智能非SAP业务运用数据库数据集市数据库. . .简化公司商业智能非SAP业务运用数据库SAP HANA虚拟数据集市虚拟数据集市虚拟数据集市本地商业智能新运用ERP 1ERP nEDW (BW). . .前景This presentation outlines our general produc

35、t direction and should not be relied on in making a purchase decision.SAP HANA系统环境引荐对系统环境的思索BI 4.0 GA和SAP HANA 1.0 SPS02今天硬件与答应证 BI 4.0不基于SAP HANA 1.0设备 它需求额外的硬件和额外的答应证硬件提供商和业务同伴进展的安装和配置 SAP HANA 1.0由硬件提供商和业务同伴预备和安装SAP或其他顾问方进展的安装与配置 BI 4.0安装与配置 SAP HANA 1.0安装与配置重要：SAP HANA JDBC驱动需求在BI 4.0系统上手动复制和晋级对

36、系统环境的思索BI 4.0 GA和SAP HANA 1.0 SPS02今天一个BI 4 system可以访问多个SAP HANA 1.0系统当运用Database Credential映射时，SAP HANA数据库的密码必需跨SAP HANA系统相匹配对系统环境思索的道路图明天BI 4.0安装于SAP HANA之外的单独硬件之上BI 4.0客户端可以访问多个HANA实例，以进展报表生成SAP HANA数据库作为容器和审计对 BI 4.1 (CMS) 提供支持简化系统环境作为容器，等待其性能与其他数据库看齐BI 4.0 GAPlanned functionality only. SAP rese

37、rves the right to change planning.BI 4.1运用SAP HANA， 快速部署BI 4未来H2 2021Q2 20212021+This presentation outlines our general product direction and should not be relied on in making a purchase decision.SAP In-Memory Appliance 1.0 基于日志的ERP数据复制三个系统构成的系统环境 - 例子SAP ERP ProductionLoadController Sybase Replicat

38、ion ServerSybase AgentSAP HANA DatabaseSAP HANA ProductionIMCE StudioBI Clients PRDProduction经过CTS传输导入/导出SAP HANA DatabaseSAP HANA DatabaseSAP In-Memory Appliance 1.0 基于触发器的数据复制三个系统构成的系统环境 - 例子SAP ERP ProductionLoadController Sybase Replication ServerSAP HANA DatabaseSAP HANA ProductionIMCE StudioBI

39、 Clients PRDProductionSLTPRDSLTSLT可选：单一的SLT效力于一切非消费系统SAP HANA DatabaseSAP HANA DatabaseSAP In-Memory Appliance 1.0 基于ETL的ERP数据复制三个系统构成的系统环境 - 例子SAP ERP ProductionLoadController Sybase Replication ServerSAP HANA DatabaseSAP HANA ProductionIMCE StudioBI Clients PRDProductionDS4.0PRDSAP HANA DatabaseSA

40、P HANA Database更多信息SAP 网页:Service Marketplace (SMP): service.sap/solutionmanagerSAP Developer Network (SDN): sdn.sap/irj/sdn/alm 相关的SAP 培训和认证信息service.sap/solutionmanager= Services = Expert Guided Implementation 其他相关Tech资料SAP Solution Manager 7.1sap-press.de附录SAP HANA 体系构造体系构造概略引擎本身ERPLogERP DBClien

41、tsSBOP Explorer 4.0XcelsiusSAP BI universes (WebI,.)MS ExcelSBOP AnalysisSAP HANA StudioAdministrationModelingLoad ControllerReplication AgentBusiness Objects EnterpriseData Services DesignerSBO server programs for clientsSBO Information Design ToolOther Source SystemsSAP NetWeaver BW3rd PartyData S

42、ervicesSAP HANA数据库Request Processing / Execution ControlSQL ParserMDXSQL ScriptCalc EngineTransaction ManagerSession ManagementRelational EnginesRow StoreColumn Store耐久层Page ManagementLogger磁盘存储Log VolumesData VolumesAuthorization ManagerMetadata Manager体系构造概略向SAP HANA加载数据SAP HANA ApplianceSAP HANA

43、DatabaseRequest Processing / Execution ControlSQL ParserMDXSQL ScriptCalc EngineTransaction ManagerSession ManagementRelational EnginesRow StoreColumn StorePersistence LayerPage ManagementLoggerDisk StorageLog VolumesData VolumesAuthorization ManagerMetadata ManagerERPLogERP DBSAP HANA StudioReplica

44、tion AgentBusiness Objects EnterpriseData Services DesignerSBO BI4 servers (program for client)SBO Information Design ToolOther Source SystemsSAP NetWeaver BW3rd PartyData Services客户端BI4 ExplorerDashboard DesignSAP BI4 universes (WebI,.)MS ExcelBI4 AnalysisAdministrationModelingLoad ControllerReplic

45、ation ServerSLT Add-on体系构造概略数据建模ERPLogERP DBSAP HANA StudioAdministrationModelingReplication AgentBusiness Objects EnterpriseData Services DesignerSBO BI4 servers (program for client)SBO Information Design ToolOther Source SystemsSAP NetWeaver BW3rd PartyData Services客户端BI4 ExplorerDashboard DesignS

46、AP BI4 universes (WebI,.)MS ExcelBI4 AnalysisSLT Add-onSAP HANA ApplianceSAP HANA DatabaseRequest Processing / Execution ControlSQL ParserMDXSQL ScriptCalc EngineTransaction ManagerSession ManagementRelational EnginesRow StoreColumn StorePersistence LayerPage ManagementLoggerDisk StorageLog VolumesD

47、ata VolumesAuthorization ManagerMetadata ManagerLoad ControllerReplication Server体系构造概略报表生成SAP HANA ApplianceSAP HANA DatabaseRequest Processing / Execution ControlSQL ParserMDXSQL ScriptCalc EngineTransaction ManagerSession ManagementRelational EnginesRow StoreColumn StorePersistence LayerPage Mana

48、gementLoggerDisk StorageLog VolumesData VolumesAuthorization ManagerMetadata ManagerLoad ControllerReplication Server客户端ERPLogERP DBSAP HANA StudioAdministrationModelingReplication AgentBusiness Objects EnterpriseData Services DesignerSBO BI4 servers (program for client)SBO Information Design ToolOt

49、her Source SystemsSAP NetWeaver BW3rd PartyData ServicesBI4 ExplorerDashboard DesignSAP BI4 universes (WebI,.)MS ExcelBI4 AnalysisSLT Add-on体系构造概略管理SAP HANA ApplianceSAP HANA DatabaseRequest Processing / Execution ControlSQL ParserMDXSQL ScriptCalc EngineTransaction ManagerSession ManagementRelation

50、al EnginesRow StoreColumn StorePersistence LayerPage ManagementLoggerDisk StorageLog VolumesData VolumesAuthorization ManagerMetadata ManagerLoad ControllerReplication ServerERPLogERP DBSAP HANA StudioAdministrationModelingReplication AgentBusiness Objects EnterpriseData Services DesignerSBO BI4 servers (program for client)SBO Information Design ToolOther Source SystemsSAP NetWeaver BW3rd PartyData Services客户端BI4 ExplorerDashboard DesignSAP BI4 universes (WebI,.)MS Exce