Currently we are carrying out a piece of integration work between Drupal and Salesforce. Drupal is responsible for pulling the data from Salesforce and this achieved by calling the SOQL api via a webservice. The data is returned in a SOAP format. This article assumes you are using this salesforce client

http://sourceforge.net/project/showfiles.php?group_id=96634&package_id=1...