Huge data flow from Sap to DB

[Former Member]

Hello,

In one of my scenarios, I have to send huge amount of data from Sap to DB.

After searching sdn I got to know that we can either use tables or SP but not aware about the best practices so can anyone please help me and suggest best possible approach.

Regards,

Vasant

[Former Member · Accepted solution]

Hello,

I would suggest you to use Proxy and send data in multiple chunks to PI and in addition to that use SP on the receiver side.

Thanks

Amit Srivastava

[iaki_vila]

Hi Vasant,

My few cents, a little trick to insert massive data by Varun Mukund http://scn.sap.com/people/varun.mukund/blog/2010/03/25/fast-bulk-database-inserts-from-sap-piand Kenny Scott performance advices http://scn.sap.com/community/pi-and-soa-middleware/blog/2008/12/05/xipi-file-and-jdbc-receiver-adapt....

On the other hand, the sender system could prepare a several calls in order to avoid a PI jdbc receiver overload, for example you can prepare a ECC job that will call with a thousand registers every time.

Regards.

[former_member184720]

Hi Vasant - When you say huge data, may i know what is the approximate message size you are looking at?

What is the DB operation? Insert/Update/Insert_update?

If you are planning to insert this data into more than one table then the best way is to go for Stored Procedure.

Refer to this threads -

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/24/jdbc-receiver-scenarios-best-prac...

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/20/jdbc-receiver-scenarios-best-prac...

http://scn.sap.com/thread/3222815