Python

Python to SQL Server, Python to Oracle, Python to MS Access, Python to Salesforce.com, Python to MongoDB, Python to DB2 connectivity from Linux and Unix.

Python is a cross-platform, object-oriented programming language with support for writing database client applications.

Python’s functionality can be extended with third-party modules. For example, a module may add new functionality by linking a Python program to binary libraries written in C such as an ODBC driver manager.

To access a database, Python needs a database module. Python database modules that conform to the Python Database API (DB-API) specification can be used to access relational databases from Python.

The tutorials in this section show how to connect Python to remote databases such as SQL Server, Oracle, Salesforce.com, MongoDB, DB2, Access, Derby by using the ODBC-enabled DB-API modules pyodbc and mxODBC.

You can then access ODBC databases from Python scripts and Python applications such as Zope and Plone running on Unix and Linux.

Tutorials and Resources

Connecting to ODBC Databases from Python with pyodbc
Accessing MS SQL Server, Oracle, Salesforce.com, MongoDB, DB2, Sybase ASE, InterBase, MS Access, Derby from Python with pyodbc.
Connecting to ODBC Databases from Python with mxODBC
Accessing MS SQL Server, Oracle, Salesforce.com, MongoDB, DB2, Sybase ASE, InterBase, MS Access, Derby from Python with pyodbc.
Python ODBC Code Samples
ODBC examples written in Python.