function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JCSJCSJCSJCS 

Datadirect ODBC drivers for salesforce.com connectivity?

Anyone using the ODBC drivers from Datadirect?

 

http://www.datadirect.com/index.ssp

 

We use java and soql api to connect. We are also looking for a solution to connect using access / excel (other than queryamp - which we really like.) 

 

I was able to do some pretty complex queries with the odbc driver that cannot be done easily via SOQL.  I was also able to update fields to null.

 

Looking for feedback / limitations.

  

Best Answer chosen by Admin (Salesforce Developers) 
marioluisscmarioluissc
Hi friend!,
I am using the DataDirect ODBC driver.
It is very good, because to make the SQL queries.

Another advantage I found was the integration with other applications. as: Squirrel SQL Client, the report generator iReport.

Any doubts contact,

marioluis_sc@hotmail.com
marioluiscitadin@gmail.com
http://twitter.com/marioluissc

All Answers

marioluisscmarioluissc
Hi friend!,
I am using the DataDirect ODBC driver.
It is very good, because to make the SQL queries.

Another advantage I found was the integration with other applications. as: Squirrel SQL Client, the report generator iReport.

Any doubts contact,

marioluis_sc@hotmail.com
marioluiscitadin@gmail.com
http://twitter.com/marioluissc
This was selected as the best answer
DatadirectGuyDatadirectGuy

I realize that this is an old thread, but in case someone else comes to it via google...

 

Datadirect now offers both ODBC and JDBC salesforce drivers via traditional enterprise licensing, but we are in beta with a new subscription service called Datadirect Cloud that provides similar SQL access, but does so on a subscription basis. It will eventually provide access to many additional SaaS data sources, including Salesforce.
AndyScaifeAndyScaife

Also worth noting that Easysoft now have their Salesforce ODBC Driver, check it out with a free trail today.
Eli Pogorelov 3Eli Pogorelov 3

Hi, I have a trouble understanding how to implement an ODBC driver for FORCE.com I would really appreciate if someone can make it more clear for me. The story goes like this :
There is a client side program (an old one) called Hashavshevet, the DB of this program sits on MySql, and the data can be read directly with ODBC.
 There is now free driver for FORCE.com so my idea is :
1.use the JDBC to ODBC in java to connect with MySql of Hashavshevet.
2. Make a WSDL out of it.
3. Upload it to cloud as SaaS
4. make an APEX class out of WSDL and call it every time a DB change required.
I am not sure at all if it is a reasonable solution, or is it possible, I would really appreciate any help. Thanks.