Tunnel ODBC queries to REST endpoint

Question

Is there an easy way to tunnel SQL-Queries which are send to an ODBC-Driver to a restful api, without writing my own ODBC driver using C/C++?

I need to do this, because i want redirect some odbc queries to a restful api. For example:

|----------|             |--------|                         |---------|
| Database |  <- read -  |  ODBC  | - send data to write -> | Restful |
|          |  - Write -> | Driver | <-     read data      - |   API   |
|----------|             |--------|                         |---------|

The database server (sql-anywhere) will embed the ODBC source as a remote server, so that i can read and write from it.

Thank you very much

Answer 1

One way you can do this is by using the SimbaEngine SDK (http://www.simba.com/drivers/simba-engine-sdk/), which takes care of most of the ODBC work while letting you implement the communication pieces. You're still writing a driver (in C++, Java or C#), but the code required is much simpler and there's much less of it.