Currently the business runs on Oracle ERP. There is an interface form Oracle ERP to DW through Informatica. Now the oracle ERP is being changed to SAP ERP. Now the question is how to integrate the SAP ERP with the DW . Can we do it with PI .
It all depends on how currently they are doing and how they want to migrate. If they are currently connecting using files or using databases on both sides you can do the same from xi also. If they are using an plugin from informatica then you can also do that.
Informatica has plug ins for directly connecting to SAP R3 and SAP BW. Here informatica can directly connect to these systems without involving xi also. But if you want to use xi for any reasons, then you can very well integrate with xi using the file systems or the databases. It should be very straight forward. Think like you are going to do a rfc/proxy/idoc - xi - file/jdbc scenario.
Sure you can use SAP PI in order to Extract data from SAP ERP to another system such as your DW Informatica.
However you may considering use specific ETL tools. Consider using more specific tools for ELT for better performance if you have a huge amount of data and a small runtime. Informatica has ELT tools integrated to SAP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.