[Zope-dev] ODBC to the ZODB?

[Casey Duncan]

I gave thought to implementing an ODBC interface to ZCatalog/ObjectHub, b=
ut in=20
doing some research I stumbled on "XML for Analysis". Its an web services=
=20
protocol for extracting data from data sources.

Its currently supported by MSOffice (and I think the support extends to o=
ther=20
OLAP aware windows apps), and it saves us from writing *any* client-side=20
drivers which is a good thing(tm).

Have a look at:

http://www.xmla.org

and MS has an excellent tech doc at:

http://msdn.microsoft.com/library/en-us/dnxmlspec/html/xmlanalysis.asp?fr=
ame=3Dtrue

Its at least some food for thought...

-Casey

On Monday 14 April 2003 03:11 am, Johan Carlsson [EasyPublisher] wrote:
> At 12:04 2003-04-14 +1000, Richard Jones said:
> >On Monday, April 14, 2003, at 11:42 AM, Stephan Richter wrote:
> >>On Sunday 13 April 2003 21:32, Richard Jones wrote:
> >>>Has anyone done any work or even had any ideas about having ODBC acc=
ess
> >>>to the ZODB? Possibly using gadfly as the SQL engine?
> >>>
> >>>This would be incredibly powerful to have...
> >>
> >>I started a long time back something called the ZOQL, which aimed at=20
making
> >>relational like queries to the ZODB; however, I found that SQL is not
> >>applicable to the ZODB.
> >
> >Gadfly already provides the relational queries with arbitrary (well,=20
> >organised) data behind it. You write a class that supports gadfly's ta=
ble=20
> >interface and have any code you like behind it. It's really quite neat=
 :)=20
> >There's just no ODBC interface in front of it ;)
> >Richard
>=20
> Hi Richard,
> I think one have to contemplate the use-cases of such an efford.
> I agree with Stephan that SQL is not appropriate for accessing data
> in the ZODB.
>=20
> In my opinion a SQL interface would be much more usable with
> the ZCatalog, even though there are allot of stuff that are missing in
> Catalog for providing most SQL commands it is an appealing thought.
>=20
> For integration and access of data in the ZODB I think WebServices
> would be much easier and in the long run give more.
> First thing, off course, would be to provide SOAP capabilities to the=20
> ZPublisher.
> Next thing would be to provide WSDL capabilities to Products and ZClass=
es.
> And finally provide an UDDI Service.
>=20
> That's my 25-cents anyway.
>=20
> Best Regards,
> Johan Carlsson
>=20
>=20
> --=20
> Easy Publisher Developers Team
> Johan Carlsson
> johanc@easypublisher.com
>=20
> Mail:
> Birkagatan 9
> SE-113 36  Stockholm
> Sweden
>=20
> Phone +46-(0)8-31 24 94
> Fax +46-(0)8-673 04 44
> Mobil +46-(0)70-558 25 24
> http://www.easypublisher.com
>=20
>=20
>=20
>=20
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev@zope.org
> http://mail.zope.org/mailman/listinfo/zope-dev
> **  No cross posts or HTML encoding!  **
> (Related lists -=20
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope )
>=20