DataDirect OpenAccess ODBC Driver for Salesforce

OpenAccess ODBC Driver for Salesforce enables any ODBC compliant application to access all your data at Salesforce.com in real-time using SQL as the language. Easily create custom reports using Microsoft Access, Crystal Reports, Excel, Microsoft Report Services, and many others. Perform integration by using the many available tools that already know how to talk to data sources that are SQL compliant. Write C/C++, .NET, Perl, or Java programs to use ODBC for accessing your Salesforce data. Expose the data in Salesforce through Oracle and SQL Server without the need to do bulk transfers. You can even access the Salesforce data from Unix applications like Brio, Business Objects, Cognos, Mercator, and Oracle, to name a few.

OpenAccess ODBC Driver for Salesforce is built using the DataDirect OpenAccess SDK. This is the same technology that has been licensed by over 100 ISVs and corporations to implement custom ODBC, JDBC, OLE DB, and ADO.NET connectivity to their application data.

Download | Buy

Product Highlights

  • OpenAccess ODBC implementation offers a high level of compliance to the ODBC specifications. This guarantees compatibility with any application written to the ODBC specification and with applications that are compatible with SQL Server, Oracle, Sybase, DB2, and other commercial RDBMS.
  • The included SQL engine supports SQL to allow queries with joins, unions, nested query, stored procedures, insert, update, delete, group by, order by, and other SQL syntax to be executed over all of your data in Salesforce.
  • Optimized query execution is achieved by passing portion of the SQL query to Salesforce.
  • Makes use of the latest Salesforce API to provide you complete access to your data. Current version supports API version 9.0.
  • Support for proxy servers allows the use of driver on systems that must go through a proxy server for internet access.
  • All data access is performed through the Salesforce Web Service API and this guarantees all your security settings are enforced and all communications over the internet is encrypted with SSL.

Additional Information

DataDirect OpenAccess ODBC Driver for Salesforce supports read and write through the support for SELECT, UPDATE, INSERT and DELETE queries to any Salesforce object you have access to. The ODBC driver complies with Microsoft ODBC 3.51 specifications and is fully compatible with hundreds of ODBC compliant application in use. Extensive SQL support allows you to query a single table or perform joins between one or more tables. You also have access to the ordering and aggregation features of SQL. Please refer to the OpenAccess SQL Guide for details of the supported SQL. Refer to the OpenAccess ODBC Driver for Salesforce User's Manual for details on installing and using the driver.

Enhancements in Version 1.3 include:

  • Support for sforce 9.0 API — this allows you to take advantage of all the latest capabilities.
  • Better optimization — more of the conditions in the SQL query are now pushed down to Salesforce for processing.
  • Increased timeout — reduce errors related to timeout of the connection.
  • Support for localized numeric formats — correctly handles non USA regional settings that effect numeric values.
  • Faster data dictionary lookup — table definitions are cached as they are used by the client application.