What's the difference between SAP BWA and HANA?
SAP Business Warehouse Accelerator (SAP BWA) is one of the ancestors of HANA, so there are definite similarities between the two SAP technologies. Both are in-memory, columnar, parallel database architectures. This means that both systems can distribute large queries evenly among hundreds of processors across several servers. However, BWA is very narrowly focused on its use case as an analytics accelerator and lacks many of the capabilities that allow HANA to act as a full database and application platform. For example, BWA requires that whenever data changes, its columnar indexes are fully rebuilt.
For more on SAP, HANA
What's SAP's approach to big data?
Know the difference between the HANA Enterprise Cloud and the HANA Cloud Platform?
What does it cost to run an SAP project in the AWS cloud?
HANA allows for much more fine-grained updates, allowing indices to be rebuilt much less often, making HANA workable as a transactional and an analytic database. HANA also provides standard interfaces (like SQL and MDX), a modeling environment, analytic and statistical function libraries and a full-fledged application platform on top of its database capabilities in the form of XS Engine and River -- all things that BWA never really aspired to.
So is there any place for BWA anymore? Not really. If a company already has BWA and doesn't want to go through the potential expense and disruption of migrating to BW on HANA, then it might make sense to stick with BWA for the moment. But the future looks to be BW on HANA. On the bright side, BW on HANA may not be as expensive a proposition as it seems at first, because BW and HANA both provide ample options for keeping data in cheaper, disk-based storage systems like SAP's Sybase IQ or Apache Hive while still getting good (but not as good, in most cases) performance.
Dig Deeper on SAP business warehouse
Related Q&A from Ethan Jewett
You'll understand the different innovation and maintenance versions, the role of ABAP delivery stacks and how long to count on support once you know ... Continue Reading
Learn about the many other online resources -- both inside SAP and in the broader tech community -- for finding answers to your questions before ... Continue Reading
Try other avenues first, but then prepare an SAP support ticket that will clearly describe and recreate your incident, so SAP can assign it to the ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.