Best ways to insert data into Oracle databases from PI.

[Former Member]

Dear All,

Currently PI insert query takes very long time while Inserting into Oracle database, This data PI gets from SAP BAPI call after filter.

What are the best ways to achieve to get rid of performance issue while inserting data into Oracle database from PI?

Thanks in Advance.

Best Regards,
Sateesh

[iaki_vila · Accepted solution]

Hi Sateesh,

From my point of view you can talk with your basis team to do a SP and to prepare the inserts with the volume that you test with best performance. If the table has a large number of indexes the insert operation will take long time. You have to figure out what is the best number of inserts in one shoot.

Regards.

[Former Member]

Dear All,

Thanks for all your suggestions.

finally I approach SP call and XML string as input.

Thank you

Sateesh

[Former Member]

Hi,

How many tables data gets inserted to? if there are many different tables then I would suggest to prepare a stagging table - instert all the data into that table and let oracle stored procedure insert the data into different table independently.

thanks

chirag

[anand_shankar10]

Go for a stored procedure as suggested by Iñaki Vila

Its efficient.

Thanks..

[former_member182412]

Hi Sateesh,

Have you checked these blogs from Raja.

Regards,

Praveen.