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.
 
 

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.
 
 

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.