[Glass] ODBC to GemStone and ODBC from GemStone

Hi Mariano,

The question of an ODBC interface for GemStone/S comes up periodically and is a particular interest of mine. It turns out that the hard part is not the Windows ODBC stuff (I've got a proof-of-concept that works with Excel, Access, etc. and sends queries to GemStone/S through the GCI library). The difficult part is translating SQL to Smalltalk and mapping heterogeneous collections of objects into something that looks like a fixed-schema table with homogenous rows of similar and simple columns (i.e., not complex objects). My proof-of-concept used a very simple schema and only supported enough SQL for the limited demo.

The primary question is whether there would be commercial demand for an ODBC solution that would cover the cost of development (rough estimate of many person-months to get basic functionality, a few person-years to get something really polished).

The approach I've typically taken and seen is to export a CSV file (comma-separated-values) from GemStone/S and let Excel handle things from there.

James

On Oct 1, 2013, at 6:37 AM, Mariano Martinez Peck <[hidden email]> wrote:

Hi guys, 

I remember a presentation about GemStone status and future in which you mention ODBC. At that moment I was interested about it and I asked. It was supposed to be included in some version of GemStone. This "ODBC" you were talking about was NOT an ODBC client as I imagined, but the other way around: that any ODBC client from any language could query GemStone. So first question, was this released? what is the satus?

Say I want to build some reports using Java (JasperReports or whatever) would I need "GemBuilder for java"?  Seems a bit overkill to me since it is not a whole client/server application. That's why I was asking about ODBC. Of course, there could be other workarounds but just wondering.

Finally, I guess there is no generic ODBC client for GemStone right, so the only relational DB I can connect right now is Oracle (with GemConnect product)? Has anyway workarounded the scenario where you had to interact with another relational DB than Oracle?

Thanks in advance, 

--
Mariano
http://marianopeck.wordpress.com

_______________________________________________
Glass mailing list
[hidden email]
http://lists.gemtalksystems.com/mailman/listinfo/glass

Hi Mariano,

For your information: in Yesplan, we use Jasper reports to produce reports.
Data is exchanged between Gemstone and Jasper reports via a CSV-formatted data over an http connection.

Johan

On 01 Oct 2013, at 15:37, Mariano Martinez Peck <[hidden email]> wrote:

> Hi guys,
>
> I remember a presentation about GemStone status and future in which you mention ODBC. At that moment I was interested about it and I asked. It was supposed to be included in some version of GemStone. This "ODBC" you were talking about was NOT an ODBC client as I imagined, but the other way around: that any ODBC client from any language could query GemStone. So first question, was this released? what is the satus?
>
> Say I want to build some reports using Java (JasperReports or whatever) would I need "GemBuilder for java"?  Seems a bit overkill to me since it is not a whole client/server application. That's why I was asking about ODBC. Of course, there could be other workarounds but just wondering.
>
> Finally, I guess there is no generic ODBC client for GemStone right, so the only relational DB I can connect right now is Oracle (with GemConnect product)? Has anyway workarounded the scenario where you had to interact with another relational DB than Oracle?
>
> Thanks in advance,
>
>
> --
> Mariano
> http://marianopeck.wordpress.com

> _______________________________________________
> Glass mailing list
> [hidden email]
> http://lists.gemtalksystems.com/mailman/listinfo/glass

_______________________________________________
Glass mailing list
[hidden email]
http://lists.gemtalksystems.com/mailman/listinfo/glass