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

Is there any update? Did you end up using SambaEngine SDK? – Sascha Vetter Aug 11 '16 at 20:21 — Sascha Vetter, Aug 11 '16 at 20:21
@SaschaVetter we end up writing our own driver using c#. – BendEg Aug 11 '16 at 20:22 — BendEg, Aug 11 '16 at 20:22

score 3 · Answer 1 · answered Feb 17 '16 at 00:05

3

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.

answered Feb 17 '16 at 00:05

KylePorter

469
2
6

Yep, read and tried the sdk, but it seems to be a littble bit to expensive for my needs. If you need more features than i do, it is brilliant and really, really good... – BendEg Feb 17 '16 at 11:52
@BendEg, reach out to Simba again and identify yourself in reference to this post, perhaps there's something that can be done. – KylePorter Feb 18 '16 at 00:21

Tunnel ODBC queries to REST endpoint

1 Answers1