+ Start a Discussion
SFC7SFC7 

Invoke Sql Server SP from Salesforce Apex

Customer wants to interact Salesforce with external database like SQL server to get the real time data into the Salesforce for the Sql server database when action performed.

Can anyone help out to achieve this.
BW Developer DaveBW Developer Dave
You'll have to use some kind of middleware application. There is no way for SFDC to communicate directly with an MS SQL server. You'll either need to build a middleware app yourself or use an existing ETL tool like Jitterbit or Scribe. 
SFC7SFC7
Thanks for your reply!

Middleware app or Webservice or ETL Tools are not cloud based things if i'm not worong, but we wanna acces SQL server data through visualforce page up on user request, please do let me know if any thoughts on this!

Thanks in adnavce!
Ramu_SFDCRamu_SFDC
The following posts might answer your question

http://salesforce.stackexchange.com/questions/12217/sql-server-integration-with-salesforce
https://developer.salesforce.com/forums?id=906F00000008xnXIAQ
SFC7SFC7
Thanks for your chain mail!

I have gone through the links you posted but they are not related to pull data from SQL server through salesforce APEX!

Thanks again!
 
BW Developer DaveBW Developer Dave
Like I said before you can't do direct Apex -> MS SQL server communication. You have to use some kind of middleware application to handle the communicaiton. 

I'm not here to lie to you :)
SFC7SFC7
I know it is a true and thanks for your truths!

Can you give your thoughts to achieve this using webservice instaed of Etools!!

SFC7SFC7
Folks! Still this is outstanding!

I'm welcoming to take any suggestios upon to accomplish this webservice/callouts except Etools.

Thank you in advance!