The Simba Salesforce JDBC Driver provides access to Salesforce data in BI and Analytics Tools. In this blog we show you how to connect DbVisualizer to your Salesforce-based data using Simba’s Salesforce JDBC Driver
DbVisualizer is a database tool for developers, DBAs and analysts. 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 writing your own JDBC application.
Using this tool, you will be able to execute SQL-92 queries against Salesforce and report your Salesforce-based data in a relational view.
DbVisualizer does not come with the Salesforce JDBC Driver, so you must add the driver to the application.
- Start by clicking Tools > Driver Manager
- Click the + icon to add a new driver
- 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 Open
- The Driver Class field is now populated with the driver’s class name.
- In the URL Format 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
To enable logging; set the URL Format field to jdbc:salesforce://localhost;LogLevel=6;LogPath=C:\Users\simba\logs
This will create driver logs in the C:\Users\simba\logs folder.And this point the driver is loaded and the URL added & the Driver Manager window can be closed by clicking the ‘X’ icon on the top right.
- Open the connection wizard: Tools > Connection Wizard
- Name the connection as ‘Salesforce’ and click ‘Next’
- Select the ‘Simba Salesforce driver’ from the driver drop down and click ‘Next’
- Fill in the Database Userid, Database Password & the Database URL, and check the “Auto Commit” box. Click Finish
To enable logging; set the Database URL field to jdbc:salesforce://localhost;LogLevel=6;LogPath=C:\Users\simba\logs
This will create driver logs in the C:\Users\simba\logs folder. - You should now be able to view Salesforce backend tables under Databases tab. Under connections – Salesforce.
- Using the SQL Commander menu, select the ‘New SQL Commander’ option, choose your connection.
You are now able to run SQL-92 queries on your Salesforce backend. Type your query into the window and then click the green run icon. - Congratulations! The contents of Salesforce Account table are now displayed in a tabular format.
