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.

  1. Start by clicking Tools > Driver Manager
  2. Click the + icon to add a new driver

    Add New Driver

  3. Name the driver “Simba Salesforce”. Load the .jar files by clicking the folder icon
    Name New Driver and Click Open
  4. 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
    Select JARs
  5. The Driver Class field is now populated with the driver’s class name.
    Salesforce Driver Class
  6. In the URL Format field, type the connection URL.Salesforce URLFormat

    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.

  7. Open the connection wizard: Tools > Connection WizardConnectionWizard
  8. Name the connection as ‘Salesforce’ and click ‘Next’
    New Connection Wizard
  9. Select the ‘Simba Salesforce driver’ from the driver drop down and click ‘Next’
    Select Database Driver
  10. Fill in the Database Userid, Database Password & the Database URL, and check the “Auto Commit” box. Click Finish
    Simba Salesforce Driver
    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.
  11. You should now be able to view Salesforce backend tables under Databases tab. Under connections – Salesforce.
    Salesforce Backend Tables
  12. Using the SQL Commander menu, select the ‘New SQL Commander’ option, choose your connection.
    New SQL Commander
    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.
  13. Congratulations! The contents of Salesforce Account table are now displayed in a tabular format.Salesforce DbVisualizer Results

Now it's your turn !