Workbench/J is a free SQL query tool that helps developers to run SQL scripts (either interactively or as a batch) and export/import features. This tool can help troubleshoot required components for a JDBC application to connect to the data source, or it can be utilized to test JDBC drivers without requiring to write your own JDBC application.
Using this application you will be able to execute SQL-92 queries against Salesforce and report your Salesforce-based data in a relational view.
In this blog we show you how to connect SQL Workbench/J to your Salesforce-based data using Simba’s Salesforce JDBC Driver
- SQL Workbench/J does not come with the Salesforce JDBC Driver, so you must add the driver to the application. Start by clicking File > Manage Drivers
- Click the Create a New Entry icon
- Name the driver “Simba Salesforce”. Load the .jar files by clicking the folder icon
- Navigate to the folder containing your extracted Salesforce driver files (the same folder with the license file), Select all the .jar files in the folder and click OK
- The Classname field is now populated with the driver’s class name.
- In the example URL field, type the connection URL.
If you are using a sandbox account, then you must include an “endpoint” option at the end of the URL. For example: jdbc:salesforce://localhost; endpoint=https://test.salesforce.com/services/Soap/u/44.0
By default the Simba Salesforce driver sets the endpoint to: https://login.salesforce.com/services/Soap/u/44.0
- Click File > Connect Window
- Select the Simba Salesforce driver from the driver list, fill in the Username and Password, and check the “Autocommit” box.
- You are now able to run SQL-92 queries on your Salesforce backend. Type your query into the window and then click the Run icon.
- Congratulations! The results of your query from SQL Workbench/J to Salesforce using Simba’s Salesforce JDBC driver will be displayed.