Hi Simon,

I actually hadn't heard of this db, but nevertheless, did a quick search on the internet to see if there are any JDBC drivers for it and it doesn't look like there are. This means you would have to try and connect to it using the jdbc-odbc bridge (i.e. this is the way you were connecting to your FoxPro database).

So, you would have to create an ODBC Data Source (the Jade website says they've got an ODBC driver) and then try and connect to it via the jdbc-odbc bridge as described in this other Forum Post. This may or may not work first off depending on a few factors like whether the ODBC driver supports standard SQL or not. And if it doesn't work then if you would like, we could certify the ODBC driver with Yellowfin (i.e. make the neccessary modifications so that YF does work with it).

Please let us know how you get on with it.

regards,
Dave

I also found that Jade sell an add on for connection to BI tools.

There relational population service (RPS) duplicates all Jade data into MS SQL so that it is easily accessible.