Features
OpenAccess ODBC for Salesforce

Version 1.3 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 SQL supported by the OpenAccess SQL engine refer to the OpenAccess ODBC Driver for Salesforce User’s Manual for details.

Enhancements in Version 1.3 include:

• Support for sforce 7.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 handle non USA regional settings that effect numeric values.


• Faster data dictionary lookup – Table definitions are cached as they are used by the client application.