2 Replies Latest reply: Mar 26, 2013 2:08 PM by user9041197 RSS

    ODI with SAP Adapters


      We are planning to replace our current ETL tool Informatica with ODI. In the current context, Informatica SAP Adapters are working fine extracting SAP data from SAP Tables (SE16) and SAP ABAP Functions (Called from Informatica Interfaces) in stream mode . With current setup, Informatica is able to extract 2 Million Records in 30 minutes.

      We are not sure how ODI SAP Adapters work in this regard.

      So any inputs on ODI SAP Adapters with regard to :

      - Data extraction Performance
      - Feasibility of Extraction of SAP Data from SAP Tables and SAP Functions (return dataset)
      - Feedback on the stability and scalability of the ODI SAP Adapters

      are highly appreciated. Thank you

      Sailendra T
        • 1. Re: ODI with SAP Adapters
          Ayush Ganeriwal-Oracle
          There are two ODI SAP adapters available that allows extraction from SAP ERP and SAP BW. For SAP ERP we allow extraction from ERP tables, but not from RFCs/BAPIs. You can find details on that at http://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html The documentation was created for 10g release but still valid for 11g.

          In our performance comparison we found significant improvement against competition. The actual performance, of course, depends on many, many things ranging from SAP HW, network, complexity of query etc.

          • 2. Re: ODI with SAP Adapters

            Thank you for your valuable inputs. Would you please elaborate on the performance gain after using the ODI SAP Adapters with statistics ? What was the tool you were using prior to ODI ?

            You inputs are highly appreciated.

            Sailendra T