1、Matt Kangas/CSA AmericasHong Gun Cho/CSA TechnologyDennis Schwerer/CSA TechnologySeptember, 2021TEC104如何將SAP內(nèi)存計(jì)算運(yùn)用(SAP HANA)集成到他的系統(tǒng)規(guī)劃中 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 體系構(gòu)造與系統(tǒng)環(huán)境概覽數(shù)據(jù)抽取數(shù)據(jù)加載的選項(xiàng)運(yùn)用SLT進(jìn)展數(shù)據(jù)抽取系統(tǒng)擴(kuò)展規(guī)模選型SAP HANA系統(tǒng)環(huán)境簡化引薦運(yùn)用的方法什么是SAP HANA?什么是SAP HANA?硬件技術(shù)的創(chuàng)新當(dāng)前效力器中的64 bit地址空間 2 TB100 GB/s的數(shù)據(jù)吞吐量價(jià)錢猛烈下降，性能飛速上升

5、多核體系構(gòu)造 (每臺刀片效力器8 x 8核CPU)運(yùn)用多個(gè)刀片效力器進(jìn)展批量并行擴(kuò)展1臺刀片效力器約$50,000 = 1臺企業(yè)級效力器行存儲(chǔ)與列存儲(chǔ)數(shù)據(jù)緊縮數(shù)據(jù)分割無匯總表只對增量數(shù)據(jù)進(jìn)展插入SAP軟件技術(shù)的創(chuàng)新更加廉價(jià)的硬件與技術(shù)創(chuàng)新相結(jié)合，使SAP有才干在具有內(nèi)存計(jì)算業(yè)務(wù)運(yùn)用的實(shí)時(shí)企業(yè)環(huán)境規(guī)劃下發(fā)布產(chǎn)品什么是SAP HANA?SAP HANA預(yù)打包的處理方案，以預(yù)安裝和定義的方式向客戶發(fā)布內(nèi)嵌工具，管理生命周期、平安優(yōu)化與日常運(yùn)營為繼續(xù)運(yùn)營提供其必需的義務(wù)、概念與過程的最正確實(shí)際SAP HANA 將軟件與硬件結(jié)合起來內(nèi)存計(jì)算引擎軟件預(yù)先安裝好的系統(tǒng)硬件+SAP HANA “Applian

6、ce的含義時(shí)間價(jià)值便于安裝降低總擁有本錢便于維護(hù)SAP HANA - “Appliance的含義傳統(tǒng)軟件發(fā)布方式：on-premise處理方案SAP僅提供軟件客戶擔(dān)任管理整個(gè)產(chǎn)品生命周期Appliance的發(fā)布一種“SaaS式的正規(guī)客戶SAP定義整體處理方案SAP與協(xié)作同伴管理產(chǎn)品生命周期 Appliance運(yùn)營概念根底設(shè)備*運(yùn)營*安裝/咨詢支持軟件、維護(hù)、根底設(shè)備SAP 軟件開發(fā)軟件與答應(yīng)證硬件與技術(shù)協(xié)作同伴SAP托管與云計(jì)算的發(fā)布根底設(shè)備運(yùn)營安裝/咨詢支持軟件、維護(hù)、根底設(shè)備SAP軟件開發(fā)軟件與答應(yīng)證* 可以外包或由客戶所擁有SAP的職責(zé)客戶的職責(zé)協(xié)作同伴的職責(zé)SAP HANA-體系構(gòu)造與

7、系統(tǒng)環(huán)境概覽體系構(gòu)造概覽SAP HANA Appliance與周邊環(huán)境SAP HANA ApplianceERP日志ERP數(shù)據(jù)庫ClientsBI4 ExplorerDashboard設(shè)計(jì)SAP BI4 universes (WebI,.)MS ExcelBI4 AnalysisSAP HANA數(shù)據(jù)庫處置懇求/執(zhí)行控制SQL ParserMDXSQL ScriptCalc EngineTransaction Manager會(huì)話管理Relational EnginesRow StoreColumn StorePersistence LayerPage ManagementLogger磁盤存儲(chǔ)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其他數(shù)據(jù)源SAP NetWeaver BW第三方系統(tǒng)Data ServicesSLT Add-onSAPHost Age

9、ntSybase Replication Server SAP HANAstudioSAP HANA applianceSAP HANA Load ControllerSAP HANA構(gòu)件體系構(gòu)造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硬件廠商特定的效力器管理工具存儲(chǔ)子系統(tǒng)SAP SW Update Manager (SUM) for SAP HANASL Toolset 1.0SAP JVM從部署的角度看The SAP HANA appliance軟件經(jīng)過適當(dāng)定義與驗(yàn)證的硬件和軟件庫數(shù)據(jù)源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系統(tǒng)環(huán)境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恣意數(shù)據(jù)源SAP BusinessObjects BI 4.0RepositorySAP BusinessObjects B

14、I clientsSQLMDXBICSAuthenticationContent mgmtsync管理與模型控制load(可選的)(可選的)(可選的)(現(xiàn)存系統(tǒng))StudioSLT數(shù)據(jù)抽取數(shù)據(jù)加載的可選方案SAP HANA數(shù)據(jù)復(fù)制技術(shù)加載數(shù)據(jù)的可選方式Load Controller & Sybase Replication Server (基于數(shù)據(jù)庫日志的復(fù)制)SAP LT Replication (基于觸發(fā)器的復(fù)制)Data Services 4.0 (基于ETL的復(fù)制)R3load (非正式 用于概念驗(yàn)證)主安裝中，為全面導(dǎo)出數(shù)據(jù)而進(jìn)展的系統(tǒng)復(fù)制Python importManager.p

15、y & exportManager.py從SAP HANA導(dǎo)出向SAP HANA導(dǎo)入SQL語句:運(yùn)用SQL語句創(chuàng)建MARA表(難以手工完成)LOAD from /HANA/HN1_COPA_TABLES/MARA.ctl THREADS 4 BATCH 100; 從SAP ERP表向SAP HANA復(fù)制參考SAP note # 1513496 以獲取關(guān)于這些限制的最新信息截至2021年7月的方案數(shù)據(jù)庫技術(shù)可用性及其認(rèn)證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答應(yīng)證限制仍能夠存在支持才干矩陣 參考SAP Note 1513496來獲取最新的正式發(fā)布的限制能力日志文件的復(fù)制SLT復(fù)制Data Services 4.0數(shù)據(jù)庫表類型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數(shù)據(jù)抽取運(yùn)用SLT進(jìn)展數(shù)據(jù)抽取LT Replication的概念:基于觸發(fā)器方式的體系構(gòu)造與關(guān)鍵構(gòu)件SAP HANA systemLT system (NW7.02)運(yùn)用程序數(shù)據(jù)庫表源系統(tǒng)Write ModulesControler Modules數(shù)據(jù)庫銜接RFC銜接Read ModulesLogging

21、Tables運(yùn)用程序數(shù)據(jù)庫表DB Trigger高效率的數(shù)據(jù)初始復(fù)制，基于數(shù)據(jù)庫觸發(fā)器的和增量日志概念 接近零關(guān)機(jī)時(shí)間靈敏可靠的數(shù)據(jù)復(fù)制流程，包括數(shù)據(jù)遷移為TDMS和SAP LT所運(yùn)用經(jīng)過數(shù)據(jù)庫銜接進(jìn)展數(shù)據(jù)復(fù)制無其他交互LT replicator不用作為單獨(dú)的SAP系統(tǒng)部署，可以運(yùn)轉(zhuǎn)在任何版本為7.02 ABAP stack (Kernel 7.20EXT) 的SAP NetWeaver 上LT Replicator 的技術(shù)要求和系統(tǒng)設(shè)置SAP HANA系統(tǒng)LT系統(tǒng)(NW7.02)源系統(tǒng)系統(tǒng)需求:- SAP Basis: Netweaver 702，Kernel 7.20EXT 目前有限的平臺

22、可用性 - 文件系統(tǒng)：100 GB- RAM: 16-32 GB CPU: 2-4核數(shù)據(jù)庫銜接RFC銜接系統(tǒng)需求 SAP Basis 4.6C或更高 一切數(shù)據(jù)庫安裝： 各DMIS 2021版本 最低支持包程度：最近可用安裝： Add-on DMIS 2021_1_700 最低支持包程度： SP04 (與SAP HANA 1.0 GA同步發(fā)布)* I安裝： SAP HANA SPS02：包括LT復(fù)制功能完選集成到HANA Modeler的用戶界面根本配置： 定義到源系統(tǒng)的RFC銜接- 定義到HANA系統(tǒng)的數(shù)據(jù)庫銜接- 定義數(shù)據(jù)復(fù)制所需的最大作業(yè)數(shù)根本配置： 可選：為日志表定義分別的表空間 為RF

23、C用戶定義適當(dāng)?shù)氖跈?quán)根本配置：- 創(chuàng)建數(shù)據(jù)庫用戶假設(shè)需求LT replicator的實(shí)例可以運(yùn)轉(zhuǎn)在恣意SAP NetWeaver 7.02 ABAP 系統(tǒng)運(yùn)用SAP Kernel 7.20EXT上，例如Solution Manager 7.1，源系統(tǒng)甚至HANA效力器需求安裝SAP NetWeaver 7.02 ABAP Stack作為 LT Replicator的根底-它不用是一個(gè)獨(dú)立的SAP系統(tǒng)！系統(tǒng)擴(kuò)展分布式系統(tǒng)運(yùn)用共享文件系統(tǒng)的多節(jié)點(diǎn)，以進(jìn)展負(fù)載分配SAP HANA分布式系統(tǒng)源系統(tǒng)SAP HANA數(shù)據(jù)庫存儲(chǔ)系統(tǒng)節(jié)點(diǎn)4 節(jié)點(diǎn)1節(jié)點(diǎn)2 節(jié)點(diǎn)3 高可用性特點(diǎn)情境單一數(shù)據(jù)中心失效由于火災(zāi)，斷電

24、，地震等單一節(jié)點(diǎn)失效硬件缺點(diǎn)概念冗余數(shù)據(jù)中心包括冗余SAP HANA系統(tǒng)-熱待命同步鏡像單一SAP HABA數(shù)據(jù)庫系統(tǒng)環(huán)境內(nèi)的待命系統(tǒng)-冷待命失效恢復(fù)被自動(dòng)觸發(fā)2個(gè)獨(dú)立的系統(tǒng)環(huán)境抗災(zāi)難才干冗余硬件數(shù)據(jù)中心1數(shù)據(jù)中心2源系統(tǒng)源系統(tǒng)SAP HANA數(shù)據(jù)庫SAP HANA數(shù)據(jù)庫存儲(chǔ)系統(tǒng)節(jié)點(diǎn)4節(jié)點(diǎn)1節(jié)點(diǎn)2 節(jié)點(diǎn)3 節(jié)點(diǎn)4節(jié)點(diǎn)1節(jié)點(diǎn)2存儲(chǔ)系統(tǒng)節(jié)點(diǎn)3切換鏡像操作鏡像操作 代理失效恢復(fù)節(jié)點(diǎn)冷待命Cold Standby節(jié)點(diǎn)將替代失效節(jié)點(diǎn)HANA分布式待命系統(tǒng)源系統(tǒng)SAP HANA數(shù)據(jù)庫存儲(chǔ)系統(tǒng)節(jié)點(diǎn)4 節(jié)點(diǎn)1節(jié)點(diǎn)2 節(jié)點(diǎn)3 待命節(jié)點(diǎn)規(guī)模選型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、.經(jīng)過認(rèn)證的硬件service.sap/pam包含最新列表經(jīng)過認(rèn)證的硬件service.sap/pam包含最新列表*Intel Nehalem CPU將被 Intel Westmere CPU替代SAP HANA平臺規(guī)模選型：總結(jié)內(nèi)存磁盤CPU內(nèi)存 = 數(shù)據(jù)源規(guī)模 * 2 / 5CPU: 每個(gè)活動(dòng)用戶0.2個(gè)CPU內(nèi)核磁盤日志 = 1 * 內(nèi)存磁盤存儲(chǔ) = 4 * 內(nèi)存內(nèi)存大小：靜態(tài)數(shù)據(jù)靜態(tài)數(shù)據(jù)對內(nèi)存的需求從源數(shù)據(jù)庫相應(yīng)的表的大小推出必需運(yùn)用數(shù)據(jù)庫特定的類目信息決議數(shù)據(jù)庫大小如Oracle數(shù)據(jù)庫：dba_segments; DB2數(shù)據(jù)庫：syscat.tables).數(shù)據(jù)庫特定腳本，以及決議數(shù)

28、據(jù)庫大小的更多細(xì)節(jié)可參見SAP Note 1609322.數(shù)據(jù)庫表平均緊縮比率：SAP HANA 內(nèi)存 = 5 : 1需留意，這一緊縮比率是參考未緊縮數(shù)據(jù)庫表得出的，并未包含數(shù)據(jù)庫索引所占用的空間內(nèi)存靜態(tài) = 源數(shù)據(jù)大小 / 5內(nèi)存大小：運(yùn)轉(zhuǎn)時(shí)對象動(dòng)態(tài)創(chuàng)建的對象需求更多的內(nèi)存 當(dāng)加載新數(shù)據(jù)時(shí) 當(dāng)執(zhí)行檢索時(shí)我們引薦，為動(dòng)態(tài)對象保管與靜態(tài)對象同等大小的內(nèi)存空間：因此，內(nèi)存總量為：內(nèi)存靜態(tài) = 內(nèi)存動(dòng)態(tài)內(nèi)存 =內(nèi)存靜態(tài) +內(nèi)存動(dòng)態(tài) =源數(shù)據(jù)規(guī)模* 2 / 5磁盤大小耐久層所需磁盤大小：上述磁盤空間不包括備份的需求。日志文件/操作性磁盤空間所需的磁盤大小：磁盤日志 = 1 * 內(nèi)存磁盤耐久 = 4 *

29、 內(nèi)存CPU規(guī)模選型規(guī)模選型的方法類似于為BW和BWA進(jìn)展的基于用戶的CPU規(guī)模選型經(jīng)過多用戶情境最大化查詢吞吐量10-20M條，這些情境帶有復(fù)雜度不等的查詢，來自所發(fā)布的內(nèi)容假定：- 三個(gè)不同的查詢復(fù)雜度類別- 三類不同的用戶特性點(diǎn)擊率，查詢復(fù)雜度- 用戶類別與查詢復(fù)雜度的分布與BW一樣查詢吞吐量對于每核/每核活動(dòng)用戶的正態(tài)化CPU: 0.2 CPU核/用戶SAP HANA系統(tǒng)環(huán)境簡化企業(yè)數(shù)據(jù)倉庫公司商業(yè)智能數(shù)據(jù)庫本地商業(yè)智能SAP ERP 1(或CRM, SRM, SCM)數(shù)據(jù)庫數(shù)據(jù)集市數(shù)據(jù)庫抽取商業(yè)智能SAP ERP n(或CRM, SRM, SCM)數(shù)據(jù)庫數(shù)據(jù)集市數(shù)據(jù)庫抽取商業(yè)智能非S

30、AP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫數(shù)據(jù)集市數(shù)據(jù)庫. . .This presentation outlines our general product direction and should not be relied on in making a purchase decision.今天的情況企業(yè)數(shù)據(jù)倉庫(BW)公司商業(yè)智能數(shù)據(jù)庫本地商業(yè)智能SAP ERP 1(或CRM, SRM, SCM)數(shù)據(jù)庫同步xSAP ERP n(或CRM, SRM, SCM)數(shù)據(jù)庫SAP HANA 1.0非SAP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫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普遍可用企業(yè)數(shù)據(jù)倉庫(BW)公司商業(yè)智能SAP ERP 1(或CRM, SRM, SCM)數(shù)據(jù)庫SAP ERP n(或CRM, SRM, SCM)數(shù)據(jù)庫非SAP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫. . .SAP HANA (nxt)虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市本地商業(yè)智能This presentation outlines our general product direction and

32、 should not be relied on in making a purchase decision.正在任務(wù)中階段2為BW提供主要的耐久化企業(yè)數(shù)據(jù)倉庫(BW)公司商業(yè)智能SAP ERP 1(或CRM, SRM, SCM)數(shù)據(jù)庫SAP ERP n(或CRM, SRM, SCM)數(shù)據(jù)庫非SAP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫. . .SAP HANA (nxt)虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市本地商業(yè)智能新運(yùn)用This presentation outlines our general product direction and should not be relied on in making a

33、purchase decision.正在任務(wù)中階段3新運(yùn)用公司商業(yè)智能非SAP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫SAP HANA虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市本地商業(yè)智能新運(yùn)用ERP 1ERP nEDW (BW). . .This presentation outlines our general product direction and should not be relied on in making a purchase decision.前景階段4 未來的運(yùn)用庫前景This presentation outlines our general product direction and should

34、 not be relied on in making a purchase decision.簡化企業(yè)數(shù)據(jù)倉庫公司商業(yè)智能數(shù)據(jù)庫本地商業(yè)智能SAP ERP 1(或CRM, SRM, SCM)數(shù)據(jù)庫數(shù)據(jù)集市數(shù)據(jù)庫抽取商業(yè)智能SAP ERP n(或CRM, SRM, SCM)數(shù)據(jù)庫數(shù)據(jù)集市數(shù)據(jù)庫抽取商業(yè)智能非SAP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫數(shù)據(jù)集市數(shù)據(jù)庫. . .簡化公司商業(yè)智能非SAP業(yè)務(wù)運(yùn)用數(shù)據(jù)庫SAP HANA虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市虛擬數(shù)據(jù)集市本地商業(yè)智能新運(yùn)用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系統(tǒng)環(huán)境引薦對系統(tǒng)環(huán)境的思索BI 4.0 GA和SAP HANA 1.0 SPS02今天硬件與答應(yīng)證 BI 4.0不基于SAP HANA 1.0設(shè)備 它需求額外的硬件和額外的答應(yīng)證硬件提供商和業(yè)務(wù)同伴進(jìn)展的安裝和配置 SAP HANA 1.0由硬件提供商和業(yè)務(wù)同伴預(yù)備和安裝SAP或其他顧問方進(jìn)展的安裝與配置 BI 4.0安裝與配置 SAP HANA 1.0安裝與配置重要：SAP HANA JDBC驅(qū)動(dòng)需求在BI 4.0系統(tǒng)上手動(dòng)復(fù)制和晉級對

36、系統(tǒng)環(huán)境的思索BI 4.0 GA和SAP HANA 1.0 SPS02今天一個(gè)BI 4 system可以訪問多個(gè)SAP HANA 1.0系統(tǒng)當(dāng)運(yùn)用Database Credential映射時(shí)，SAP HANA數(shù)據(jù)庫的密碼必需跨SAP HANA系統(tǒng)相匹配對系統(tǒng)環(huán)境思索的道路圖明天BI 4.0安裝于SAP HANA之外的單獨(dú)硬件之上BI 4.0客戶端可以訪問多個(gè)HANA實(shí)例，以進(jìn)展報(bào)表生成SAP HANA數(shù)據(jù)庫作為容器和審計(jì)對 BI 4.1 (CMS) 提供支持簡化系統(tǒng)環(huán)境作為容器，等待其性能與其他數(shù)據(jù)庫看齊BI 4.0 GAPlanned functionality only. SAP rese

37、rves the right to change planning.BI 4.1運(yùn)用SAP HANA， 快速部署B(yǎng)I 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數(shù)據(jù)復(fù)制三個(gè)系統(tǒng)構(gòu)成的系統(tǒng)環(huán)境 - 例子SAP ERP ProductionLoadController Sybase Replicat

38、ion ServerSybase AgentSAP HANA DatabaseSAP HANA ProductionIMCE StudioBI Clients PRDProduction經(jīng)過CTS傳輸導(dǎo)入/導(dǎo)出SAP HANA DatabaseSAP HANA DatabaseSAP In-Memory Appliance 1.0 基于觸發(fā)器的數(shù)據(jù)復(fù)制三個(gè)系統(tǒng)構(gòu)成的系統(tǒng)環(huán)境 - 例子SAP ERP ProductionLoadController Sybase Replication ServerSAP HANA DatabaseSAP HANA ProductionIMCE StudioBI

39、 Clients PRDProductionSLTPRDSLTSLT可選：單一的SLT效力于一切非消費(fèi)系統(tǒng)SAP HANA DatabaseSAP HANA DatabaseSAP In-Memory Appliance 1.0 基于ETL的ERP數(shù)據(jù)復(fù)制三個(gè)系統(tǒng)構(gòu)成的系統(tǒng)環(huán)境 - 例子SAP ERP ProductionLoadController Sybase Replication ServerSAP HANA DatabaseSAP HANA ProductionIMCE StudioBI Clients PRDProductionDS4.0PRDSAP HANA DatabaseSA

40、P HANA Database更多信息SAP 網(wǎng)頁:Service Marketplace (SMP): service.sap/solutionmanagerSAP Developer Network (SDN): sdn.sap/irj/sdn/alm 相關(guān)的SAP 培訓(xùn)和認(rèn)證信息service.sap/solutionmanager= Services = Expert Guided Implementation 其他相關(guān)Tech資料SAP Solution Manager 7.1sap-press.de附錄SAP HANA 體系構(gòu)造體系構(gòu)造概略引擎本身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數(shù)據(jù)庫Request Processing / Execution ControlSQL ParserMDXSQL ScriptCalc EngineTransaction ManagerSession ManagementRelational EnginesRow StoreColumn Store耐久層Page ManagementLogger磁盤存儲(chǔ)Log VolumesData VolumesAuthorization ManagerMetadata Manager體系構(gòu)造概略向SAP HANA加載數(shù)據(jù)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體系構(gòu)造概略數(shù)據(jù)建模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體系構(gòu)造概略報(bào)表生成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體系構(gòu)造概略管理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