+ Start a Discussion
sunny_mhl10@yahoo.comsunny_mhl10@yahoo.com 

Insert Record

Hi

 

   Can we insert record into sql database from salesforce on click of customised button in Accounts Object.

 

Thanks

sfdcfoxsfdcfox

Assuming the SQL server is accessible from the Internet or from the local computer, then yes, you can. Possible methods include a REST or SOAP API that can manipulate data (be sure to validate authentication and input), Visualforce code that invokes the server (via Apex Code), Apex Code Web Service methods that invoke the server, Java, Flash, or ActiveX components that call some function to access the database directly or through the platform (direct connections will require likely require security certificates on the machine attempting to call the function). You could also use an Outbound Messaging system as well. The only real limitation with design choices revolves around how much time you have to invest into building a frontend for the SQL server as well as the associated salesforce.com-hosted code.

jagjitsingh@indivar.comjagjitsingh@indivar.com

Hi sfdcfox

 

   Yes sql server is accessible through internet . Can u pls send me a link or example of this

 

Thanks