Oracle Database vs SAP HANA

[saurabh_raheja]

What and When is the best possible way to migrate from Oracle Db to SAP HANA in terms of cost/data/etc?

[former_member183326]

Hello,

A simple search on Google would have sufficed for this question.

There is a lot of information out their on the performance benchmarks:

A simple search brought this back for me:

https://blogs.saphana.com/2015/04/08/oracle-wont-tell-sap-hana-part-2/

[Former Member]

Hi Saurabh.

It´s a bit dificult to know/awnser that, from the technical side probably when you are planing to change/upgrade your hardware or doing some SAP major Upgrades.

From the bussiness side, you have to validate all the improvements from Hana, and try to match then with your current landscape.

Regards.

Osvaldo Ferreira

[saurabh_raheja]

Actually my present client is using Oracle data warehouse.

I wanted to know weather it is good idea in suggesting client that if we use SAP HANA or BW on HANA  then there would be benefit in terms of performance and compressions.

[Former Member]

Hi.

Yes you will benefit from changing to HANA.

There are a lot of info available for that.

You can start by doing a QuickSize from the current Oracle DB.

Take a loook: Sizing for BW on HANA (SAP Notes 1736976 and 1637145)

As for performance, you have to base your approach by used cases and by SAP documentatation in the taht area, because you will only know for certain the gains for your landscape when you test it.

Regards.

Osvaldo Ferreira