0

unable to connect sql server with salesforce directly using API's. Using Http API we can connect to sql, but please any one confirm that sql server is having webservice api's or not?? I want to write an apex class where i want to use Http(rest api) and integrate with salesforce but i can't due to unavailability of sql server http api.

Improve this question
1
  • look for data integration middleware like informatie, boomi, ... there are loads out there.
    – Samuel De Rycke
    Feb 23, 2014 at 17:03

1 Answer 1

Reset to default
1

As far as I know:

SQL don't have such type of interface or web-service in built. But there are two ways you can achieve Salesforce integration with SQL DB

  • Develop your own interface. A web-service implemented on windows or other instance which can work as an Interface between SQL and Salesforce. Interface can have some exposed service URLs which can perform operation for you. This type of approach has been implemented several places using .NET and other technologies.

  • Next approach is install some SQL connectors/adapters available in market. But they are all paid, provide that required interface for you.

In most scenarios "Jitterbit" tool is used.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .