Normal SAP BW can be run on any other database like Oracle, DB2, etc. But, SAP BW on HANA runs on HANA DB is faster compared to other DB because it offers in-memory processing and HANA engine. HANA is not just about hardware but also software, hence it is referred to as an appliance.
Migrating SAP BW on HANA supports various exceptional databases and reporting capabilities that cannot be done using other databases. Some of them capabilities it provides – transformations and DSOs are moved to HANA database for fast data processing, data load performance, fast query processing, and optimization, better HANA modeling capabilities, etc.
If you are interested in SAP BW/4HANA, then register for this SAP BW on HANA Certification Course by Intellipaat.
Also, watch this video on SAP BW/4HANA: