FYI. I no longer have access to Netezza, so I'm not working on this anymore.
A Django Netezza DB backend that uses ODBC by employing the pyodbc library.
Currently, this is in a very, very experimental state. For one thing, I've only tested this with read-only operations, because that's all I need at the moment. I have only tried very simple models and simple queries and have not tested anything with foreign keys, full-text search, etc.
- Django 1.3
- pyodbc 2.1.8 or newer
- Netezza ODBC driver
Install pyodbc.
Add the directory where you have copied the project files to your Python path. So, for example, if you have the following directory structure:
/home/user/src/django-netezza | +- netezza | +- pyodbcyou should add
/home/user/src/django-netezza
to you Python module search path. One way to do this is setting thePYTHONPATH
environment variable:$ export PYTHONPATH=/home/user/src/django-netezzaNow you can point the
ENGINE
setting in the settings file used by your Django application or project to the'netezza.pyodbc'
module path:DATABASES = { 'default': { 'OPTIONS': {'dsn': 'NETEZZA'}, 'ENGINE': 'netezza.pyodbc', }, }
New BSD LICENSE
This project is a fork of django-pyodbc and so most credit goes to the folks who worked on that:
- Ramiro Morales http://djangopeople.net/ramiro/
- Filip Wasilewski (http://code.djangoproject.com/ticket/5246)
- Wei guangjing http://djangopeople.net/vcc/
- mamcx (http://code.djangoproject.com/ticket/5062)
The Netezza modifications were made by Marc Abramowitz of BlueKai (marc at nospam bluekai dot nospam com).