Most importantly, SQLForce will save you time, a lot of time, by replacing complicated data import/export operations (using DataLoader or an Excel connector) with short scripts. An example of hours saved with a short script:
Normalize all versions of Contact.MailingCountry to use 'USA'
countryNames = ['US','U.S.','United States','America','United States of America']
session.runCommands("UPDATE Contact SET MailingCountry='USA' WHERE MailingCountry IN ('" + "','".join(countryNames) + "')" )
Capstorm is pleased to offer SQLForce at no charge. It is free, so download and begin scripting today!
Java 7 (or above) - If you don't already have Java 7 (or above), download and install java from Oracle's download site.
SQLForce connection to Salesforce is through the API. The Salesforce API Package must be enabled. Enterprise, Unlimited, and Developer Editions have this feature enabled by default.
Using the standard mechanism for a python installation, simply type in the same directory as the downloaded setup.py file: python setup.py install