Aqua Data Studio does the Magic Again! Salesforce Connectivity!

by Apr 17, 2019

Howdy, y'all! 

I am here again with another cool Aqua Data Studio blog. I would like to credit this blog post to my colleague for setting it up internally for me to post. 

We will be exploring on how to connect to a Salesforce instance using the Simba JDBC drivers from Simba Corporation to accomplish the task.


Pre-requisites

  1. Download Simba JDBC drivers from the Simba Corporation website at:

    https://www.simba.com/drivers/salesforce-odbc-jdbc/ 

  2. Extract the file.
  3. You should receive an email from Simba with a ".lic" file, download it.
  4. Put ".lic" file in the extracted folder for Simba JDBC directory.
  5. Copy force-wsc-41.0.0.jar and partner-44.jar from the Simba JDBC folder and paste into Aqua Data Studio install directory.

    For example:

    C:\Program Files\Aqua Data Studio 19.5 – 64bit\lib\drivers 

  6. Fill out server properties like the below screenshot in Aqua Data Studio using the JDBC Connection Type: 

       

Please make sure you replace localhost with your Salesforce URL.

Now try connecting: 

Congratulations!

You have successfully connected to Salesforce using Aqua Data Studio – the Universal Database IDE and Visual Analytics Tool!