CAPSTORM
 The Salesforce Backup, Restore, & Scripting Experts

SQLForce

 SQLForce makes Python a powerful scripting language for manipulating a Salesforce database.

  • SQLForce is FREE!
  • Installs using a standard "python setup.py install" approach.
  • Supports ANSI like INSERT, UPDATE, DELETE, and SELECT syntax (including SELECT DISTINCT, SELECT UNION, and INSERT...FROM SELECT).
  • Overcomes Salesforce governor restrictions, such as the 200 record limit in an UPDATE batch.
  • Makes a natural bridge language between Salesforce and virtually any other data repository.

 

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'

import SQLForce

session = SQLForce.Session('Production',This email address is being protected from spambots. You need JavaScript enabled to view it.','MyPassword')

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!

 Download SQLForce Now

 

SQLForce resources can be found on the Capstorm help site, learn.capstorm.com. A good starting point is the How to Connect to Salesforce using SQLForce article.

There are also a number of example scripts included in the SQLForce download.

 System Requirements:

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.

 SQLForce Installation:

Using the standard mechanism for a python installation, simply type in the same directory as the downloaded setup.py file:  python setup.py install

SQLForce News

  • SQLForce is Capstorm's gift to the Salesforce developer community. Happy Scripting!

    Download SQLForce Now 

    "I've been using SQLForce for years, and it's (no joke) seriously one of my go-to tools for Salesforce DBA.  I use it for manually querying and updating records, and for scripting CSV-to-SalesForce updates from our users." - Troy Morrison


    SQLForce Documentation for helpful examples and articles on learn.capstorm.com

    Check out:

    Import Multiple Tables from Excel

    Import or Export Attachments