What is the best way to access a web service

• Brian Carlson

  SSCarpal Tunnel

  Points: 4170

  More actions

  January 10, 2012 at 11:29 am

  #262685

  What is the best way to access a web service from SQL Server 2008 R2? I have read about CLR and also about using the Service Broker. I'm not sure if the Service Broker will work for this or not. The web services I'll need to access have not been written yet but they will be in Java rather than .Net if that makes a difference.

  Thanks,

  Brian.

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 10, 2012 at 2:28 pm

  #1431413

  What is it for ?

  You can do it in a SSIS package as well.

• Brian Carlson

  SSCarpal Tunnel

  Points: 4170

  More actions

  January 11, 2012 at 12:46 pm

  #1432067

  I have two needs for this.

  The first is geocoding addresses and getting the latitude, longitude. I may use Bing for this but I'm open to other ways.

  The second is to get data real-time from another division of our company. They are publishing this via a web service written in Java.

  Thanks,

  Brian.