PI AEX to JDBC Interface Design

[former_member216353]

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

[herman_lin]

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

[Liz_]

Hi Younus,

Of course, you can use the jdbc receiver adapter provided by PI. For the direct insert or stored procedure, it depends on many circumstances. Please check the following blog about the detailed differences and decide it according to your data types:

https://blogs.sap.com/2012/09/05/jdbc-receiver-best-practices-scenario-insert-operation-design-part2...

https://blogs.sap.com/2012/09/07/jdbc-receiver-scenarios-best-practices-stored-procedure-design-part...

Best Regards,

Liz