Skip to Content
0
Former Member
Apr 23, 2014 at 02:13 PM

How to bring HANA views data into SAP BW where BW database is SQL

330 Views

Hello All ,

I would like to know what is the best approach to follow if you have to pull HANA views into BW when your database is not HANA. The virtual provider is the option to go for if your BW system is on HANA database. In my case, since the database is SQL, when I attempt to create the virtual provider, I do not see the option "Based on HANA model".

We are on BW 7.4 and our company is migrating to HANA database sometime next year. So, need to figure out what is the best alternative solution to extract data from HANA views into BW.

I have to load HANA view data into the virtual cube of BW and slip it in a multiprovider.

Thanks