Python Connector for Oracle
Python Connector for Oracle boxshot
Version
1.4.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only, not for production
Operating Systems
Windows 32-bit and 64-bit, Windows Server, macOS 64-bit and ARM (Apple silicon), Linux 64-bit
System Requirements
Python 3.10 to 3.15. Windows 32/64-bit, Windows Server, macOS 64-bit and Apple silicon, Linux 64-bit. Oracle 8.0 to 26ai or Oracle Cloud. Direct mode needs no Oracle Client
File Size
4.34 MB
Release Date
10/22/2026
Last Updated
11/17/2026
11 views 0 downloads
DB API 2.0 Python connector for Oracle, Direct mode without Oracle Client

Devart Python Connector for Oracle: Oracle Access from Python, With or Without Oracle Client

Devart Python Connector for Oracle is a paid Python database module, $74.95 a year for one developer, that connects Python 3.10-3.15 code on Windows, macOS and Linux to Oracle Database from 8.0 to 26ai and Oracle Cloud. Its Direct mode talks to the server over TCP/IP without Oracle Client, and its OCI mode uses an installed Oracle Client or Instant Client when you need it.

Oracle shops often have a mix of servers, some current and some a decade or two old, and Python scripts that have to reach all of them. Devart's connector covers that whole range with one pip package, plus built-in SSH and HTTP tunnels and Oracle-specific options such as SYSDBA connections and auto-login wallets.

Quick facts

  • Version: 1.4.0, released October 22, 2026; first released December 1, 2023
  • Developer: Devart
  • Package: pip install devart-oracle-connector, or wheel files from Devart's download page (4.34 MB for Windows, 6.39 MB for macOS, 4.21 MB for Linux)
  • Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
  • Servers: Oracle 8.0, 8i, 9i, 10g, 11g, 12c, 18c, 19c, 21c, 23ai and 26ai, Express Editions of 10g, 11g and 18c, and Oracle Cloud (DBaaS)
  • Client: none in Direct mode; Oracle Client 8.0 to 26ai or Instant Client in OCI mode
  • Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
  • Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
  • Trial: 30 days, for evaluation only, not for production use
  • Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription ($149.95 perpetual, $189.95 a year for Team, $339.95 for Site), and PyPI and Devart's download page both showed version 1.4.0 with wheels for Python 3.10 to 3.15, on November 17, 2026. We didn't run it against an Oracle server

Download Free Trial Buy Now

Overview

You import devart.oracle, call connect() with a Host, Port (1521 by default), UserName and Password, and either a ServiceName with Direct=True or a SID through an installed client. From there it's the familiar DB API pattern: a cursor, execute() with ? placeholders, and fetchall().

One detail to know up front: Direct mode is off by default, so a plain connection expects Oracle Client on the machine. Set Direct=True to drop the client entirely, which is what most new deployments will want. A license is activated in code with devart.oracle.license.activate("<key>").

Features

Direct mode: no Oracle Client

Devart Python Connector for Oracle's Direct mode connects to Oracle Database or Oracle Cloud over TCP/IP with no Oracle Client or Instant Client, so a script can be deployed to many workstations or containers with a pip install. Version 1.3 allowed passwords over 30 characters for Oracle 23 in Direct mode and fixed self-signed SSL certificates there.

From Oracle 8.0 to 26ai

Devart Python Connector for Oracle supports every major Oracle release from 8.0 to 26ai, including Express Editions. Version 1.4 added Oracle 26ai and the native JSON type of Oracle 21c and later; version 1.3 added Oracle 23's BOOLEAN type.

Administrative and secure connections

Devart Python Connector for Oracle can connect as SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG or SYSKM through its ConnectMode parameter, which DBA automation scripts need. It also supports auto-login wallets (since 1.3), SSL/TLS, SSH tunnels and HTTP/HTTPS tunnels with bearer tokens.

Pools, batches and LOBs

Devart Python Connector for Oracle pools connections with min and max size, lifetime and validation settings, and sends several update statements as one batch. It maps Oracle types, including CLOB, BLOB and BFILE, to Python types, with options to change the mapping, and is Unicode-compliant.

Benefits

  • No client installs. Direct mode removes the Oracle Client or Instant Client step from every machine and Docker image.
  • Old servers covered. One driver for Oracle 8i, 9i or 10g systems that free drivers no longer reach without a matching client.
  • DBA tasks in Python. SYSDBA and other privileged connect modes are built in.
  • A vendor behind it. Paid support and yearly releases that follow new Python and Oracle versions.

Real-World Uses

  • Migrating off a legacy system. A script reads from an Oracle 9i or 10g database and loads the rows into PostgreSQL or a cloud warehouse.
  • DBA automation. A Python job connects as SYSDBA to check tablespaces or run maintenance across many instances.
  • Reports through a jump host. An analyst queries a production database that is only reachable over SSH.
  • Containerized services. A Python microservice on Linux reaches Oracle Cloud with no Instant Client baked into its image.

Who It's For, and Who Should Skip It

The connector suits Python developers and DBAs in Oracle shops who need to reach old servers without matching Oracle Clients, want SSH or HTTP tunnels built in, or whose company prefers a commercially supported component.

Skip it if you only work with Oracle 12.1 or newer: Oracle's own free python-oracledb driver runs without a client in its Thin mode on those versions and is well supported. Skip it too for open-source or hobby projects, since the license forbids building public Python packages on it, and for Python 3.9 or older.

Usage Guide

  1. Install with pip install devart-oracle-connector, or download the zip of wheels for your Python version and platform and run pip on the .whl file.
  2. After buying, copy the activation key from the order email or Devart's customer portal and run devart.oracle.license.activate("<key>") once.
  3. Connect without a client: conn = devart.oracle.connect(Direct=True, Host="ora01", Port=1521, ServiceName="ORCLPDB1", UserName="report", Password="..."). Add ConnectMode="SysDBA" for a privileged session.
  4. Query: cur = conn.cursor(), cur.execute("SELECT * FROM orders WHERE status = ?", ["OPEN"]), cur.fetchall().
  5. For a service, turn on pooling with devart.oracle.connection_pool.enabled = True.

Before you buy

Code written for python-oracledb or cx_Oracle uses named or numbered bind variables (:name, :1) and its own connect arguments, while Devart's examples use ? and parameters such as Host and ServiceName, so porting takes some edits. The subscription license checks its status online, so a server with no internet access needs the perpetual license.

Where it falls short

  • Direct mode isn't the default. Forget Direct=True and the connector looks for Oracle Client.
  • Not open source. You can't inspect or patch it, and shipping it inside a product needs an OEM license.
  • Linux is 64-bit x86 only. There's no ARM Linux wheel.
  • Per-developer licensing. A Single license covers one user; a team of up to four needs the Team license.

Comparisons

Devart vs. python-oracledb

python-oracledb, Oracle's free successor to cx_Oracle, is the standard Oracle driver for Python, with a client-free Thin mode for Oracle 12.1 and later and a Thick mode that uses Oracle Client for older servers. Devart Python Connector for Oracle costs $74.95 a year but connects to servers back to Oracle 8.0 without a client and adds SSH and HTTP tunnels. For modern servers the free driver is the sensible default; Devart earns its price with legacy servers or tunnelling needs.

Python connector vs. Devart's ODBC driver for Oracle

Devart's ODBC Driver for Oracle ($179.95 a year for a desktop) serves Excel, Power BI, SSIS and any ODBC tool, plus Python through pyodbc. If Python is your only client, this $74.95 connector costs less; if reports and scripts both need Oracle, the ODBC driver covers both.

Editions and Pricing

License1-year subscriptionPerpetualWho can use it
Single$74.95$149.95One developer at one company site
Team$189.95On the order pageUp to 4 developers at one company site
Site$339.95On the order pageUnlimited developers at one company site

Buy Now opens the order with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for distributing the connector with your own product is arranged with Devart separately.

FAQs

Does Devart Python Connector for Oracle need Oracle Instant Client?

No, not in Direct mode. Devart Python Connector for Oracle connects over TCP/IP without any Oracle Client when you pass Direct=True; without it, the connector uses an installed Oracle Client or Instant Client (OCI mode).

Can it connect to Oracle 11g or older from Python?

Yes. Devart Python Connector for Oracle lists Oracle 11g, 10g, 9i, 8i and 8.0 as supported servers, and Direct mode reaches them without a client.

Can I connect as SYSDBA?

Yes. Devart Python Connector for Oracle's ConnectMode parameter accepts SysDBA, SysOper, SysASM, SysBkp, SysDG and SysKM, as long as the user has been granted that privilege.

Does Devart Python Connector for Oracle support Oracle 26ai?

Yes. Version 1.4, released October 22, 2026, added Oracle 26ai and the JSON data type of Oracle 21c and later.

Does the subscription keep working offline?

No. Devart Python Connector for Oracle's subscription license needs an internet connection to activate and check its status, and stops when the term ends. The perpetual license runs a specific version without a subscription.

Can I get a refund on Devart Python Connector for Oracle?

Possibly. Devart Python Connector for Oracle's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.

System Requirements

  • Python 3.10, 3.11, 3.12, 3.13, 3.14 or 3.15 with pip
  • Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
  • Oracle Database 8.0 to 26ai or Oracle Cloud (DBaaS)
  • Oracle Client or Instant Client only for OCI mode
  • Internet access for activating and checking a subscription license

Conclusion

Devart Python Connector for Oracle is worth $74.95 a year when your Python code has to reach Oracle 11g or older without installing matching clients, or when SSH and HTTP tunnels built into the driver save you real setup work. If all your servers are 12.1 or newer, Oracle's free python-oracledb already runs client-free and is the better default. Run the 30-day trial against your oldest server first; that's where this connector proves its value.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.