SAP HANA 1.0 Master Guide

SAPHANAMasterGuide■SAPIn-MemoryAppliance(SAPHANA)1.02011-06-23©2011SAPAG.Allrightsreserved.SAP,R/3,SAPNetWeaver,Duet,PartnerEdge,ByDesign,SAPBusinessObjectsExplorer,StreamWork,andotherSAPproductsandservicesmentionedhereinasCopyrightwellastheirrespectivelogosaretrademarksorregisteredtrademarksofSAPAGinGermanyandothercountries.BusinessObjectsandtheBusinessObjectslogo,BusinessObjects,CrystalReports,CrystalDecisions,WebIntelligence,Xcelsius,andotherBusinessObjectsproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofBusinessObjectsSoftwareLtd.BusinessObjectsisanSAPcompany.SybaseandAdaptiveServer,iAnywhere,Sybase365,SQLAnywhere,andotherSybaseproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofSybase,Inc.SybaseisanSAPcompany.Allotherproductandservicenamesmentionedarethetrademarksoftheirrespectivecompanies.Datacontainedinthisdocumentservesinformationalpurposesonly.Nationalproductspecificationsmayvary.Thesematerialsaresubjecttochangewithoutnotice.ThesematerialsareprovidedbySAPAGanditsaffiliatedcompanies(SAPGroup)forinformationalpurposesonly,withoutrepresentationorwarrantyofanykind,andSAPGroupshallnotbeliableforerrorsoromissionswithrespecttothematerials.TheonlywarrantiesforSAPGroupproductsandservicesarethosethataresetforthintheexpresswarrantystatementsaccompanyingsuchproductsandservices,ifany.Nothinghereinshouldbeconstruedasconstitutinganadditionalwarranty.2011-06-23ContentsGettingStartedwithSAPIn-MemoryAppliance(SAPHANA)................................................5Chapter1AboutthisDocument...............................................................................................................51.1SAPHANAGuides.................................................................................................................51.2RelatedInformation..................................................................................................................61.3ImportantSAPNotes...............................................................................................................81.4SoftwareDownload..................................................................................................................91.5SoftwareComponents.............................................................................................................91.6HardwareandSoftwareRequirements...................................................................................101.7WhatisSAPHANA?..............................................................................................................101.8SAPHANAReplicationTechnologies...................................................................................13Chapter2Introduction............................................................................................................................132.1Trigger-BasedReplication......................................................................................................152.2ETL-BasedReplication...........................................................................................................162.3Log-BasedReplication...........................................................................................................192.4ReplicationMethodsComparison..........................................................................................212.5SAPHANAEnd-To-EndRoadmap.........................................................................................25Chapter3SizingSAPHANA..................................................................................................................253.1InstallingSAPHANA..............................................................................................................253.2IntegratingSAPHANAintoCustomerLandscapes................................................................253.3SAPHANADataManagement...............................................................................................263.4ConfiguringDataReplication..................................................................................................273.4.1ModelingData.......................................................................................................................273.4.2ModelingandDataProvisioningforETL-BasedReplication(SAPBusinessObjectsDataServices)................................................................................................................................273.4.3ConfiguringEndUserClients.................................................................................................283.5InstallingandUsingtheIMDBODBO1.0ClientforMSEXCEL.............................................283.5.1InstallingandUsingtheIMDBODBC1.0ClientforMSEXCEL.............................................333.5.2UsingMSExcelandCreatingaPivotTable............................................................................443.5.3UsingSAPBusinessObjectsBIClientsforSAPHANA.