function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sunay_psunay_p 

Integrate Salesforce with SQL Database using Apex code(without any tool)

Hi,

 

I am looking at an option where I can integrate Salesforce with SQL database using a salesforce API.

 

Can anybody help me with the steps involved and how much complex it is to write the code. Also any sample code would be very helpful.

 

Thanks in Advance!!!

 

Regards,

Sunay

EnthEnth
You need to put in some middleware, you cannot write to/from a SQL database and Salesforce.com without something between such as an ETL (Informatica, CastIron, etc or ESB tool, or custom code. See the Java/PHP/.Net community listings and samples if you want to code it manually.
sunay_psunay_p

Thanks for the reply!!

 

So is it possible to write a webservice on my salesforce instance, which then can be called from the SQL platform with my WSDL. If yes, can you help me with some sample code or the logic to have the code.

 

 

pavan@sforcepavan@sforce
Plz help me by posting some code samples realting to your discussion.
Thanks