The SQuirreL SQL client provides a simple graphical interface to relational databases. Because it is built using Java, it can access any JDBC-compliant database running on any machine, allowing remote access to multiple databases. For this example we are showing you how you can connect Salesforce data through SQuirreL SQL using a Salesforce JDBC Driver.

Installing the Salesforce JDBC Driver:

  1. Each machine where you use the Simba Salesforce driver must have Java Runtime Environment (JRE) 6.0 or later installed. Install JRE or check the installed version on your Windows machine. Open command prompt and type:
  2. Download an evaluation of Simba’s Salesforce JDBC driver. Be sure to select Java (JDBC) for the platform. Depending on your use case select either Desktop or Server from the drop-down list.
  3. Extract the Simba_Salesforce_JDBC.zip archive that you just downloaded. The extracted folder contains a “docs” subfolder, and another ZIP archive.
  4. Extract the SimbaSalesforceJDBC4-{current-version}.zip archive. The extracted folder contains .jar files for the Salesforce JDBC driver.
  5. A license file was emailed to you when you downloaded the driver. Locate this file and save it to the same directory where you extracted the .jar files.

Configuring the Salesforce JDBC Driver:

To connect to a Salesforce server, you must configure the Simba Salesforce JDBC Driver to use the authentication mechanism that matches Salesforce access requirements. To determine the authentication settings that your Salesforce server requires, check Salesforce account configuration and then refer to the corresponding Salesforce JDBC documentation.

For this example, we are going to be connecting to Salesforce using “User Name and Password” authentication. Our connection URL will be as follows:

In your own connection URL, replace {userid} and {password} with your actual user name and password. For example, given the user name “janedoe” and the password “12345”, you would put together the following connection URL:

If you are using a sandbox account, then you must include an “endpoint” option at the end of the URL. For example:

By default the Simba Salesforce driver sets the endpoint to: https://login.salesforce.com/services/Soap/u/41.0

For information about the Salesforce API versions that the driver is compatible with, see the “Specifications” section on our Salesforce product page

Before connecting to the data store, you need to know the name of the class to use with your application. Choose the appropriate class name listed here. For this example, the Class Name is: com.simba.salesforce.jdbc4.Driver.

Running the Salesforce JDBC Driver with your SQuirreL SQL:

  1. Open SQuirreL and click the Drivers tab.
    SQuirreL SQL drivers
  2. Click the + icon to add a new driver.
    SQuirreL SQL add New Driver
  3. Fill out the driver information:
    • The Name can be any name that you want to use to identify the driver in SQuirreL.
    • In the Example URL field, type your connection URL. Refer to the “Configuring the Salesforce JDBC Driver” section above.
    • In the Class Name field, type your class name. Refer to the “Configuring the Salesforce JDBC Driver” section above.

    SQuirreL Add Salesforce Driver

  4. Load Salesforce’s .jar files by clicking the Extra Class Path tab and then clicking Add.
    Load Salesforce in SQuirreL add Jar Files
  5. Navigate to the directory where you extracted the .jar files, select all of the .jar files, and then click OPEN.
    SQuirreL SQL Select All Jar Files
  6. Click OK and check that the driver registered successfully. This is indicated in SQuirreL by a message outlined in green.
  7. SQuirreL SQL sucess registration

  8. Click the Aliases tab at the top, and then add a new alias by clicking the + icon.
    SQuirreL SQL add new alias
  9. Fill out the alias information:
    • The Name can be any name that you want to use to identify this connection.
    • From the Driver drop-down list, select the driver that you created in step 3.
    • If required, fill in the User Name and Password fields.

    Test the driver connection by clicking Test.
    SQuirreL SQL alias add driver test

  10. In a pop up connection window, check that User Name and Password fields are populated correctly, and click Connect.

    If you successfully connected, close the dialog boxes by clicking Ok twice. You are now ready to connect and run SQL queries against Salesforce. 9_SQuirreL_TestConnectSuccess

  11. Double click the alias that you created.
    SQuirreL SQL Salesforce alias created
  12. Double check that the User Name and Password fields are populated correctly, and click Connect.
  13. On the SQL tab, you are now able to run SQL-92 queries. Type your query into the window and then click the Run icon.
    SQuirreL SQL Command Run
  14. Congratulations! The results of your query from SQuirreL to Salesforce using Simba’s Salesforce JDBC driver will be displayed.
    Salesforce Squirrel Results

For the list of tables, schemas, columns and metadata you can also explore the Object tab.