SAP BW On HANA Online / In-Class Training SAP Business Information Warehouse (BW) on the SAP HANA. SAP BW is also specially optimized for HANA above and beyond its optimization for other databases. BW does have database-specific optimizations for other databases — for example, it supports DB2’s clustering concept for very large tables, whereas most other databases use a partitioning concept to handle this scenario — but the situation with SAP HANA goes above and beyond. Activities like the activation step for DataStore Objects, or DSOs, and certain types of transformations are functionally the same on HANA as on other databases, but the actual processing has been moved into HANA rather than happening on the BW application server as it does with other databases. This cuts down on data movement, making it possible to execute these activities much faster with BW on HANA.