Apex Code Development You need to sign in to do that
Don't have an account?
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.
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
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