Comparison between SAP Hana and BWA

Technically

SAP Hana is far more than BWA

Standard interfaces (SQL, HTTP, rest, MDX)

Real persistence layer (not just flat files) ---> redo/undo logs, backup/recovery,

There is a lot of BWA/trex in Hana

Column store, distributed computing, calculation Engine

Beyond BWA

Row store, persistence, transaction (MaxDB), SQL parser,

 

Data Models/Content

BWA relies completely on SAP BW

You only load infocubes into BWA

Technically trivial data model, automatic creation of relation/join conditions

BWA has bw on top

Complex logic? ---> Do it in BW

Dewfining the data mode? ---> Do it in BW

Analysis authorizations? ---> Do it in BW

SAP Hana is intended as a data mart (and BWA clearly is not) ---> flexibility (not tied to BW)

 

Refer:

Hana can be used as a traditional transactional database and analyticdb.

Hana also provides standardized SQL interfaces, including SQL and MDX, as well as modeling environments, analysis and statistics function libraries.

Hana can also provide complete application platform support on databases in the form of Xs engine and river, all of which are beyond the reach of BWA.

Comparison between SAP Hana and BWA