+ Start a Discussion
ClaiborneClaiborne 

Salesforce ODBC Connector

Last Jannuary, I talked to OpenAccess, a developer of toolkits for developing ODBC connectors, about using their product to build a connector to Salesforce.com. Although I got a 30-day trial, developing the actual connector was beyond my skills.

Last week OpenAccess contacted me about a beta version of an ODBC connector for Salesforce.com. You can download the beta version at:

http://www.openaccesssoftware.com/support/SalesF-Files-Index.asp

The installlation requires that your computer have the  Microsoft.Net framework runtime installed (obtainable from http://www.microsoft.com/downloads/details.aspx?FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en).

Once you install everything (about 10 minutes), you can use the  ODBC connector to link any ODBC-compliant app to your Salesforce database.

At present, there is no pricing or licensing cost on the web site. The beta license expires on September 27. Also, the ODBC connector only supports the SELECT statement, so no UPDATE or CREATE at the moment.

I testing it by creating an ODBC connection in Excel using the new salesforce ODBC connector as my source. I could then point/click to select from all the tables in my account, including custom objects.

Lots of possibilities here, but this is all the information I have. If you want more info, contact OpenAccess.

openaccessopenaccess

You are welcome to download a preview version of the OpenAccess ODBC Driver for Salesforce.com. It is available at:

http://www.OpenAccessSoftware.com/support/SalesF-Files-Index.asp

The preview version allows read/write access to Salesforce using the SQL commands SELECT, UPDATE, DELETE, and INSERT. It will expose all the objects you have acess to, including any custom objects/fields you have added. Please try it out and give us your feedback.

Using the OpenAccess ODBC Driver for Salesforce allows any application or development tool that is able to access data from databases like SQL Server and Oracle to access your data at Salesforce.com.

OpenAccess Team
http://www.OpenAccessSoftware.com

DatadirectGuyDatadirectGuy

I realize that I'm replying to a very old post, but I figure someone else may come across it via googling just as I have. 

 

OpenAccess was acquired by Datadirect which is part of Progress Software. We've updated our Salesforce offering to include 32- and 64-bit ODBC drivers on all leading OSes, as well as a Type 4 JDBC driver. 

 

We are also in beta with a data access service, Datadirect Cloud.  Same ODBC/JDBC/SQL-based capabilities, but supporting even more cloud sources. A subscription-based alternative to traditional licensing. 

 

Thanks!

 

Greg Stasko

Progress Datadirect