You need to sign in to do that
Don't have an account?
openaccess
SQL access to salesforce.com data
We at OpenAccess Software are debating the value of providing SQL compliant access to saelsforce.com and would appreciate any comments. The objective is to provide a ODBC driver that allows the use of full SQL to perform read and write operations against any salesforce.com object. This would allow the use of MS Office, Crystal, and 100's of other applications to quickly access your data.
Thank You
However, for complex SQL operations, like reporting/OLAP, it makes much more sense to use a DB replication tool (there are several available in the marketplace) to run against a local copy of the data.
Mike
Mike,
Can you please expand on what value you would see from SQL/ODBC connectivity? Also, I'm not sure why complex queries cannot be done directly against the data source without the need to replicate. Our SQL engine is fully capable for doing JOINS, GROUPING, and all the other SQL operations people use to perform reports and queries. Also we optimize operations like JOIN processing and other operations to reduce the number of trips we have to make to the server. Many ISVs license OpenAccess for their products in order to avoid the need for replication.
As for read/write, that can be controlled during the set up. And all updates occur using the sforce API so all checking inherent at thay layer would be applied before the data is actually changed.
Thank you.
I warn about write access because you may get some 'power users' who may accidentally change data when attempting queries through common tools like MS Access. The SForce API is nice, but it won't prevent a user from changing items such as the name or address of a company. At the same time, it would be great to be able to write to SFC through ODBC/SQL so that special code doesn't have to be written.
Mike