I want to fetch the data from sql server into salesforce visual force page.Is there any specific approach for this?Please help me with this.

  • You can't execute SQL in Apex in native. Apex support SOQL. Approach is the integration with SQL which is a different and complex thing to do. – Ashwani Aug 14 '15 at 6:23

I've no personal experience of this, but Salesforce's External Objects mechanism is one approach. This allows an external table to be accessed in your org via largely the same SOQL API that your internal Salesforce objects (tables) are accessed by. I believe at present the access is read-only.

From a quick Google here is a blog post on the subject Creating a Salesforce External Data Source using an OData Service Created in .Net from Giovanni's Blog.

|improve this answer|||||

Not the answer you're looking for? Browse other questions tagged or ask your own question.