Migrate from Oracle to SAP HANA

1281 Views Last edit Jul 27, 2017 at 03:50 AM 2 rev

Hi,

Enterprise is having ECC, SRM and BW system. All the system are currently running on Oracle Database. Data is getting loaded to BW from both ECC and SRM system using process chains.

There are different scenario in which system can be migrated from oracle to SAP HANA database. These are :

Scenario 1 :

Migrate ECC first followed by BW and SRM system to HANA database.

Scenario 2 :

Migrate BW first followed by ECC and SRM system to HANA database

Scenario 3 :

Migrate SRM first followed by BW and ECC system to HANA database

Scenario 4:

Migrate SRM first followed by ECC and BW system to HANA database

Scenario 5 :

Migrate BW first followed by SRM and ECC system to HANA database

Scenario 6 :

Migrate ECC first followed by SRM and BW system to HANA database

Questions:

If one of my system is on HANA and other is on oracle, what are the challenges. e.g. scenario 2, if BW system is migrated to SAP HANA DB and ECC & SRM are on oracle yet, is there any data load issue or any other reporting issue.

Thanks in advance for your reply.

Cheers,

Pankaj