Skip to Content
Former Member
Dec 29, 2010 at 07:14 AM

When to go for JDBC Stored Procedure - Pros and Cons


Hi Experts,

To integrate PI with database through JDBC adaper, what is the best approach and when should we go for Stored procedure? What all factors need to be considered while deciding to go for Stored procedure or normal Select and update statement. In my case i have a scenario where i need to pick data periodically from 7 different tables and around 90 fields and need to update the tables for the records which has already been processed what should be the best approach for this integration.