Hi,
I am requesting some expert inputs for my requirement below.
Need to archive (Load) from 3 legacy systems(Oracle data Base) to SAP BW 7.4 (Sybase Data base).
There are around 6k tables in Legacy servers. This is one time process no need for delta records. Need to copy all data from oracle data base to sap BW.
What is the best approach should we follow?
As per my understanding below options I am expecting.
1. UD connect and create Data Targets –generate data source and load data.
(Need to create 6k Targets is it recommendable)
2. Import tables and data in Sybase from oracle data base and try to generate data source and view the data through virtual providers. (I am not sure if it works)
Is there any other way to dump all tables and data into SAP BW 7.4 sp2 on Sybase?
Thanks in advance,
Nischal.