This content has been marked as final. Show 3 replies
What do you mean by 'Oracle', which product?
And I wouldn't guess on any straight forward conversion, it is a different data model/system. Business decision makers are required to make trade off decisions.
I would first do a fit-gap analysis and see what happens.
Also consider switching the loading process to SAP BW off, and loading the 'Oracle' with just new data - after a year most questions can be answered, and the data to be really migrated may be greatly reduced for a possibly small trade-off. During the cut over year, both systems need to be consulted and combined, either manually from the reporting front-end, or with some throw-away programs.
The data will be migrated to Oracle 11g database. To be more specific, we will be using an ETL tool to do this migration (move from source to target) but before we start the ETL work, the data model has to be in place. I was thinking if it is possible to use a modelling tool such as ERwin to derive the logical model from SAP BW, make any adjustments as needed and use it to build the physical model in Oracle. Does this sound as a possible approach? The main task here is to build the data model in Oracle 11g.
ERwin will not give you the functionality to derive the logical data model from SAP BW automatically, however Saphir from Silwood Technology (www.silwoodtechnology.com) does allow you to extract the detailed metadata from the SAP BW system ( as well as from other major standard or customised ERP applications - SAP itself, Oracle, Siebel, Peoplesoft and JD Edwards). Once this information is brought into its own repository, Saphir provides a range of powerful search and view capabilities to allow you to isolate the data you are interested in and then export that information to ERwin (or any other leading Modeling tool).
Saphir will provide you with details of the relationships and detailed definitions within SAP BW.
Hope this helps