Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 24, 2012 05:21 PM by Rajesh Sawant
Apr 24, 2012 04:56 PM|LINK
I am really confused with the difference between Store procedure and Web services.
Web Service providing service to end user as per request.
And Web Service having methods and its implementation may be with Database.
Any way we have to use Database in webservice.
Like that, We can use the Store procedure in our application or any where which we want to use for our need.
Then What is the major difference between those things.?
In my point of view, I have found a small one, which when we created a web service and provide to some other then we dont want to give them the DB details. and we just done the implementation in web services and serve the outputs to end user.
But when we go for Store procedure, We should give the store procedure and DB connection strings to the end users.
This case when we develop a common service like, Updating cricket score and Current Share markets, and so & so.
But Still what is the major difference between those items.
Please help me out.
Thanks & Regards,
Apr 24, 2012 05:20 PM|LINK
Two points which I would like to clear about the WebService.
1. WebService can be used as the independent component with various Secure Methods(SOAP Header / Encryption).
2. WebService can call other WebService internally for hiding business logic.
By considering your Scenario I Suggest you create 2 WebService.
1st WebService Which you will give it to your client / vendor who will just pass the required paramaters.
It will give XML Output which need to be pass to the 2nd Web Service.
2nd Second WebService is hosted at your end and taking all XML as input form 1st Webservice.
Business validation & all DB Operations will be performed with 2nd WebService.
This way you can hind the & Secure your business login, DB Credential from outside world.
In one of our implementations We have consumed all most 5 WebServices internally to
get the desired out put.
Service 1--- > XML ---> Service 2 --- > Process DB
Output <----- Outout <----
I Hope you have got the Clear vision about Webservice Implementation.
Apr 24, 2012 05:21 PM|LINK