Simba’s ODBC and JDBC drivers for Salesforce.com enable standard SQL-92 access directly to data, without extraction, via Salesforce’s native web services Application Programming Interface (API).

Salesforce ODBC & JDBC Driver's connectivity diagram | Simba TechnologiesDeliver scalability, full application functionality and real-time analytic capabilities to users. Built upon the SimbaEngine SDK framework, the drivers power comprehensive analytics and reporting.

Perform necessary joins and aggregations which passes down supported operations to Salesforce for increased performance via Simba’s built-in Collaborative Query Execution (CQE) feature. This allows Salesforce to collaborate dynamically on the execution of SQL queries, eliminating redundant processing and passing on the performance gains to users. If an application is Salesforce Object Query Language (SOQL) aware, the Simba ODBC and JDBC drivers for Salesforce.com are configurable to pass the query through. The ODBC driver for Salesforce complies with the latest ODBC 3.8 data standard and adds important functionality such as Unicode and 32- and 64-bit support for high-performance, cloud computing environments. The JDBC driver for Salesforce.com includes support for JDBC 4.0.

Product Highlights

  • Connects via Salesforce’s native web services API
  • Complies with the latest ODBC 3.8 data standard
  • Adds aggregation and join capabilities for queries
  • Direct BI connectivity to data without extraction

Features

  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Microsoft Excel & Access, Tableau, Power BI, Qlik and more
  • Provides full driver and query metadata
  • Adds aggregation and join capabilities for queries
  • Passes down supported operations for increased performance
  • Support for ODBC 3.8
  • JDBC driver supports JDBC 4.0

Specifications

  • Supports Salesforce API Summer 16 (API 37)
  • Supports 32- and 64-bit applications
  • Supports TLS 1.1/1.2
  • Uses OpenSSL 1.0.2
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Supports multiple platforms, including Windows, Linux and Mac OS X
  • Supports ANSI SQL-92
  • Connects via Salesforce’s native web services API

Get Salesforce ODBC & JDBC Drivers with SQL Connector

Easy SQL access to Salesforce.com: Enable users to access, analyze, and report on data with the SQL-based tool of choice.

Download Now 30 Days Free Trial

Questions? Ready to Buy?
Let's talk.

We'll get back to you within the next business day.

Evaluation and Sales Support
If you are evaluating our drivers or our SimbaEngine X SDK, our Sales Engineers would be happy to assist you. If you are ready to buy or you require licensing information, please complete the form provided, or contact us by email or phone:
+1-604-633-0008 x2 or connectivity@magnitude.com

Customer Technical Support

If you are a customer, please use our Magnitude Customer Support Portal