JDBC Introduction

Our JDBC driver allows its users to browse and update the database that sits behind salesforce.com, using many of your favourite database tools, such as:

We expose useful information about Salesforce objects via JDBC meta data api, so tools like SQL-Workbench make it really easy to learn more about your objects without having to click through lots of web pages in Salesforce. Take note of the "Remarks" column for this sample table:

We can produce PDF reports using Jasper Reports iReport (hot tip: Register the Stuntbyte driver on the "Services" window):

Tools like DbVisualizer, and especially Execute Query make it easier to understand the relationships between your objects.

The JDBC Driver integrates with Eclipse, so you can use it from within the Force IDE if you use that tool as your development platform. Don't forget to try out our own mini-IDE though -- we think it's far more productive!

It does NOT turn Salesforce into a fully compliant SQL database. In particular, it does NOT add support for arbitrary joins, but it does offer the following enhancements to Salesforce SOQL:


UPDATE

The SQL UPDATE, including the ability to refer to other columns. eg:
1
2
UPDATE Lead SET FirstName = LastName, LastName = FirstName
WHERE FirstName = 'Smith'

DELETE

The SQL DELETE command. eg:
DELETE FROM Lead WHERE FirstName = 'Smith'

SELECT *

This is worth the price of admission alone.
SELECT * FROM Lead

SELECT with column aliases:

1
2
SELECT FirstName as fn, LastName as ln, CreatedDate, CreatedBy.name as cn
FROM Lead

SELECT COUNT(*)

SELECT COUNT(*) FROM Lead