Hi Team, I see that there are multiple approaches to call a stored procedure from WSO2 ESB/EI layer.
1. Using the DBReport mediators 2. Using the Data Services concept. My scenario is simple - my proxy service will get a message over a queue, and i need to invoke the stored procedure to insert data into a database. I am not sure what could be a better approach to go with - either create a data source and then use the mediators (so all code in one proxy service itself), Or use the data service approach, and have my proxy call this data service to do the job. I understand if there are multiple proxy services that need to invoke the same stored procedure, then it might be better to have a common data service. But i am not sure what more advantage does it add? Can you please list the prons and cons of both approaches and what might be the scenarios when mediators approach would be more beneficial over going with the data service approach? -- Best regards, Sanjay Bawri
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
