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. Note that all of the services below offer free trials, so if you’re responsible for picking one of these services, it’s recommended that you play around with all 3 of them to work out which one works best for you.
#1: 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.
#2: 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.
#3: 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.
What are the differences between JDBC and ODBC, and why should you look for a JDBC driver for Salesforce instead of an ODBC driver?
- JDBC is specific to Java, unlike ODBC which is specific to Windows and uses a C interface. JDBC can therefore be utilized on any OS that supports Java (including Mac and Linux)
- JDBC supports multi-threading, whereas ODBC may not be thread safe
- With JDBC, multiple implementations may exist in one application
- JDBC does not require manual installation