What is sap hana

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.

Its primary function as a database server is to store and retrieve data as requested by the applications

1. THE
What is SAP HANA?

2. SAP HANA
An Unrivaled Platform for the Digital Age
SAPHANAisanin-memory,column-oriented,relationaldatabasemanagementsystemdeveloped
bySAP.
PrimaryFunction:Tostoreandretrievedataasrequestedbytheapplications.
AdditionalFunctions:
●Advancedanalytics–predictiveanalytics,spatialdataprocessing,textanalytics,textsearch,streaming
analytics,graphdataprocessing
●Extract,transform,load(ETL)capabilities
●Applicationserver

3. SAP HANA Architecture
TheheartofSAPHANAisSAPIn-MemoryDatabase,it
isaparallelprocessingdatastoragethatcombinesrow
based,columnbased,andobjectbasedstorage
techniques.SAPHANArunstheSUSELinuxServeras
anoperatingsystem.

4. SAP HANA | Components
SAPHostAgent:TheSAPHostAgenthelpsin
managingthesystemandSoftwareUpdate
Manager(SUM)andisalsousedbythe
AdaptiveComputingController(ACC).
LMStructure:Thiscomponentholds
informationonthecurrentinstallationdetails
forSAPHANA.Inthecaseofautomatic
updates,thedatastoredinLMstructureisused
bySUM.
SAPHANAStudioRepository:Thiscomponent
isusedtoupdatetheSAPHANAStudioto
advancedversions.Itisalsousedbytheend
users.
SAPSolutionManagerDiagnosticAgent:Thiscomponentis
usedformonitoringtheSAPHANAsystemsandoffersalldatato
SAPSolutionManager(SAPSOLMAN)alongwithinformation
aboutthecurrentdatabasestate.
Thiscomponentisalsoresponsibleforofferingcommondata
aboutthesystem,suchasalerts,memoryorCPUanddiskusage
aftertheSAPSOLMANismergedwiththeSAPHANAsystem.
SoftwareUpdateManagerforSAPHANA:TheSoftwareUpdate
ManagerprovidesupdatesofSAPHANAfromtheSAP
Marketplaceautomatically.Itisalsoresponsiblefortheupdates
onfixingtheSAPhostagent.Thiscomponentisalsovitalforthe
distributionoftheSAPHANAStudiorepositorytoendusers.

5. How SAP HANA Works
●SAP HANA is designed to replicate and absorb structured datafrom SAP and various non-SAP relational
databases, applications, and other systems.
●SAP HANA mainly supports the following three styles of data replication:
-TriggerBased
-ETL Based
-LogBased
●The style of replication used is dependent on the source system. Once the data is replicated, it is stored in the
RAM and not on the disk, unlike the traditional form of application data storage.
●As the data is stored in memory, it allows the system to access data in real time with the help of analytic and
transactional applications that sit on top of HANA.

6. How SAP HANA Works | Types of Replication
Triggerbased:TheSAPLandscape
TransformationReplicationisatype
oftriggerbaseddatareplicationin
theSAPHANAsystem.Itisthebest
suitableforreplicatingrealtime
datafromSAPandnon-SAP
sources.
ETLbased:TheETLbasedreplicationin
SAPHANAusestheSAPDataServices
formigrationofservicesfromSAPor
non-SAPsourcesystemtotargetthe
HANAdatabase.ItusestheBODS
systemasanETLtooltoextract,
transformandloaddatabetweenthe
sourcesystemandthetargetsystem.
Logbased:Thismethodofreplication
isdatabasedependent.Itisbasedon
recordingtablechangesfromlowlevel
databaselogfiles.Oncethechanges
arecaptureditisthenpopulatedto
eachdatabasetransactionsandthen
theyarereplayedontheHANA
database.Thishelpsinmaintaining
consistency.

7. Want to know more?
Contact us today at:
[email protected]
for a free demo, discussion, and evaluation of
your business.