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:
- Execute Query
- SQL Workbench/J
- SQuirrel SQL
- Jasper Reports
- Mogwai ER Designer NG
- DBViewer (Eclipse plugin -- ideal for use with the Force IDE)
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):
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:
UPDATEThe SQL UPDATE, including the ability to refer to other columns. eg:
DELETEThe 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:
SELECT COUNT(*) FROM Lead