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
LeeCLeeC 

Sales Force - External Connection

Hello, we are looking at getting our developer to write a little program to somehow connect to sales force and pull information which is normally displayed in a report. The reason we are doing this is to get data to automatically refresh and if for some reason the connection to SF drops the information will still be displayed. My question is what is the best way to make an external connection to SF? Is it possible to run SQL queries or connect using web services? Any information I could pass on to our developer would be great!

 

Many Thanks,


Lee

hamberghamberg

Depends on the language - there are some code samples available for querying into SF: http://wiki.developerforce.com/index.php/Tools

 

These all work pretty well.  You need to follow Salesforce's SOQL language protocols which is similar to SQL.

EIE50EIE50

Hi, you could use web services in order to connect & pull data from SF.