Java Database Connectivity (JDBC) has been around for a number of years and is widely used to connect to cloud databases, including the popular Salesforce which has continued to see strong growth. If you’re working in a medium to large sized company that needs to quickly and easily access Salesforce data it’s imperative that you choose the right driver that not only offers all the features you’ll need, but is also 100% reliable and offers the right support.
Although Salesforce doesn’t offer their own JDBC driver to connect to its service, there are a number of third-party solutions listed below. It’s recommended that you play around with all 4 of them to work out which one works best for you.
#1: Reliersoft’s driver
In 2016, Reliersoft released a free Salesforce JDBC driver, which claims to offer significant performance improvements and ease-of-use enhancements. Currently this is the only 100% free driver available, with no limited trial period.
#2: DataDirect from Progress
Progress is a well established, publically-traded software company that was first established in 1981 and currently has just over 1,000 employees. DataDirect is one of the companies signature products, which beyond JDBC also offers ODBC, ADO.Net and OData interfaces, and connects to a wide range of data sources beyond Salesforce.
#3: Simba’s driver
Simba, like Progress, is a well established company offering both ODBC and JDBC drivers for Salesforce, which supports JDBC 3.0 and 4.0 and ODBC 3.8. Simba’s driver allows users to easily access Salesforce data which can then be exported to BI and analytical tools such as Excel or Tableau.
#4: RSSbus from CData
RSSbus from CData connects to a wide range of applications and can be used through popular IDE’s, including Eclipse. It offers CRUD support (Create, Read Update, and Delete) and smart caching to increase application performance. As with Simba and Progress’ drivers, RSSBus can be tested free of charge.