Skip to Content
author's profile photo Former Member
Former Member

Need a solution

Hi ,

We have a business case as floows:

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 .

Please help me with the best approach.

Regards,

Kalpana

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 02:33 PM

    Hi Kalpana,

    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.

    Regards,

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2009 at 01:51 PM

    Hey,

    >how to integrate the SAP ERP with the DW . Can we do it with PI .

    Sure you can do with PI, Flow -- SAP ECC -


    PI ---Staging table ( Informatica )

    SAP ECC -- use IDOC/ BAPI / Proxy

    Staging table -- Connect with JDBC Adapter from PI

    Cheers

    Agasthuri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 02:14 PM

    Hi Kalpana,

    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.

    Regards,

    Rogério

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Agasthuri and Rogério ,

      Thank you for your replies.

      Rogerio, we have huge data with many look ups that is sent to DW . Is PI (7.0) going to be a good choice for huge files.

      Can you please elaborate on the ELT tools that informatica provides.

      Regards,

      Kalpana.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.