Download Salesforce JDBC Driver

Download the Salesforce JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Salesforce JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Salesforce. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Salesforce driver uses its own syntax — see the connection details below.

The Salesforce JDBC driver

Salesforce is the world's leading CRM platform, storing customer, lead, opportunity, and support data in its cloud database (Salesforce Objects). The JDBC driver exposes Salesforce objects as SQL tables, enabling standard SQL tools to query and report on CRM data.

The Salesforce JDBC URL

• Required File(s): dbschema-salesforce-jdbc-xxx.jar
• Java Driver Class: com.dbschema.salesforce.SalesforceJdbcDriver
• URL:
  • jdbc:dbschema:salesforce://
  • jdbc:dbschema:salesforce://tables=all
  • jdbc:dbschema:salesforce://sessionid=PARAM
  • jdbc:dbschema:salesforce://sessionid=PARAM&tables=all
  • jdbc:dbschema:salesforce://user=...&password=...
• Website: GitHub Salesforce Open Source JDBC Driver

Download Salesforce JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

The DbSchema Salesforce JDBC Driver is Open Source

The driver is built by the DbSchema team and is free and open source. The driver source code can be found on GitHub.

Visit GitHub Driver Source Code

Set Up the Salesforce Connection

There is no server, no port and no firewall here — Salesforce is reached over HTTPS. One step catches out nearly everyone connecting for the first time: the password field does not take your password.

1. Get a security token. In Salesforce open View Profile Settings at the top right, then Reset Security Token in the left menu. The token arrives by email.
2. Append the token to the password. In DbSchema's password field type your web login password immediately followed by the security token, with nothing between them. A correct password on its own is rejected as invalid credentials, which is why this looks like a wrong password rather than a missing token. Resetting the token invalidates the old one, so every saved connection has to be updated.
3. Use the host that matches the org. Production is login.salesforce.com. A sandbox is a different host — commonly test.salesforce.com or a My Domain address such as yourdomain.sandbox.my.salesforce.com. Pointing a sandbox user at the production host fails authentication.
4. Choose what the driver exposes. The Connection Mode combo offers entries with and without custom objects, and entries that authenticate with an existing session id instead of a password. An org with many custom objects reverse engineers faster when you ask only for the ones you need.

You can register for a free trial account at https://login.salesforce.com/ to try this out.

DbSchema and Salesforce

DbSchema connects to Salesforce using the open-source JDBC driver and renders Salesforce standard and custom objects as tables in the schema diagram. Use the Query Builder to compose SOQL-equivalent SELECT queries against Salesforce records.