Netezza

[dusans]

Is there a possibility to connect to Netezza db server?

[Michael Bayer]

dusans wrote:
>
> Is there a possibility to connect to Netezza db server?

to use SQLalchemy with a certain backend, you have to answer these questions:

1. is it SQL ?

2. is there a python DBAPI available ?

yes to both, then a new dialect module can be constructed that interfaces
with this database. I'd advise looking into the 0.6 codebase for
examples.

[dusans]

Netezza = data warehouse appliance server

1. yes its SQL
2. I can connect to it via pyodbc

ok will take a look at it :)

[dusans]

a link to a example would be nice. tnx :)

what would be the simplest interface that only performes SELECT,
INSERT, UPDATE, DELETE (netezza uses standard sql for that...)
since i dont want to create tables with sqlalchemy... netezza has a
bit different syntax and more simple types

btw. netezza is a PostGres derivative for DataWarehousing

[dusans]

Anyone wana help? :)
Or is there a tutorial.. guide on how to do it?

Is it more easy to do in 0.6???

i really want to do it :)