Overview - Python Connector for Oracle

Overview

Python Connector for Oracle is a connectivity solution for accessing Oracle databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector enables you to establish a direct connection to Oracle from a Python application via TCP/IP, eliminating the need for the database client libraries. A direct connection increases the speed of data transmission between the application and Oracle database server and streamlines the deployment process since you don't have to distribute any client libraries with the application.

Secure communication

The connector supports encrypted communications using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.

Compatibility

• Python versions from 3.7 to 3.13
• Oracle versions:
• Oracle Cloud (DBaaS)
• Oracle 21c
• Oracle 19c
• Oracle 18c (incl. Express Edition)
• Oracle 12c
• Oracle 11g (incl. Express Edition)
• Oracle 10g (incl. Express Edition)
• Oracle 9i
• Oracle 8i
• Oracle 8.0
• SQLAlchemy
• pandas
• petl

Supported platforms

• Windows 32-bit and 64-bit
• Windows Server 32-bit and 64-bit
• macOS 64-bit and ARM (Apple M1 and M2)
• Linux 64-bit

Note: For details on supported OS versions, check the compatibility page of your Python version.