CODEWITHSUNDEEP
sqlsql-serverdatabaset-sqlclr
Jindřich
Jindřich

Reputation: 27

Is it possible to call a web service from SQL Server?

Is it somehow possible to call a web service from SQL Server without using CLR and get response immediatly back(not powershell, etc..)?

Upvotes: 1

Views: 257

Answers (1)

Ronen Ariely
Ronen Ariely

Reputation: 2434

SQL Server provide a lot of different options to execute external scripts or connect to other devices. SQLCLR is one of the best but not the only option

  • From SQL 2016 you can use R or you can use Python, which let basically do what ever you want if you have permission.

  • You can use xp_cmdshell to execute commands

  • You can use OLE Automation objects (here is a nice sample).

  • You can use auditing tools (not recommended for most of these cases since these run in the background and not only when you need them), which allow you to execute external scripts on event

  • You can use simple QUEUE in the server side. In the Sp you can simply add message to the QUEUE and using external service app you can execute anything that you want once a new message get to the QUEUE. This option can be very useful since the execution is done asynchronous.

I can probably think about a lot more options... but let's start with these :-)

Upvotes: 1

Related Questions