Skip to Content
avatar image
Former Member

PI AEX to JDBC Interface Design

Dear All,

We are working on a interface design for the flow (SAP ECC->PI AEX-->DB)

From SAP ECC, we are expecting around 300,000 records in an ABAP Proxy once per day. Size of one record is equal to 200 Bytes

The requirement is push this file (approx size = 300,000* 200 Bytes = 57 MB (~65 MB XML File)) to a legacy DB. In future the frequency of interface runs can increase from 1 to 5

1. Can we do it using standard JDBC adapter available in SAP PI AEX 7.5 system.

2. Is it better to do a direct DB table insert at the legacy. OR

3. Is it better to do a Stored Procedure Call at the DB

4. Is it better to used a view/temporary DB

Do we have to check any other details within in PI or at the DB before finalizing the design.

Please share your inputs.

Thank you

regards,

Younus

Add comment
10|10000 characters needed characters exceeded

  • Hi Younus´╝î

    Thanks for your posting the question here in SAP Community.

    Regarding the question you asked, you should always provide others with very detailed background information as well as the actual testing result for the scenario you have done. Better to include screenshots which would much easier clear the doubt when they answer your question.

    From what I have read and understand, you are seeking for the way of configuration on how to connect PI to DB. However for the 4th question, I am not quite sure what you are talking about pertaining to your purpose.

    Least but not last , you are actually asking for a consulting issue of how to configure and implement. If you search before raising this thread here, you are able to find official help link talking about this : https://help.sap.com/SAPhelp_nw73/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

    and even we have the Guided Answer Tree for you:
    2513069 - Guided Answers- How to deploy the external drivers for Axis/JDBC/JMS Adapter

    Regards,
    Herman
    SAP Community Moderator

  • Get RSS Feed

1 Answer