DataDirect OpenAccess for ODBC for Salesforce Data Source

DataDirect OpenAccess for ODBC for Salesforce Data Source enables any ODBC compliant application to access your data at Salesforce.com in real-time using SQL as the language.

Fast, real-time, secure access to your Salesforce data from any ODBC compliant application, including:

  • Access
  • Crystal Reports
  • Excel
  • MS Reporting
  • SQL Server

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.

Also available for ODBC-based UNIX and Linux applications such as:

  • Brio
  • Business Objects
  • Cognos
  • Mercator
  • Oracle

DataDirect OpenAccess for ODBC for Salesforce Data Source 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 13.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.
  • Definitions of the objects (tables) are cached during their use in a connection.
  • Allows connection to production or sandbox Salesforce data.

Additional Information

DataDirect OpenAccess for ODBC for Salesforce Data Source 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.52 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 for ODBC for Salesforce Data Source Installation and User's Guide for details on installing and using the driver.

Enhancements in Version 1.5 include:

  • Better optimization — more of the conditions in the SQL query are now pushed down to Salesforce for processing. For example, count(*) type of queries are pushed down to Salesforce.com for processing. Optimizations in JOIN processing improve performance by reducing the number of times Salesforce.com is accessed over the Internet.
  • Connection retries — reduces errors related to timeout of the connection. The driver will reconnect if a timeout is detected. This is transparent to the client application.
  • Batch updates and deletes — update and delete operations that affect more than one row are performed in batches. This dramatically reduces the time required to make these changes and reduces the number of Salesforce.com API calls.
  • ODBC setup dialog with more options — control the behavior of the driver per DSN by setting the options in the ODBC setup dialog box. For example, one DSN can be setup to go to the production Salesforce.com and another to a sandbox.
  • Support for sforce 13.0 API — this allows you to take advantage of all the latest capabilities.
  • Automatic configuration of the server as a service – in the client/server configuration, the OpenAccess Server is registered as a service during the installation.
  • Now supports Microsoft Office 2007 – use the latest versions of Access and Excel with the desktop version of the driver.