Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vermorel
Starting Member
26 Posts |
 Posted - 2006-12-18 : 05:40:38
|
| I am one of the developer of [url]http://www.lokad.com[/url], an online provider of time-series forecasting. Basically a customer can upload its data and download its forecasts through web services.In order to facilitate the integration of Lokad, we are currently considering a solution that use the CLR integration of SQL Server 2005 so that our customers could be able to interact with the Lokad Web Services directly through SQL.Question: is-it a "no-no" to call Web Services from the SQL Server? Should such processing stay outside the DB Server or not? (possible issues are performance and security)Does anyone has a clue?Thanks in advance,Joannès[url]http://www.vermorel.com[/url] |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-18 : 07:50:55
|
create a web service interface on your web server and let that access the server.i personally wouldn't let sql server access webservices.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
Calling web services from SQL server with CLR?