mxODBC Django Database Engine

eGenix.com · Products · Django · mxODBC Django Database Engine - ODBC Database Adapter for the Django Web Framework

mxODBC Django Database Engine

Using our mxODBC Django Database Engine, you can connect your Django-based websites to all ODBC compliant databases and data sources - in a hassle-free, robust and scalable way.

Please note that this product is discontinued.

Version: 1.2.0

Download

Evaluate

Buy Now

Introduction

The mxODBC Django Database Engine™ product allows you to easily connect your Django website to just about any database backend on the market today, giving you the reliability of the commercially supported eGenix.com product mxODBC and the flexibility of the ODBC standard as middle-tier architecture.

ORM and Native Database Access

With the mxODBC Django Database Engine 1.2, you receive two ways to connect to your databases:

access all your Microsoft SQL Server databases using the native Django ORM integration we provide for MS SQL Server 2005, 2008 and 2012, or
tap into the powerful SQL-based mxODBC Database Interface directly from within Django and access databases such as MS SQL Server, Oracle, IBM DB2 and Informix , Sybase ASE and Sybase Anywhere, MySQL, PostgreSQL, SAP MaxDB, and many others.

Cross Platform Database Access

mxODBC Django Database Engine works on Windows, Linux, Mac OS X and FreeBSD, providing you with the same consistent interface, flexibility and robustness across all of these platforms.

ORM support for more database backends will follow in future releases. If you're interested in a particular backend, please let us know and we can adjust the priorities.

Features

Fully integrated with the Django ORM: No need to learn a new API - simply continue to use the known Django ORM interface.
Compatible with Django LTS: The mxODBC Django Database Engine supports Django 1.4 (LTS) and 1.5.
Compatible with all recommended Python versions: The database engine supports Python 2.6 and 2.7; both as UCS2 (narrow) and UCS4 (wide) Unicode variant on Unix platforms.
Full Unicode Support: The database engine can communicate with the database using native Unicode and 8-bit encodings such as UTF-8 or CP1252.
Full 64-bit Support: The underlying mxODBC 3.2 library fully supports 64-bit platforms such as Mac OS X 10.6 (Snow Leopard) or later, and 64-bit Linux systems that use unixODBC, iODBC or DataDirect ODBC managers.
Cross-platform Connection Objects: The database engine will automatically choose the right platform specific ODBC manager for you.
Per Connection Adjustable ODBC Manager Interface: mxODBC supports many different ODBC managers. The mxODBC Django Database Engine allows you to select the ODBC manager on a per-connection basis.
Per Connection Customization of Interface Parameters: The database engines allows adjusting many different parameters to adapt the engine to your specific database needs, should you have special requirements.

MS SQL Server ORM Features

MS SQL Server fully integrated into the Django ORM: Access MS SQL Server through the Django ORM, just like any other Django ORM database.
MS SQL Server Regular Expression Emulation: Even though MS SQL Server itself does not support regular expressions, the mxODBC Django Database Engine provides an emulation for simple regular expressions to simplify porting existing applications to a SQL Server backend.
MS SQL Server Aggregate Function Support: We provide a special aggregate function implementation to have the Django ORM support SQL Server aggregate functions.
MS SQL Server Timestamp Support: SQL Server support millisecond accuracy on timestamps. The database engine will take care of applying the necessary rounding for the microsecond precision Python timestamps in a seamless way.
Support for all popular SQL Server ODBC drivers: The mxODBC Django Database Engine supports the MS SQL Server Native Client on Windows, the MS SQL Server Native Client for Linux, as well as the FreeTDS ODBC driver. Commercial drivers from well-known driver vendors are also supported.
Support for accessing SQL Server from Windows and Unix platforms: On Windows and Linux you can use the SQL Server Native Client, on other Unix platforms and Mac OS X, the FreeTDS driver or other commercial drivers can be used.

Direct mxODBC Interface to other Databases

Access IBM DB2, Sybase ASE, Oracle, Teradata, Netezza, etc. directly through the proven mxODBC Database API: Import, query and save data directly to the databases using a simple to use API and all available database specific SQL dialects, capabilities and features, including ones for which the Django ORM does not provide support.
Fully Python DB-API 2.0 compatible interface: mxODBC support the Python DB-API 2.0, including many standard extensions and the full set of ODBC catalog methods for database introspection.
Full transaction control: When using the mxODBC Database API, you get full control over the database connections, including opening them on demand, in auto-commit mode, dynamically scaling the number of connections per request, etc.

System Requirements

The mxODBC Django Database Engine includes all software needed to connect Django to an ODBC manager. However, it does not include an ODBC manager or any ODBC drivers. You have to have these installed in order to be able to use the mxODBC Django Database Engine.

Windows:

On Windows, the situation is very simple: most databases come with ODBC drivers and register them with the Windows ODBC manager that's part of every Windows system.

Please consult the ODBC driver documentation for details on how to setup ODBC data sources. The mxODBC Django Database Engine Administration and User Manual also includes a section on this topic and some helpful hints in case you run into problems.

Linux, FreeBSD, Solaris, AIX:

On Unix, you will have to install one of the popular ODBC managers iODBC, unixODBC or DataDirect and then register the ODBC drivers for your database with these ODBC managers.

Linux systems usually come with at least one of these ODBC managers preinstalled. Please see the mxODBC Django Database Engine Administration and User Manual for setup instructions.

Mac OS X:

On Mac OS X, you can use the system system ODBC manager (which actually is a version of the popular iODBC manager). If this is not installed on your system, you can download it from Apple or use the alternative ODBC Manager which is maintained by Actual Technologies.

Please see the mxODBC Django Database Engine Administration and User Manual for setup instructions.

Licensing

The mxODBC Django Database Engine product is a commercial product and made available under the terms and conditions of the eGenix.com Commercial License Agreement, Version 1.3.0 (PDF file).

When purchasing a license for the mxODBC Django Database Engine product, you will receive a digitally signed Proof of Authorization authorizing you to install the product for use within one Django Project Installation, i.e. a Django installation running a single site project.

If you are using Django clusters or multiple Django site projects on a single machine, you will have to buy one Django Project license per Django site project that you want to use the engine with.

Evaluation

If you would like to evaluate the mxODBC Django Database Engine, please request an evaluation license online or send an email to the eGenix.com Sales Team and include the following information: name of the licensee, number of evaluation licenses.

We will then send you the requested number of evaluation licenses. The evaluation licenses have a built-in timeout of 30 days, but are otherwise fully functional.

If you are satisfied with the product, you can then proceed to the next section.

Buy Licenses

Production licenses for the mxODBC Django Database Engine product can be bought via our secure eGenix.com Online Shop which is hosted by ShareIT.com (a service of Digital River). Licenses are sold per Django Project Installation. For quotes on prices, volume discounts, site and corporate licenses please write to sales@egenix.com.

After purchase, you will receive the necessary license files from eGenix.com within two business by email to the address you specified in the ordering process.

If you need to buy licenses for third parties (e.g. as contractor), please consult sales@egenix.com for instructions.

If you have questions about the ordering process, or the needed number of licenses, please write to the eGenix.com Sales Team.

Documentation

The documentation for the mxODBC Django Database Engine and the underlying mxODBC is available in form of PDF files:

mxODBC Django Database Engine Administration and User Manual - HTML and PDF

This manual includes instructions on how to install, configure and use the mxODBC Django Database Engine.

mxODBC Reference Manual - HTML and PDF

The mxODBC Reference describes the included eGenix.com product mxODBC which is used by the mxODBC Django Database Engine to interface to the various database backends.
Please note that the mxODBC package included in the mxODBC Django Database Engine can only be used from within Django and is usually a different version than the stand-alone mxODBC package.

The PDF files are also available as part of the installation in the mxodbc_django/ directory.

Download

A successful installation of mxODBC Django Database Engine requires these two steps:

The downloads below do not contain any license keys. You will either have to obtain evaluation licenses or buy production licenses in order to successfully install and use the package.
Select the right download for your platform and Python version and then head on to the installation instructions below.

IMPORTANT:
By downloading, installing or using the eGenix mxODBC Distribution, you agree to the terms and conditions set forth in the eGenix.com Commercial License Agreement 1.3.0.

Redistribution of these files is not allowed. Please contact the eGenix Sales Team for details about redistribution possibilities and terms.