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, MySQL, 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.
