MS SQL XML - outbound SOAP requests from native SQL

Author

outbound SOAP requests from native SQL

brandon.richter@gmail.com

2006-11-07, 7:16 pm

Hi everyone

I'm trying to find a way to query data from a web service and bring it
back into SQL to join with other relational data already in the
database. From what I've read you're required to compile an assembly
(which serves as a middle tier between the database and web service)
and register that assembly in sql server. Your T-SQL query then calls
the assembly which calls the webservice to get the data.

1. Is this correct?
2. If there was so much effort to make SQL procedures exposed via
webservice, why can't SQL do the opposite? I think that consuming a
webservice is much easier than providing it... is this a feature that
no one asked for in SQL server?
3. I can't seem to find any documentation on what is required in these
assemblies... does anyone have any good links on how to write one of
these?

Thanks!
Brandon

Han

2006-11-24, 12:17 am

Hello

You are saying SQLCLR. Type the word in MSDN search box and you may see some
walkthrough as the first result.

Interesting question is #2. One thing is Microsoft makes the CLR not for
webservice but for including whole dotnet framework functionalities. Now
they become so lazy as not to do anything more;;

<brandon.richter@gmail.com> wrote in message
news:1162912948.288024.140830@e3g2000cwe.googlegroups.com...
> Hi everyone
>
> I'm trying to find a way to query data from a web service and bring it
> back into SQL to join with other relational data already in the
> database. From what I've read you're required to compile an assembly
> (which serves as a middle tier between the database and web service)
> and register that assembly in sql server. Your T-SQL query then calls
> the assembly which calls the webservice to get the data.
>
> 1. Is this correct?
> 2. If there was so much effort to make SQL procedures exposed via
> webservice, why can't SQL do the opposite? I think that consuming a
> webservice is much easier than providing it... is this a feature that
> no one asked for in SQL server?
> 3. I can't seem to find any documentation on what is required in these
> assemblies... does anyone have any good links on how to write one of
> these?
>
> Thanks!
> Brandon
>

Sponsored Links