SAP_HANA_Master_Guide_en

PUBLICSAPHANAPlatformSPS07DocumentVersion:1.1-13-03-2014SAPHANAMasterGuideTableofContents1GettingStartedwithSAPHANA...................................................41.1AboutThisDocument............................................................41.2WhatIsSAPHANA?.............................................................41.3SAPHANAGuides...............................................................51.4RelatedInformation..............................................................51.5ImportantSAPNotes.............................................................61.6SoftwareDownload.............................................................101.7SoftwareComponents...........................................................111.8HardwareandSoftwareRequirements................................................121.9SAPLicenseKey...............................................................142TheSAPHANANetwork.........................................................152.1ConnectionsfromDatabaseClientsandWebClientstoSAPHANA...........................162.2TheNetworkforDistributedSAPHANASystems........................................202.2.1HighAvailabilityforSAPHANA..............................................243SAPHANADataProvisioning....................................................263.1SAPEventStreamProcessor......................................................263.2SAPHANASmartDataAccess.....................................................263.3SAPHANAReplicationTechnologies.................................................273.3.1Trigger-BasedReplication(SAPLandscapeTransformation(LT)ReplicationServer).......293.3.2SAPHANADirectExtractorConnection(DXC)...................................303.3.3ETL-BasedReplication(SAPDataServices).....................................333.3.4Log-BasedReplication(SAPReplicationServer).................................353.3.5ComparisonofReplicationMethods..........................................374SAPHANAEnd-To-EndRoadmap.................................................404.1SizingSAPHANA..............................................................404.2InstallingSAPHANA............................................................404.3IntegratingSAPHANAintoCustomerLandscapes.......................................414.4SAPHANADataManagement......................................................414.4.1ConfiguringDataReplication...............................................424.4.2ModelingData..........................................................424.4.3ModelingandDataProvisioningforETL-BasedReplication(SAPDataServices)...........434.5ConfiguringEnd-UserClients......................................................434.5.1InstallingandUsingtheSAPHANAODBOClientforMSEXCEL.......................444.5.2InstallingandUsingtheSAPHANAODBCClientforMSEXCEL.......................484.5.3UsingMSExceltoCreateaPivotTable........................................604.5.4UsingSAPBusinessObjectsBIClientsforSAPHANA..............................604.6AdministratingSAPHANA........................................................622PUBLIC©2014SAPAGoranSAPaffiliatecompany.Allrightsreserved.SAPHANAMasterGuideTableofContents4.7UsingSAPHANAwithEnd-UserClients...............................................625ImportantDisclaimersonLegalAspects............................................63SAPHANAMasterGuideTableofContentsPUBLIC©2014SAPAGoranSAPaffiliatecompany.Allrightsreserved.31GettingStartedwithSAPHANA1.1AboutThisDocumentThisMasterGuideisthecentralstartingpointforthetechnicalimplementationofSAPHANA.TheMasterGuideprovidesthefollowinginformationaboutSAPHANA:●Overview●Architecture●Softwarecomponents●Deploymentscenarios1.2WhatIsSAPHANA?SAPHANAisamodern,in-memorydatabaseandplatformthatisdeployableon-premiseorinthecloud.●On-premiseSAPHANAisdeployedthroughthefollowingofferings:○Asanappliance,SAPHANAcombinessoftwarecomponentsfromSAPoptimizedonprovenhardwareprovidedbySAP’shardwarepartners.○Comparedwiththeappliancedeliveryapproach,SAPHANAtailoreddatacenterintegrationisamoreopenandflexibleapproachtoserveyourneedsregardingtheintegrationofSAPHANAinthedatacenter.Therequirementsforthisdeploymentoptionareasfollows:○TheserverislistedintheSAPHANAproductavailabilitymatrix.○ThestoragesolutionhassuccessfullypassedSAPHANAhardwarecertification.○ThepersonperformingtheSAPHANAinstallationhaspassedthecertificationexam(E_HANAINS131).●Inthecloud,SAPHANAisofferedasacomprehensiveinfrastructurecombinedwithmanagedservices.SAPHANAisalsodeployedthroughthefollowingcloudofferings:○SAPHANAOne○SAPHANACloudPlatform○SAPHANAEnterpriseCloudTheSAPHANAplatformisaflexibledatasourceagnosticin-memorydataplatformthatallowscustomerstoanalyzelargevolumesofdatainreal-time.Itisalsoadevelopmentplatform,providinganinfrastructureandtoolsforbuildinghigh-performanceapplicationsbasedonSAPHANAExtendedApplicationServices(SAPHANAXS).ItisthefoundationofvariousSAPHANAeditions,liketheSAPHANAPlatformEdition,providingcoredatabasetechnology,andtheSAPHANAEnterpriseEdition,bundlingaddi